Hi all,
I have ~50 oracle DBs. Each of them has instance name and the tnsnames.ora file is set up on the local machine. There is one same table in each of these DBs that I want to do a simple count on.
What is the best way to iterate thru all these DBs without the need to set up 50 or so readers?
Any input will be appreciated.
+22Create a csv file (or similar) with the database credentials.
Then create a workspace to read the table for one of the databases (and output to a file or whatever you need). Publish username, password and service name.
Crate a runner workspace, reading the csv file and pass the credentials to a WorkspaceRunner transformer that runs the workspace reading the data.
The runner workspace loops through the databases and executes the "count" per database.
Create a csv file (or similar) with the database credentials.
Then create a workspace to read the table for one of the databases (and output to a file or whatever you need). Publish username, password and service name.
Crate a runner workspace, reading the csv file and pass the credentials to a WorkspaceRunner transformer that runs the workspace reading the data.
The runner workspace loops through the databases and executes the "count" per database.
Thanks for that. I am not sure I understand it completely. Could you elaborate more. What transformers do I need?
+22Thanks for that. I am not sure I understand it completely. Could you elaborate more. What transformers do I need?
Database reader in second workspace for reading the table followed by StatisticsCalculator if you just want a count and a Text writer to output the count for the table.
I am a bit stuck still;
I created master WS (WS1) that has a csv reader. This gives me the service names of the DBs.
I connected to it a workspace runner transformer which runs WS2. In WS2 I have a published parameter for the service name (SID). Also I have a sql executor which uses the published SID as service name. And I just use a sql statement to count how many rows there are in a table.
How do I pass the service name from WS1 to the WS2?
+21I am a bit stuck still;
I created master WS (WS1) that has a csv reader. This gives me the service names of the DBs.
I connected to it a workspace runner transformer which runs WS2. In WS2 I have a published parameter for the service name (SID). Also I have a sql executor which uses the published SID as service name. And I just use a sql statement to count how many rows there are in a table.
How do I pass the service name from WS1 to the WS2?
