Generate Talend metadata objects automatically

[Tobi1]

Hello,

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.

[Anonymous · Accepted solution]

if you define your target DB connection under Metadata->db connections, you can have talend automatically create schema's for all the tables: 

[Tobi1]

Hi JGM,
Thank you that is a very easy and good solution to my problem. I was just fixed in the idea to create file related metadata that I did not think of creating sql scripts to create tables and retrieving the schema then.
I will try that out next week.
Have a nice weekend thanks again.