Build, protect and deploy apps across any platform and mobile device
Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Automate decision processes with a no-code business rules engine
Build mobile apps for iOS, Android and Windows Phone
A complete cloud platform for an app or your entire digital business
Deploy automated machine learning to accurately predict machine failures with technology optimized for Industrial IoT.
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
In my previous blog about connectivity from Business Objects to Salesforce, we talked about creating Salesforce Universes for direct and real-time data connectivity to use in business intelligence (BI). As new requirements come to your team, it makes sense to expand your data warehouse (like SAP HANA) to include cloud data.
Today, I’m working off that theme and discussing couple of SAP Business Objects Data Services (BODS) 4.2 Linux projects I’ve been engaged with, connecting cloud data sources such as Salesforce and NetSuite using Progress® DataDirect® ODBC adapters. These ODBC adapters enable native data services extraction, transformation and loading.
DataDirect ODBC adapters are built on the same technology as the relational adapters bundled with BODS out-of-box. With them you can instantly browse any cloud application schema similar to existing relational sources and targets from within the Designer interface. And YES, we can write to Salesforce.com as a target from BODS!
This tutorial will focus on Salesforce and NetSuite, but similar steps can be followed to connect BODS 4.2 to any commercial DataDirect ODBC drivers across big data, NoSQL and cloud. In addition, this mini tutorial applies to third-party ODBC drivers you might obtain from other application vendors such as NetSuite.com, ServiceNow, Plex Systems, VoltDB and Deltek, to name a few.
To get started connecting BODS to cloud sources, follow these steps:
For other drivers such as NetSuite, an additional environment variable is required:
Refer to the instructions from the application vendor for a complete reference.
ds_odbc.ini serves as a pass through to the DataDirect Unix/Linux ODBC Driver Manager where the desired ODBC data source name is in brackets. For example:
In odbc.ini, you should configure the actual library (ddsfrc27.so for DataDirect Connect64 for ODBC Salesforce v7.1.4 or ivoa22.so for NetSuite.com). Note that the ODBC DSN name in brackets must match between ds_odbc.ini and odbc.ini.
Description=DataDirect 7.1 Salesforce
Description=DataDirect 7.1 Salesforce
Make sure the client ODBC data source on Windows is configured with the same properties in the ODBC Administrator.
SAP recommends the use of DataDirect drivers when you need:
I guarantee you will see requirements from BODS to consume at least one of the following cloud data sources over the next 8 months:
Tweet @SAsInSumit or ping me on LinkedIn to let me know if I'm right (be nice!).
We are always ready to help our customers with whatever they need. To contact us, post a comment below, tweet to @DataDirect_News or call 1-800-876-3101. We are partners with SAP on TSANET and happy to collaborate on your behalf for any connectivity project.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2017 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, 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.