We have over 300 FME dataflows using multiple Oracle databases. We are trying to figure out how to list all the different tables and schemas used by all the dataflows together.
Question
List or retrieve databases and tables used in all our 300 dataflows
+70- Celebrity
You can using FME to read other workspaces (using the Workspace Reader). This will spit out the transformers and readers/writers being used.
You’ll then need to build logic to filter out:
- Oracle Readers and Writers
- (Transformers) FeatureReaders and FeatureWriters set to use Oracle
- (Transformers) SQLExecutors set to run against Oracle
+3- Contributor
I tried this but I was expecting the connection name, source table name and, target table name but I get back number that I don’t how to refer back to.
see sample output.
+70- Celebrity
That screenshot is of the connections between the transformers in the workspace.
I suspect you’re looking for oracle Database Connections. These aren’t stored in the FMW. Instead they’re stored at the application level. The FMW only references the name of the database connection.
To find what database connection is being used, you need to read that from the specified parameter out of the Reader/Writer Parameters or Transformer Parameters feature types (from the FMW reader)
Note that this won’t give you the schema being used, to do that you’ll have to breakdown the Reader/Writer parameters (or extract it from the SQL using in SQLExecutors)