After working on several POCs last month for integration between Oracle Business Intelligence (OBIEE) and Informatica PowerCenter to Salesforce.com, we have seen a surge in interest for this solution. Support for ODBC and JDBC connectivity to the Salesforce CRM business application (and database.com) has blown the integration options wide open from OBIEE! Below is a tutorial on how to create a repository (RPD) to Salesforce.com using ODBC.
The majority of prospects selecting this option to date are running Informatica, and using our flexible Salesforce CRM integration with Informatica PowerCenter. For Oracle Warehouse Builder (OWB) integration, Salesforce.com is not a supported business application - SAP R/3, Siebel, PeopleSoft, Oracle E-business. However, DataDirect Connect XE series ODBC and JDBC drivers provide a fully supported source and target to Salesforce.com as a standard non-Oracle database. Read my step by step tutorial on setting up the Oracle Database Gateway for Salesforce.
Or choose any third party data integration tool that supports ODBC.
The option to model and access real time operational data in Salesforce is exclusive to ODBC connectivity using the OBI Admin Tools. Since Salesforce CRM is a cloud, you can go to town on accessing this operational source for BI through your enterprise SFDC subscription!! To build a repository, you can perform the following steps:
Now you can build your star schema directly against Salesforce without the requirement for an intermediate database and ETL job!!
For reference, a general tutorial is available from Oracle on Creating a Repository Using the Oracle BI 11g Administration Tool.
And for real time access to Salesforce from BI Publisher, use the Connect XE for JDBC Salesforce driver. Tutorial on configuring the JDBC driver is available from Oracle.
Quoted from the ORACLE BUSINESS INTELLIGENCE FOUNDATION SUITE Technical Overview, January 2011
"Combining Transactional Data with Data Warehouse Information: Finally, the Common Enterprise Information Model allows users to combine data from a data warehouse with information from transaction processing systems in a single calculation to get the most up-to-date value of a metric"
1. Download free 15 day trial of the DataDirect Connect XE for ODBC or JDBC Salesforce drivers to integrate an unlimited number of BI applications with Salesforce.
2. Or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with DataDirect Connect Salesforce integration.
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.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
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.