Home > BusinessObjects > 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.

 

Categories: BusinessObjects
  1. Noel Scheaffer
    July 18, 2015 at 10:48 am

    Very nice and informative post!

  2. July 23, 2015 at 6:00 am

    Thank you very very much for such nice and good article on this at this time.Really your article is having very usefull info which can help others in many way.

  1. November 19, 2015 at 3:44 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: