Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: About setting Database Connection variables dynamically from the Stream data

  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Default About setting Database Connection variables dynamically from the Stream data

    Hello There,

    I need to fetch data from 70 different identical databases. These databases are located in 70 different hosts and has a different password.

    I am trying the following:



    1. Save the DB Connection Credentials to a Database table
    2. Read this iteratively
    3. Use 'Copy rows to result' and 'Get rows from result' to set DB Connection variables


    Is this a method possible?? If not is there an alternative to iteratively pass the DB Connection Parameters into DB Connection variables.

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

    Default

    You can save the connection details in a database, but I would prefer a property file for each system.
    Don't use "Get rows from result", use the advanced transformation options "Copy previous results to parameters" and "Execute for every input row".
    Don't forget to define the parameters.
    So long, and thanks for all the fish.

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.