Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: "Dynamic" datasource

  1. #1
    Join Date
    May 2011
    Posts
    6

    Default "Dynamic" datasource

    Hi, I am using pentaho to transform and enrich some files for multiple customers. However for the enrichment i need to connect to a customer specific database. Is it possible to switch between datasources? I know its possible to define a datasource with variable driven connection parameters, but in that case i'm not sure how to manage passwords.

    in a nutshell:

    inputfile_custA.txt -> data lookup from custA database
    inputfile_custB.txt -> data lookup from custB database

    Thanks for looking.

  2. #2

    Default

    You can provide the password as one of the parameters. I sometimes type the variable into the username so I can see I have spelled the variable correctly then cut and paste into the password field where it gets obfuscated by the asterisks. Or you could use CTRL-Spacebar to enter the variable name.
    Name:  variabledbconn2.jpg
Views: 63
Size:  29.4 KB
    Name:  variabledbconn.jpg
Views: 64
Size:  25.1 KB

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.