Question

How can I connect to different ORA databases.

  • 8 August 2017
  • 2 replies
  • 2 views
perry
Badge +2

Hi,

I have a desktopversion 2016 and 2017 withe shared public database connections

I want to connect to 3 oracle databases in different schema's because there are three separate citties. (i.e. DBConn1, DBConn2, DBConn3) The tables are however identical so I made one procedure in a custom transformer.

In the custum transformer multiple SQL Excecuters will select the needed items from different tables.

I like to use a workspacerunner to start the custum transformer.

How can I validate the separate Dataset (DB Conn1 to 3) in order to run my custum transformer for the three citties?

I have published parameters (DBConn1, DBConn2, DBConn3) but I did not managed it to enclose these parameters in the SQLExcecuter parameter (DATABASE/DATASET).

Also I did not manage to sent the parameter value from the workspacerunner to the

custom transformer.

The procedure has to run automatically for all 3 citties so I can't use a manual input as Parameter with Choise.

Do you have any suggestions to solve this problem?

2 replies

erik_jan
Rank
Userlevel 2
Badge +12

Create a text file with the 3 database connections.

Then use a text reader to read the file and per line in the text file execute the WorkspaceRunner passing the database connection to the WorkspaceRunner as a published parameter.

That way you only need to change the text file if you get a fourth city.

perry
Badge +2

Your solution is simple and efficient. Thanks for your quick reply..

Reply


Community Stats

28,661
Posts
109,324
Replies
36,528
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.