topic Re: Importing data to SQL from Excel using Talend in Talend Studio

Importing data to SQL from Excel using Talend

_AnonymousUser — Fri, 23 May 2014 16:45:20 GMT

I am trying to import data to SQL from Excel. I have created a successful connection with the database but while trying to retrieve the schema I am not getting my table, instead I am having the schema of the database (Type CATALOG).
How do I get the schema of the table to which I will export the Excel data?

Re: Importing data to SQL from Excel using Talend

Anonymous — Fri, 23 May 2014 19:46:26 GMT

For which database you have tried to retrieve the metadata ?
If you retrieve the metadata for a database it is quite normal to get at first the CATALOG and under this node probably a schema node and under this a couple of tables.
You can create a metadata node for your excel file as well.

Re: Importing data to SQL from Excel using Talend

_AnonymousUser — Tue, 27 May 2014 17:43:26 GMT

Thank you.
I am working with SQL server and as you explained I found my tables under the database catalog.

Re: Importing data to SQL from Excel using Talend

Anonymous — Wed, 28 May 2014 10:30:34 GMT

Hi,
For more info, please have a look at document TalendHelpCenter:Retrieving table schemas.
TalendHelpCenter:Centralizing File Excel metadata.
Best regards
Sabrina