[resolved] How to import a schema exported from mysql server into Talend ?

[resolved] How to import a schema exported from mysql server into Talend ?

Hi,
I am dealing with an old system. Part of its data is dumped everyday, and there is some variability of the data dumped. We can't connect to it, it connect to us. All tutos about db connection are useless. I have the data and the schema in two different file. One contains the data, with no header information ( no column name ) and the other file has all the header information. The second file is in a form of sql. It has the create statements for both the databases and the tables.
My question is: What component, if they exist, do I need to use to read the schema information from the sql file containing the create statement.
I want to know anything about connecting to the old system. It gives me flat files and their structure in sql statement.
I have not parsed the 600 post. But my search did not resulted in anything else than connecting to the database to retrieve the schema, which I can't.
Again, I am searching for a file like "tFileInputSqlSchema" or "tFileInputSqlCreateStatement"
Thank you.
peb

Accepted Solutions
Seventeen Stars

Re: [resolved] How to import a schema exported from mysql server into Talend ?

Its not quite clear for me what you are looking for. if you talking about a Talend schema: The answer is clear, there is not way to define a schema at run time of a job.
If you talk about a database schema and you have a create script you want to run automatically, this is quite easy to do.
You cannot automatically define a job which creates a database schema and reads the csv files according to this schema at the moment. For sure it would be possible to write a component which maps a table schema to a head line of a csv file without need manual interaction but we do not have such component yet in the Open Source release.
In the enterprise release you could use the Dynamic schema feature. This allows you to read an csv file and forward the flow to a database component without you have to know anything about the number or types of the fields.

All Replies
Seventeen Stars

Re: [resolved] How to import a schema exported from mysql server into Talend ?

Its not quite clear for me what you are looking for. if you talking about a Talend schema: The answer is clear, there is not way to define a schema at run time of a job.
If you talk about a database schema and you have a create script you want to run automatically, this is quite easy to do.
You cannot automatically define a job which creates a database schema and reads the csv files according to this schema at the moment. For sure it would be possible to write a component which maps a table schema to a head line of a csv file without need manual interaction but we do not have such component yet in the Open Source release.
In the enterprise release you could use the Dynamic schema feature. This allows you to read an csv file and forward the flow to a database component without you have to know anything about the number or types of the fields.

Re: [resolved] How to import a schema exported from mysql server into Talend ?

Thank for your quick answer. I realize my understanding of the Talend is still not perfect.
From your answer, I can tell there is a problem with the job I am trying to do. The concepts get clearer to me. Thank you.
peb