topic Re: Using tContextLoad for input tDBConnection but can not get Table Name in Talend Studio

Using tContextLoad for input tDBConnection but can not get Table Name

sbytalend — Fri, 15 Nov 2024 22:10:01 GMT

Hi everyone!

Recently I tried to use tFileInputDelimited (csv) combined with tContextLoad for giving input to tDBConnection.

Everything was fine, except when I tried to look for the table name (clicking three dots on the right side of the "Table Name" field):

Sadly, it thrown an error: Database connection is failed. (button 1) Set parameters and continue (button 2) Cancel (button 3) Details >>

And when I click "Set parameters and continue" it show like this (looks like nothing wrong, except red area on the bottom field) :

So, after tried several ways that not working, I change to look the "Table Name" from Metadata ==> Db Connections.

Please kindly help me, what's wrong with my job?

Re: Using tContextLoad for input tDBConnection but can not get Table Name

Anonymous — Thu, 26 Jan 2023 12:12:20 GMT

The tContextLoad is run at runtime. At design time, you will need to be able to connect to your database in order to do things like seek tables. While building your job, it is best to hardcode your connection params. When you are ready to start running, then switch back to the tContextLoad.

Re: Using tContextLoad for input tDBConnection but can not get Table Name

sbytalend — Fri, 27 Jan 2023 02:23:18 GMT

Thanks a lot @Richard Hall ! I've just realized that when I building my job, tContextLoad isn't running, so that's prevent from taking the values for the configuration needed by tDBConfig..

Re: Using tContextLoad for input tDBConnection but can not get Table Name

Anonymous — Fri, 27 Jan 2023 11:34:19 GMT

Not a problem. Glad to help