CODEWITHSUNDEEP
javajdbctalenddata-quality
Sergei K.
Sergei K.

Reputation: 1

How to change the way Talend formulates SQL queries in a JDBC connection?

In Talend Data Quality, I have configured a JDBC connection to an OpenEdge database and it's working fine.

I can pull the list of tables and select columns to analyse, but when executing analysis, I get this :

Table "DBGSS.SGSSGSS" cannot be found.

This is because it does not specify a schema, only the database name - DBGSS.

How can I make it specify database, schema and then the table name ? Or just the table name, its would work too.

Thanks !

Upvotes: 0

Views: 83

Answers (1)

Amine Ben Khelifa
Amine Ben Khelifa

Reputation: 765

You can use a tDBConnection component that give you the right to specify a schéma

Then , use it with the option of Use Existing connection

See below documentation , https://help.talend.com/r/en-US/7.3/db-generic/tdbconnection

Upvotes: 1

Related Questions