Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Siwtch between Connection

  1. #1

    Default Siwtch between Connection

    Hi all,
    i want to load a collection of tables from different sources (connections) into a data landing zone. For this reason I have a configuration table with source name, source schema, source table, target schema, target table. Now I need a way to switch between connections. Is there a way to do this by variables or maybe metadata injection?

    Thanks for help
    Thoralf

  2. #2
    Join Date
    Aug 2016
    Posts
    290

    Default

    Doesn't look like it. Data connections are handled in a special way, stored in each file I think. I have made connection variables for http connections, but not database connections. Would be interesting to see a solution for it.

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

    Default

    Database configurations support using variables for hostname, username, password
    You just can't change the connection type (Oracle vs MSSQL) since that changes the underlying dialect of SQL that is used.

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.