our situation is the followin: We are retrieving a lot of data from a REST service, which we want to write to a database. In order to be able to write the data to a database, we need to create metadata in Talend (data type, length, precision and so on). This information cannot be retrieved from the JSON response of the REST service, but the information ist provided in a Excel file listing all tables with their fields, data types, length and precision.
As I do not want to create all metadata objects by hand as this would be tedious for about 80 tables with each 50-100+ columns. I was wondering, if anybody has an idea how to automatically create Talend metadata objects for those tables?
I already had a look at an exported metadata object, but with all the IDs and project files in the export, I am not confident, that that would work.
Any help or experience in this are would be really much appreciated.
Solved! Go to Solution.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.