ODI - Dynamic Topology Connection

Hi,

I came across this interesting situation during a project in this week.

Imagine the following scenario:

You have different target schema, and in thi target schem I have the tables with have the same name and structures.

Your task is to load data in all these differents database schema.

 

Because the target are 23 and since all the tables have the same structures, how can you accomplish that with ODI without creating a lot of duplicate model target?

 

We create a dynamic connection topology connected to execution context as follows:

 

1. Create a context ODI with contains a schema name of database where you want connect
2. Create a variable with contains a execution context.
3. Insert this variable into physical schema in the schema name

 

When the process started the connection changed with the execution context and insert o read data from database schema associate to context.