Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Parameter datasource?

  1. #1

    Default Parameter datasource?


    I would like to choose a specific datasource with a parameter in my xaction (same queries for each datasource, thus I need just to change the datasource),


    I want to use the datasource "datasource1" with parameter "datasource"

    Or i want to use datasource "datasource2" with parameter "datasource"

    Can i do something like that without to use several xaction?

    Thanks in advance!

  2. #2
    Join Date
    Apr 2007


    yes, just use an if element in your xaction to decide which query to run. Make sure both queries return a result set of the same name. Your prompt/secure filter will also need to prompt for datasource.

  3. #3


    I found, i use a parameter and in "Database connection", i put the parameter (exemple {datasource}) and he uses correctly the database that i need.

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.