Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Modify Database Connections in .ktr file

  1. #1
    Join Date
    May 2017
    Posts
    2

    Default Modify Database Connections in .ktr file

    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.
    Last edited by tpsergio; 08-04-2017 at 05:29 AM.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

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

  3. #3
    Join Date
    May 2017
    Posts
    2

    Default

    Thanks a lot!

    Quote Originally Posted by johanhammink View Post
    Use JNDI as database connection. The connection properties are stored outside the ktr files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.