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 - Extract Microsoft 365 Outlook Email Attachments and upload them to OCI Object storage

Use Case: A client has a requirement to automate the processing of email attachments received in their Microsoft 365 Outlook inbox. Currentl...