With the conclusion of the Dreamforce and Oracle OpenWorld conferences in SFO last month, I am now seeing several new POCs using technology learned from both worlds. While DataDirect attended both events, all I am willing to share is that one had better music and the other had better breakfast selections. However having unique expertise on both sides, I want to share what I have learned from these new POCs requiring DataDirect Connect XE for JDBC Salesforce drivers to connect both Oracle BI Publisher and Oracle Data Integrator to Salesforce.com, Database.com and Force.com.

9. Once the test-connection succeeds, you can start developing in BI Publisher.

Below is a simple BI Publisher report I created that fetches data directly from my Salesforce.com developer account:

How to get started with Oracle Data Integrator 11gR1 (ODI)

Oracle supports third party JDBC drivers for use with ODI such as the DataDirect Connect XE for JDBC Salesforce driver. Refer to section "2.4.1 Add Additional Drivers and Open Tools" in the Oracle Data Integrator documentation for installation of third party JDBC drivers on Unix/Linux/Windows. Oracle Data Integrator 11gR1 documentation refers to the installation of DataDirect drivers, but this does not include Salesforce.

Which ODI knowledge module is recommended for use with Salesforce.com

Use the Generic SQL Knowledge Modules per Oracle documentation since the DataDirect Connect XE for JDBC driver supports SQL-92 access to Salesforce.

screenshot from oracle.com

Interested in learning more?

Contact us to learn how other organizations are making progress with Salesforce and Oracle connectivity from DataDirect.Oracle Data Integrator (ODI) and BI Publisher JDBC connections to Salesforce

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.