Using tContextLoad for input tDBConnection but can not get Table Name

[sbytalend]

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?

[Anonymous · Accepted solution]

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.

[sbytalend]

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..

[Anonymous]

Not a problem. Glad to help