We will present an end-to-end solution for creation of an XML file, with minimal knowledge on Python, using the source as Teradata (the connection can be modified to fetch from any database), and a configuration file (i.e. excel file).
Extensible Markup Language or XML is a markup language, just like HTML. It is used to store less volume of data without requiring an SQL like structure. It is an open standard recommended for use by World Wide Web consortium.
The Python Standard Library has few packages which are very helpful in working with XML files. To use this one must have fair amount of knowledge on XML files and extensive knowledge on required Python packages and how the same can be used.
The research on how to use the various packages can consume lot of time and resource, and also require technical knowledge.
In this paper, we will present an end-to-end solution for creation of an XML file, with minimal knowledge on Python, using the source as Teradata (the connection can be modified to fetch from any database), and a configuration file (i.e. excel file).
The configuration file will provide the details such as:
· Structure of the XML
· Bound/Unbound nodes/tags
· SQLs to be used for data extraction
Let us deep dive into the solution used:
The configuration file: This is an excel file that contains 2 tabs. The contents of the file can also be placed in a table and data fetched from that, but for my research purpose, I kept the contents in an excel.
Tab1 contains the details for query that needs to be executed, to provide data for the tags in the file. Following are the columns in the tab:
1. Type — This is a unique identifier for the row and is referred again in Tab2 which contains the tag details.
2. Sql — This contains the sql that needs to be executed to fetch the data for the XML.
Are you looking for experienced, reliable, and qualified Python developers? If yes, you have reached the right place. At **[HourlyDeveloper.io](https://hourlydeveloper.io/ "HourlyDeveloper.io")**, our full-stack Python development services...
Looking to build robust, scalable, and dynamic responsive websites and applications in Python? At **[HourlyDeveloper.io](https://hourlydeveloper.io/ "HourlyDeveloper.io")**, we constantly endeavor to give you exactly what you need. If you need to...
In this tutorial, you’re going to learn a variety of Python tricks that you can use to write your Python code in a more readable and efficient way like a pro.
Python is an interpreted, high-level, powerful general-purpose programming language. You may ask, Python’s a snake right? and Why is this programming language named after it?
After analyzing clients and market requirements, TopDevelopers has come up with the list of the best Python service providers. These top-rated Python developers are widely appreciated for their professionalism in handling diverse projects. When...