Modify Database Connections in .ktr file

[tpsergio]

Dear all,

We have created a kettle transformation to modify a DB from a Dashboard, so we are triggering the transformation using a Kettle over Kettle transformation.

It works succesfully in the staging server (both transformation and dashboard), and now we want to move it to the production server. I'm using my own computer as staging server in this case, so the database connections are different in both servers. This is not a problem for the dashboards, where I can modify the credentials easily, but I'm struggled with the .ktr file.

Please, could you provide me advices about how to modify the database connections for the .ktr file that we upload into the Kettle over Kettle transformation to use the same that the Dashboards use?

Thanks in advance.

Sergio.

[johanhammink]

Use JNDI as database connection. The connection properties are stored outside the ktr files.

[tpsergio]

Thanks a lot!

Use JNDI as database connection. The connection properties are stored outside the ktr files.