topic Re: Create Database table using Csv inputs in Talend Studio

Create Database table using Csv inputs

med1 — Tue, 14 Nov 2017 15:12:11 GMT

Hello Community,

I want to develop job which allows to create Database table using 2 Csv Files as Input.

One file contains the columns and description of the table and the second one contains the data to be inserted.

also the data file don't have the same schema which means that i should handle the file without specifying the schema.

Any idea how to do it ?!

Re: Create Database table using Csv inputs

TRF — Tue, 14 Nov 2017 15:13:27 GMT

Hi,
Can you share your files description?

Re: Create Database table using Csv inputs

med1 — Wed, 15 Nov 2017 14:44:21 GMT

Hello,

Please find attached an example of file.

Thanks,

BR,

Med

Create table T_Resultat_Test.csv

Re: Create Database table using Csv inputs

Anonymous — Thu, 16 Nov 2017 12:11:24 GMT

My suggestion would be to use the schema file(the one with the table info) to generate a create statement query depending on the database. The design can look something like this,

Once the tables are created, you need to define your input file component with a single column and mention the column datatype as dynamic. (this option works only on enterprise edition if I am correct and also requires your first row to be a header to work properly).

Input Component,

Output Component,

This way you can read the input files dynamically without defining the schema and loading it to the table of your choice.

Please note that the dynamic datatype is not supported for all source and target components. You may want to look for an alternate approach if your job involves complex transformations while loading the data.

Re: Create Database table using Csv inputs

med1 — Thu, 16 Nov 2017 16:47:29 GMT

Hello,

First Thank you for your answers.

For the creation it is OK i handled the file using tJavarow.

To insert data in Oracle DB i followed the process that you suggest, i did the some config, i checked that the Dynamic is authorized for My Oracle DB but i had errors.

Please find attached the error of the execution.

Thanks,

BR,

Med

Erreur.PNG
Erreur_1.PNG
Erreur_2.PNG

Re: Create Database table using Csv inputs

med1 — Thu, 16 Nov 2017 16:52:51 GMT

I found the error thank you.