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
    Posts
    11

    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...
    http://forums.pentaho.org/showthread.php?p=167576


    Any help would be appreciated.

    Klaasjan

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Edit or create the kettle.properties 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 kettle.properties, otherwise it won't refresh the list).

    If you run into problems search for kettle.properties or have a look at this thread: http://forums.pentaho.org/showthread...tle.properties

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.