Is it possible to reverse the attributes of a datastore with dynamic resource name?

User_2ANY9

I've used this functionality when setting the model for loading files, but now I need to do it for a table in an Oracle DB. The resource name must be dynamic, I'm using a variable for the name, but when I try to reverse engineer the attributes of the datastore from the table in the DB, it doesn't work.

I tried also through the reverse engineer tab of the model, but it doesn't work there too.

I searched a lot on this topic, there've been some discussions and advise about using variables for dynamically setting the resource name of a datastore, but nothing about reversing the columns. Any suggestions why it might not work would be much helpful.

Adrian_Popescu-Oracle

Hi,

Yes, it is possible.

In the ODI package you can find "OdiReverseGetMetaData" and "OdiReverseSetMetaData" tools which allow you to reverse engineer a model.

Also, the model has a field named "Mask" which allows to setup which tables to reverse engineer using the "%" wildcard.

So, setup the model with the table name in the mask, add "OdiReverseGetMetaData" and "OdiReverseSetMetaData" tools and you'll always get the table definition.

See details here:

https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.3/odirf/oracle-data-integrator-tools.html#GUID-B4265BE1-07DE-44F0-99D2-1403AB6897D9

Adrian