Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Portable DB Connection Across Different Machines

  1. #1

    Default Portable DB Connection Across Different Machines

    Hi all!,

    I'm trying to make my work portable on all platforms. For files and directory paths I've used a property file and variables, it's working fine. However with establishing a portable MySQL connection (Or even setting up a similar connection so the code doesn't break), I'm not sure as to what approach is best. Is there a way to utilize variables
    in this situation? Any feedback would be much appreciated!

    Thanks for your time,

    The Embedded Monster

  2. #2
    Join Date
    Jun 2012
    Posts
    5,362

    Default

    Didn't you notice that almost every configuration setting of a database connection does accept variable references?
    The Connection Wizard doesn't tell you about this, but if you edit an existing connection you'll see.
    pdi-ce user (mostly 4.4)
    java 1.8.0_131 (OpenJDK)
    ubuntu 16.04 LTS (x86_64)
    timezone CET / CEST
    contemplative reading SSCCE
    sig updated 2017-10-20

  3. #3
    Join Date
    Aug 2016
    Posts
    112

    Default

    Yes read connection info from config file, make a transformation run before all others that read file and set config to system wide variables. Or use the kettle config file and get them automatically at start-up.

    I've used this with success for different MySQL database connections.

  4. #4

    Default

    Thanks guys, much appreciated.

    The EMB,

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 - 2017 Pentaho Corporation. All Rights Reserved.