Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Migrating Jobs and Transformation from one server to another

  1. #1
    Join Date
    Oct 2015

    Default Migrating Jobs and Transformation from one server to another


    We are using two servers, one as preprod and other as Production. When we are migrating jobs or Transformations from preprod to Prod it copies its connection properties as well and this affects our Production job execution.
    Can someone let me know how to migrate transformations without coping it's connections to another server.


  2. #2
    Join Date
    Apr 2008


    Standard practice in PDI is to use variables in your connections (for example in the hostname box, put ${SRC_DB_HOST} )
    In the %USERPROFILE%/.kettle/ (windows) or ~/.kettle/ (Linux) you can define on a per-workstation basis, what SRC_DB_HOST is (eg. on Dev systems, SRC_DB_HOST=localhost but on prod PDI server, SRC_DB_HOST=proddbsrv )

Tags for 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.