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

    Default Migrating Jobs and Transformation from one server to another

    Hi,

    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.

    Regards,
    Suraj

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    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/kettle.properties (windows) or ~/.kettle/kettle.properties (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.