Insert and process XML based data reports to MySQL schema.
- or -
Post a project like this$$$
- Posted:
- Proposals: 9
- Remote
- #1889140
- Expired
Senior .NET web developer, AWS, Azure, Linux cloud hosting, Angular development
London
4864554760455445684059515939111929465197140820626502083445
Description
Experience Level: Expert
The task is to insert data from different XML based reports into a MySQL based schema.
We have completed the task already for a few XML reports.
It is necessary now to repeat the task for approx 30 new reports.
The steps you will need to follow are summarised here:
Review the schema of the XML report containing the data. (We will provide the report)
Check the XML schema vs. the corresponding data landing table in the MySQL schema. (these tables already exist for the new reports)
Modify the data landing table if required. (Access to our DBA will be provided if required )
Write a SQL based stored procedure to move the data from the landing table to other tables within the MySQL schema. (Modify these other tables, in conjunction with our DBA if required)
Modify a MS PowerShell script to process the XML data file and then call the stored procedure (a sample script will be provided)
Access will be provided to the database.
A sample XML based report, sample SQL stored procedure and sample MS PowerShell script will be provided.
You need to be experienced in writing SQL based stored procedures for MySQL. You need to be experienced in modifying table structures/schema of a MySQL database. You need to be comfortable dealing with XML. You need to be comfortable with modifying and executing a simple MS PowerShell script.
We have completed the task already for a few XML reports.
It is necessary now to repeat the task for approx 30 new reports.
The steps you will need to follow are summarised here:
Review the schema of the XML report containing the data. (We will provide the report)
Check the XML schema vs. the corresponding data landing table in the MySQL schema. (these tables already exist for the new reports)
Modify the data landing table if required. (Access to our DBA will be provided if required )
Write a SQL based stored procedure to move the data from the landing table to other tables within the MySQL schema. (Modify these other tables, in conjunction with our DBA if required)
Modify a MS PowerShell script to process the XML data file and then call the stored procedure (a sample script will be provided)
Access will be provided to the database.
A sample XML based report, sample SQL stored procedure and sample MS PowerShell script will be provided.
You need to be experienced in writing SQL based stored procedures for MySQL. You need to be experienced in modifying table structures/schema of a MySQL database. You need to be comfortable dealing with XML. You need to be comfortable with modifying and executing a simple MS PowerShell script.
Alan M.
100% (30)Projects Completed
11
Freelancers worked with
20
Projects awarded
38%
Last project
24 Jul 2023
Ireland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies