Creating a Salesforce Data Model with ODI12c

In the previous post, I have shown you how to create the Salesforce data server, as well as the physical and logical schema. In this post, we will proceed in creating the data model.

In Designer > Models > New Model Folder. In case you have more than one instance of Salesforce Data Model available, sandbox and production databases, you can put the two under one Salesforce Data Model folder.

Under the Salesforce Model folder, create a new model. In the definition tab, enter the name of the data model. For Technology, select Salesforce.com. Finally for the Logical Schema, select the name of the physical schema you have created.

Now you can 'Reverse Engineer' the Salesforce tables available to you. I would however, do a 'Selective Reverse-Engineering' so I can choose only the tables I need. Tick the Selective 'Reverse-Engineering', 'New Datastores' and Objects to Reverse Engineer checkboxes. Save. Then click on 'Reverse Engineer'.

Your Data Model should now have the tables you reverse-engineered.

Now you can use the Salesforce tables as Source or Target in a Mapping.