Skip to main content
  • EN

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?

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.

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

Reply


Community Stats

30,159
Posts
114,480
Replies
37,805
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.