TDWI BEST PRACTICES REPORT, Q2 2011 answers this question as, “DI requires a wide range of interfaces … includes traditional interfaces (native database connectors, ODBC, JDBC, FTP, APIs, bulk loaders) and newer ones (Web services, SOA, and data services). The new ones are critical to next generation requirements for real time and services.”
Not surprisingly, Progress DataDirect has already delivered next generation Salesforce ODBC and JDBC drivers that combine traditional and newer interfaces for superior data connectivity with Salesforce.com.
And as a Solutions Consultant for DataDirect Connect, I work directly with organizations to provide data connectivity solutions using many of the data integration tools listed in Gartner's Magic Quadrant for Data Integration Tools:
Therefore, we have a lot of experience with both data integration tools and cloud connectivity.
Progress DataDirect Connect XE for Salesforce Data Integration using your in-house ETL tool
1. Standards Based Connectivity. The same ODBC or JDBC driver used for data integration can be used throughout your organization with BI tools: IBM Cognos, OBIEE, SAS, Crystal Reports, Tableau, and more ; and Database Links: Oracle Gateways, Teradata Parallel Transporter (TPT), MS SQL Linked Server, DB2 Federation. Use a single connector to Salesforce across all applications for standard features, functionality and Salesforce API version support.
2. Flexible Built-in Incremental CDC Cache. In your Data Integration/ETL jobs, you can configure the driver without application code changes to load Strategic and Tactical data using the built in incremental change data capture cache to refresh locally at desired intervals, or get real time access for more Operational BI. Figure 1 Operational BI versus strategic and tactical BI from the Next Generation Data Integration report.
The built-in cache resides entirely within the driver without any requirement for an intermediate database, and improves performance and limits the number of web service calls made to the Salesforce API.
3. SQL 92 compliance makes Salesforce.com look like any relational data source to your data integration software.
4. Bulk load. Leverage the Salesforce Bulk Load API for load jobs without code changes using your favorite Data Integration/ETL tool.
5. Reliability. Salesforce drivers are built on the same flagship Progress DataDirect Connect drivers framework that has powered your enterprise data connectivity for two decades across 32-bit and 64-bit Windows, Linux, AIX, Solaris, and HP-UX platforms.
Download free 15 day trial of the DataDirect Connect XE for ODBC or JDBC Salesforce drivers to integrate an unlimited number of applications with Salesforce.
Or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with DataDirect Connect Salesforce integration.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
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, 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.