onesegun
asked on
Manage changing Excel formats during ETL - in principle
Hi there,
I'm currently using Talend Open studio Data Integration to managing the importation of several Excel spreadsheets. However, what I've found is that some of these spreadsheets can change slightly: field names change, what was once single sheets are split into multiple sheets, column orders change.
What I want to know is has anyone encountered these problems in ETL design and is it even possible to overcome these issues and if so what technologies were used? Is it even possible in principle to account for changing Excel formats when importing data into a database?
Thanks,
OS
I'm currently using Talend Open studio Data Integration to managing the importation of several Excel spreadsheets. However, what I've found is that some of these spreadsheets can change slightly: field names change, what was once single sheets are split into multiple sheets, column orders change.
What I want to know is has anyone encountered these problems in ETL design and is it even possible to overcome these issues and if so what technologies were used? Is it even possible in principle to account for changing Excel formats when importing data into a database?
Thanks,
OS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.