How to connect Salesforce ODBC driver with SAP Business Objects?
Owing to the fact that Salesforce has become the most efficient CRM and SAP BO remains the best business software, integration of both in an organization would definitely bring a growth revolution. It is possible to connect Salesforce ODBC driver with the SAP BO objects. Following are the simple steps to do that.
- Firstly, Download the 15 day trial of the latest 32-bit DataDirect Connect XE for ODBC driver (7.0 SP1 or higher) on the system and install it where IDT/UDT is installed.
- The next step is to create and test-connect to Salesforce.com data source. Watch this video on how to configure ODBC connectivity to Salesforce for reference.
- Again, go back to the Salesforce ODBC data source and click configure and go to the "SQL Engine" tab and change SQL Engine Mode to "1- Server".
- Now click on Edit Server Settings and click "Start" button to launch the Salesforce Service.
- Then, click on the "Advanced Tab" and enter the following value in the "Config Options" field: MapSystemColumnNames=0;CustomSuffix=Include;AuditColumns=All
- Click on the "Web Service Tab" and set "Call Statement Limit" to "0".
- Now you can launch your design tool (IDT or UDT), and configure the Generic ODBC 3 data source as type, "ODBC3" (instead of choosing OpenAccess ODBC driver for Salesforce).
- Enter the appropriate User name, Password and Data source name.
- Now, click ‘Next’ and continue to design your Universe to Salesforce.com similar to any other database.
- Once the client is complete, you can proceed to install the 64-bit Salesforce ODBC drivers on the BOBJ application server. If this is a clustered environment, each node will require a matching 64-bit Salesforce ODBC DSN.
NOTE: It is very essential to make sure that the 32-bit and 64-bit ODBC DSNs across IDT/UDT and Web Intelligence Servers are identically configured. If all components reside on a single server, both 32-bit and 64-bit ODBC drivers will be installed on the same system where 32-bit ODBC DSNs get loaded from IDT/UDT and 64-bit ODBC DSNs get loaded from the Web Intelligence Service.
SAP BI has become a flexible and most reliable platform for businesses. Organizations around the world are in greater need of professional with proficiency in SAP BI platform. Get the best training on SAP BI here…
Find a course provider to learn Salesforce
Java training | J2EE training | J2EE Jboss training | Apache JMeter trainingTake the next step towards your professional goals in Salesforce
Don't hesitate to talk with our course advisor right now
Receive a call
Contact NowMake a call
+1-732-338-7323Take our FREE Skill Assessment Test to discover your strengths and earn a certificate upon completion.
Enroll for the next batch
Salesforce Course Online Training Course
- Sep 1 2025
- Online
Salesforce
- Sep 2 2025
- Online
Salesforce Course Online Training Course
- Sep 3 2025
- Online
Salesforce
- Sep 4 2025
- Online
Salesforce Course Online Training Course
- Sep 5 2025
- Online
Related blogs on Salesforce to learn more
INTRODUCTION TO CLINICAL RESEARCH
Learn the fundamentals of clinical trials, and eight phases of the clinical research process.
Describe when and why to use the Force.com code
Discover how to leverage the power of Apex code to automate business processes, enhance user experience, and improve data quality in your Salesforce organization.
Features of Force.com code and distinguish between Force.com code and other programming languages.
Learn how to seamlessly integrate Force.com pages into your Salesforce applications to enhance user experience and discover the steps to create, customize, and deploy custom pages that meet your specific business needs.
List and Describe Syntax Features of Force.com Code
Master the syntax features of Force.com code and description for each feature.
An Introduction: Integrating with the Salesforce Force.com Platform
Unlock the full potential of your Salesforce implementation by integrating it with external systems and applications.
Describe How to Incorporate Force.com Pages into Force.com Applications
Learn how to seamlessly integrate Force.com pages into your Salesforce applications to enhance user experience and discover the steps to create, customize, and deploy custom pages that meet your specific business needs.
Describe the save execution order and use of before and after triggers
Learn how to write triggers that execute at the right time to meet your specific business needs
Debugging, Testing, and Monitoring in Force.com: A Comprehensive Guide
Explore the essential techniques for debugging, testing, and monitoring your Force.com applications.
A Comprehensive Guide to Managing Static Resources in Salesforce
We have discussed the types of Static Resources, how to Create & Use Static Resources and best Practices for Managing Static Resources in Salesforce
Introduction to Force.com Sites – Overview
Learn about the features, benefits, and use cases for Force.com Sites, and discover how to create a custom website that integrates with your Salesforce data and workflows.
Latest blogs on technology to explore
Understanding Artificial Intelligence: Hype, Reality, and the Road Ahead
Explore the reality of Artificial Intelligence (AI) — its impact, how it works, and its potential risks. Understand AI's benefits, challenges, and how to navigate its role in shaping industries and everyday life with expert training programs
How Much Do Healthcare Administrators Make?
Discover how much healthcare administrators make, the importance of healthcare, career opportunities, and potential job roles. Learn about salary ranges, career growth, and training programs with Sulekha to kickstart your healthcare administration jo
How to Gain the High-Income Skills Employers Are Looking For?
Discover top high-income skills like software development, data analysis, AI, and project management that employers seek. Learn key skills and growth opportunities to boost your career.
What Companies Expect from Product Managers in 2025: Skills, Tools, and Trends
Explore what companies expect from Product Managers in 2025, including essential skills, tools, certifications, and salary trends. Learn how to stay ahead in a rapidly evolving, tech-driven product management landscape.
Breaking Into AI Engineering: Skills, Salaries, and Demand in the US
Discover how to break into AI engineering with insights on essential skills, salary expectations, and rising demand in the US. Learn about career paths, certifications, and how to succeed in one of tech’s fastest-growing fields.
Cybersecurity Training: Powering Digital Defense
Explore top cybersecurity training programs in the USA to meet rising demand in digital defense. Learn about certifications, salaries, and career opportunities in this high-growth field.
Why Pursue Data Science Training?
Empower your career in a data-driven world. Learn why data science training is crucial for high-demand jobs, informed decisions, and staying ahead with essential skills.
What Does a Cybersecurity Analyst Do? 2025
Discover the vital role of a Cybersecurity Analyst in 2025, protecting organizations from evolving cyber threats through monitoring, threat assessment, and incident response. Learn about career paths, key skills, certifications, and why now is the be
Artificial intelligence in healthcare: Medical and Diagnosis field
Artificial intelligence in healthcare: Medical and Diagnosis field
iOS 18.5 Is Here: 7 Reasons You Should Update Right Now
In this blog, we shall discuss Apple releases iOS 18.5 with new features and bug fixes