Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: OK ... I'm slow (and still hunting for the best way to pass a connection)

  1. #1

    Default OK ... I'm slow (and still hunting for the best way to pass a connection)

    What is the best (simplest) way to select a connection name from a table and the use that connection in a transformation downstream? Would I be better off to store the parameters to use a generic connection?

    (the databases are potentially different DBMS)

  2. #2


    Hi dogfuel,

    I would suggest to use a shared file for your DB connections. So you can use anywhere a specific connection name (it can not given mutable). In the shared file you can use options and DBMS type of your choice. (Shared file is specified on Miscellaneous tab of transformation settings and Log tag of job settings.) The shared file is saved when transformation or job is saved.
    You can use multiple shared files to manage different connections and choose one before starting PDI - also ideal for separate test and production system settings.

    21 is only half the truth

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.