Skip to main content
Question

How can I connect to different ORA databases.

  • August 8, 2017
  • 2 replies
  • 27 views
perry
Forum|alt.badge.img+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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • August 8, 2017

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
Forum|alt.badge.img+2
  • perry
  • Author
  • August 9, 2017

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

Community Stats

32,188
Posts
122,192
Replies
39,860
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.