SAP Blog
Connecting to Salesforce Data Through SAP BusinessObjects

Connecting to Salesforce Data Through SAP BusinessObjects

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 About Mitesh Shah

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.

 

protiviti

Add comment