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.





at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...