Interested in connecting Salesforce and DB2? Here’s how to turn your DB2 database into a Salesforce Connect-compatible OData provider.
In the 1980s, most IT organizations thought this. There were far fewer choices than today, and IBM was recognized as having very solid, reliable offerings. They had you and your business covered! Today, it’s not so simple. IBM products, such as DB2, might be implemented along with SaaS products like Salesforce.com.
Integrating DB2 and Salesforce can be accomplished in a number ways. The more familiar Salesforce.com data integration patterns include ETL (copying the data into Salesforce) and custom APEX coding. While effective, they have their downsides. “Stale" data, the cost of cloud storage and “brittle” integrations to name a few.
In 2014, Salesforce introduced a new integration service called Salesforce Connect. (Originally released as Lightning Connect, but subsequently rebranded in 2015.) Salesforce Connect avoids many of the negatives of the older patterns, providing standards-based, real-time access to external data. No copying of data! Salesforce Connect supports data sources that support OData, but DB2 doesn’t offer OData support. False start?
Progress hybrid integration services can turn your DB2 database into a Salesforce Connect-compatible OData provider!
These integration services may be managed by Progress with the DataDirect Cloud service, by you in your infrastructure or in the leading public and private clouds, such as Azure, HPE Helion, CenturyLink, Google Cloud, IBM Bluemix, Rackspace and Amazon AWS.
View all posts from Greg Stasko on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, Ipswitch, 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.