Creating a Salesforce.com Data Server and the Physical & Logical Schema with ODI12c

Creating the Data Server

1. In Topology > Physical Architecture > Salesforce.com, right click and select "New Data Server".

2. In the Definition tab:

• Name: Name of the data server that will appear in Oracle Data Integrator
• Instance/dblink (Data Server): Not required for Salesforce.com. Leave this field blank.
• User/Password: User name and password for connecting to the data server (Password+SecurityToken, must be at most 40char)

3. In the JDBC tab:

• JDBC Driver: weblogic.jdbc.sforce.SForceDriver
• JDBC URL: The URL used for connecting to the data server. For example, jdbc:weblogic:sforce://login.salesforce.com. 

In the Properties section:

• ConfigOptions: The configuration options that you want to use. For example, (AuditColumns=all;MapSystemColumnNames=0;CustomSuffix=include;). I have set auditcolumns to 'all', so I could view the audit fields . I have set the MapSystemColumnNames and CustomSuffix to 0 and 'include', respectively, so I could view the column names as in they are in Salesforce.
• DatabaseName: The instance of the database. This needs to be changed as per the JDBC URL used. I suggest to set the DatabaseName so that you would know which Salesforce instance you are connecting at the moment. In default, ODI will set the database name base on the user name.

For more information on the connection properties supported by the Salesforce.com driver, see http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html#page/jdbcconnect%2FConnection_Properties_11.html%23wwID0EZT5Y

4. Save & Test Connection.

Creating the Physical Schema

1. Right click on the Data Server you created and select "New Physical Schema".

2. In the Definition tab, select SFORCE Schema.

Creating the Logical Schema

1. In Topology > Logical Architecture > Salesforce.com, right click and select "New Logical Schema".

2. In the definition tab, enter the name of the logical schema. For the context, select from the dropdown the physical schema you have created earlier.

Congratulations!

You are now ready to create your Salesforce Data Model.