Four Stars

Talend & PostgreSQL Input Componant error

Hello,
I'm trying to use a table in PostgreSQL 9.4 as an input (tPostGreSQLInput) in a talend job (constructing a simple datamart with odoo tables )

i realize a simple job but iI keep getting this error message 

im using talend data integration v 6.5

Screenshot from 2018-05-10 09-37-23.pngScreenshot from 2018-05-10 09-37-27.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Twelve Stars

Re: Talend & PostgreSQL Input Componant error

First it not seen from Your screenshot - check PostgreSQL version, Talend by default use old (prior 9), but You can use more fresh

 

Second - PostgreSQL not mean tables without schemas

Try to use "product" instead of "" for schema, and "product" for table name 

 

Third, PostgreSQL sensitive for Caps register in names - check this as well, product != Product

-----------
3 REPLIES
Highlighted
Twelve Stars

Re: Talend & PostgreSQL Input Componant error

First it not seen from Your screenshot - check PostgreSQL version, Talend by default use old (prior 9), but You can use more fresh

 

Second - PostgreSQL not mean tables without schemas

Try to use "product" instead of "" for schema, and "product" for table name 

 

Third, PostgreSQL sensitive for Caps register in names - check this as well, product != Product

-----------
Four Stars

Re: Talend & PostgreSQL Input Componant error

thank you the problem is resolved

Twelve Stars

Re: Talend & PostgreSQL Input Componant error

welcome!

what was the problem?

-----------