Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Deploy Kettle on production (modify DB URL)

  1. #1
    Join Date
    Jul 2007

    Default Deploy Kettle on production (modify DB URL)

    When I develop my kettle transformation on my Workstation, I use SSH tunnels with "custom" URLs for the various datasources.

    Now I like to deploy a job on the production server using Pan or Kitchen. The problem is that the URLs are different on the production server.

    What is the best pattern to solve this? Is there a way to setup a properties file with the URLs for the Databases on development and production?

    (Simple)JNDI could be a solution, but I think the following post mentions a bug that prohibits this...

    Any help would be appreciated.


  2. #2
    Join Date
    Dec 2005


    Edit or create the file on each machine.

    In this file you can define variables and values. Then use the variables in the connection settings (CTRL+SPACE in a filed such as Server host name to get the list - Restart Spoon after creating/editing, otherwise it won't refresh the list).

    If you run into problems search for or have a look at this thread:

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.