Create an ETL solution with Altova MapForce for 4 disparate systems
- or -
Post a project like this$2.0k
- Posted:
- Proposals: 2
- Remote
- #687889
- Expired
Description
Experience Level: Expert
Estimated project duration: 3 - 4 weeks
General information for the business: We are integrating systems that have contact information for Leads Processing
Description of requirements/functionality: This is an Extract-Transform-Load (ETL) solution.
I need a Level Of Effort in one of the following buckets of hours: {8 | 16 | 40 | 80 | more than 80}
to use the Altova MapForce tool (http://www.altova.com/mapforce.html) to move data between
Sys 1 & Sys 2
Sys 1 & Sys 3
Sys 1 & Sys 4
The following will be given:
1. the data schema and mappings of all systems
2. the most data of any one system is 10 fields
3. Sys 1, Sys 2 and Sys 3 are SQL Server
4. Sys 4 is a REST API serving JSON or XML
Sys 1 = SalesLogix/Eventix
Sys 2 = Umbraco Contour Forms
Sys 3 = Live Chat
Sys 4 = Call Rail
Once the mapping is done, the executable will be run from a Windows Task Schedule.
Also - let me know if this is something you have done before or if you/team member needs to become educated on the tool.
Specific technologies required: XML, Altova MapForce, .Net
OS requirements: Windows
Extra notes: Given the MapForce tool, it should not matter what the endpoints are. I am in need of someone who can use the tool to connect the fields of the systems and transform the data when necessary.
I know that a pro in the MapForce tool would be able to get through a mapping in about 4 hours. The entire job should be able to be done in 16-20. I would like to hear from the pros if I am correct...or if I better budget higher.
Description of requirements/functionality: This is an Extract-Transform-Load (ETL) solution.
I need a Level Of Effort in one of the following buckets of hours: {8 | 16 | 40 | 80 | more than 80}
to use the Altova MapForce tool (http://www.altova.com/mapforce.html) to move data between
Sys 1 & Sys 2
Sys 1 & Sys 3
Sys 1 & Sys 4
The following will be given:
1. the data schema and mappings of all systems
2. the most data of any one system is 10 fields
3. Sys 1, Sys 2 and Sys 3 are SQL Server
4. Sys 4 is a REST API serving JSON or XML
Sys 1 = SalesLogix/Eventix
Sys 2 = Umbraco Contour Forms
Sys 3 = Live Chat
Sys 4 = Call Rail
Once the mapping is done, the executable will be run from a Windows Task Schedule.
Also - let me know if this is something you have done before or if you/team member needs to become educated on the tool.
Specific technologies required: XML, Altova MapForce, .Net
OS requirements: Windows
Extra notes: Given the MapForce tool, it should not matter what the endpoints are. I am in need of someone who can use the tool to connect the fields of the systems and transform the data when necessary.
I know that a pro in the MapForce tool would be able to get through a mapping in about 4 hours. The entire job should be able to be done in 16-20. I would like to hear from the pros if I am correct...or if I better budget higher.
Troy R.
99% (33)Projects Completed
36
Freelancers worked with
37
Projects awarded
37%
Last project
21 Jul 2020
United States
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