I recently found myself needing to connect my Salesforce® data to SAP® BusinessObjects™. My project required meshing data from multiple sources and BusinessObjects is the best way to do that. Although Salesforce has a native reporting component, it’s not as robust as BusinessObjects, which allows me to run powerful analysis, and generate highly formatted, interactive reports and dashboards with extensive visibility, alignment and insight across my entire enterprise.
When I started looking at the best way to accomplish this, I knew I had to do one of two things: extract the data out of Salesforce, or find an ODBC driver to connect to it. Extracting the data required keeping it in a staging area in my database, but I knew that wouldn’t produce real-time updates. So I decided an ODBC driver was the path of least resistance.
With several driver options available, I decided to experiment to find the best one. My focus was on the usability and functionality of each without taking cost into consideration.
I searched the internet for Salesforce ODBC drivers and downloaded each from its respective vendor. I installed them on my BusinessObjects server and began my experiment.
Below is a list of the drivers I tested:
- Native SAP Salesforce ODBC installed with BusinessObjects Server and Client tools
- Progress DataDirect Salesforce
- Easysoft Salesforce ODBC Driver
- CDATA ODBC Driver for Salesforce
- Simba Salesforce ODBC Driver
To download full PDF and Continue Reading…
Mitesh is a senior Business Intelligence consultant for Decision First Technologies specializing in data services, web services, front-end reporting and analysis, dashboards and Information Governance for numerous enterprise customers across the country. Specifically he works with SAP® Data Services, Information Steward, BusinessObjects Tool Suite and HANA.