topic Re: how to import files from talend to postgres database in Talend Studio

how to import files from talend to postgres database

Anonymous — Sat, 16 Nov 2024 13:17:23 GMT

HI all,
I have a csv file which I want to import from the talend into postgresql database. is it possible?
If yes, please tell me the detail steps for this.

Thanks in advance.
Regards,
Manoj

Re: how to import files from talend to postgres database

Anonymous — Tue, 14 Sep 2010 10:45:02 GMT

Hello
It is a simple request, just using to tFileInputDelimited to read the csv file and write the records into postgresql with tPostgresqlOutput component. For example:
tFileInputDelimited--row1--tPostgresqlOutput
Please read the user documentation about their usage.
Best regards
Shong

Re: how to import files from talend to postgres database

Anonymous — Tue, 14 Sep 2010 14:06:11 GMT

HI Shong,
Thanks for reply.
I have a csv file which contains the column names from the table of the postgresql database.
e.g. Name, Contacts/Contact Name, Contacts/City, Contacts/Fax etc.
and data like Microsoft, Sam, NewYork, 012545522

But when I create a new job as told by you tFileInputDelimited--row1--tPostgresqlOutput.
I am getting error
ERROR: relation "public.metadata" does not existERROR: current transaction is aborted, commands ignored until end of transaction blockERROR: current transaction is aborted, commands ignored until end of transaction blockERROR: current transaction is aborted, commands ignored until end of transaction block
where I am going wrong?
What is the solution for this?
Ragards,
Manoj

Re: how to import files from talend to postgres database

Anonymous — Wed, 15 Sep 2010 06:52:49 GMT

Hi,
I run the job successfully, but not getting the data into database.
I don job as : tFileInputDelimited--row1--tPostgresqlOutput
How to get data in database?