create readers?

Question

In my oracle db I have 30 users, all of which have the same tables (about 40). Now I want to merge the data from the different users, i.e. create a new user with those 40 tables and combine the data from all 30 users.

I started by trying it for just one table and three users:

I created a workbench with a reader for each of the different users and a writer to the new user, and everything worked well.

As I want to automatize as much as possible, I used parameters for the user names and passwords, wrote them in a command file and started it as a batch.

But like that I still have to have a reader defined for each user in the FME Workbench. Is it possible to create the readers "on the fly" in the batch file? Or could I loop with the same reader through a list of my users / passwords?

Thanks in advance

Vera

takashi · Answer

Hi Vera,

Creating two workspaces might be a solution. The first workspace is the main workflow consisting of reader(s), transformers, writer(s). Also define published parameters to receive username, password etc., and link them to the corresponding reader parameters. In the second workspace, read the parameter table (contains username, password etc.), and call the first workspace using the WorkspaceRunner transformer. You can pass the parameters to the first workspace and run it through the WorkspaceRunner. The WorkspaceRunner is a convenient functionality to do a batch processing.

Takashi

create readers?

2 replies

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded