Friday, October 8, 2021

ODI - Create Model and Topology objects using Wizard option

 Implementation steps: 

Step1: Go to Design tab and Models Accodian and click the folder sign and New Model and Topology Objects.


Step2: provide Model name, select technology , Logical Schema name and context.


Step3: provide Data server details like Name, User, password, driver, url etc. Next and test connection.


Step4: Provide Physical schema nane, db schema names.

Step5: Model will be created.



Step6: Go to Reverse Enginner and do mask for selecting tables if you need.

Step7: Go to selective Reverse engg a d select objects to reverse engg.

Step8: Datastores tables will be created. Just right click on any table and click view data



No comments:

Post a Comment

Featured Post

OIC - Converting UTC DateTime String to Hong Kong Time in Oracle Integration Cloud

When integrating systems in Oracle Integration Cloud (OIC), it is common to receive date-time values in UTC format as strings from source sy...