Saturday, October 2, 2021

ODI - Topology steps and model creations

 Step1: Create Repository connection


Step2: Go to Physical architecrure and choose 1 technology for example Oracle and new data server.

Step3: provide db connection details


Step4: provide jdbc details.


Step5: right click on the created data server and create new physical schema.

Step6:provide schema and work schema details. Context part we have to do once we created the logical schema.


Step7: Create context



Step8: create new logical schema


Step9: and map context to physical schema


Step10: Now go to design and tab create new model based on logical schema. And reverse enggineer to get all the datastores.





No comments:

Post a Comment

Featured Post

OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...