Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: table input metadata injection connection info

  1. #1

    Default table input metadata injection connection info

    why isn't the database connection available to populate from the meta-data injection interface to the input table step?

    I would like to run same logic over multiple sql extracts whose tables resides on different databases.

    I was hoping to pass in the sql stmt and the database connection info from a source file.

    In lieu of being able to do that using meta-data injection, any alternate suggestions? greatly appreciated. thx.

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

    Default

    Please read the documentation on Variables and Parameters.
    They do exactly what you are describing.

    Specifically: use a Parameter/Variable for the DB Hostname/IP, Username, Password
    Then you can use the same Input step to access different DBs

  3. #3

    Default

    yeah, thanks gutlez, was hoping to re-use info (database connection definitions) already available. but can implement managing params.

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

    Default

    Just adjust the DB Connection information.

    Hostname is currently something along the lines of DBHost.your.domain
    Change it to ${DBHost} which you can then declare as a parameter to your transformation.
    Repeat for things like Username, Password, Port, DBName.
    Last edited by gutlez; 11-29-2017 at 06:07 PM.

  5. #5

    Default

    I have this working until I run into a database where ssl has been implemented. (options tab of database connection info - ssl and sslfactory parameters are set).
    Any way to set these "at run time"?

    thx gutlez

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.