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.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, 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.