CODEWITHSUNDEEP
database-connectionpentahokettle
Anders
Anders

Reputation: 8588

Test database connection before step initialization in Pentaho Kettle?

I am currently working on a transformation in Pentaho Kettle. I have numerous steps all depending on the same database connection. The username and password are provided by the user as parameters. If the wrong credentials are provided, every single step that is dependent on the database connection fails to initialize and logs a separate error about it. This results in a great wall of scary red text, that I am afraid will be quite hard to interpret for the intended end user of the transformation.

So, is there any way to test the database credentials before the other steps are initializing and then log a single informative error message if they are incorrect?

Upvotes: 0

Views: 2404

Answers (1)

Rishu S
Rishu S

Reputation: 3968

You can try Check Db connections step in PDI Job. Here you can easily give all the connections that you are using in the job. Finally based on the connection setting, you can define your logic flow.

Hope it helps :)

Upvotes: 1

Related Questions