5 reasons to choose next generation ETL data integration with Salesforce from Progress DataDirect

5 reasons to choose next generation ETL data integration with Salesforce from Progress DataDirect

September 21, 2011 0 Comments

What is next generation data integration to Salesforce?

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:

  • Informatica PowerCenter
  • IBM Information Server Infosphere (DataStage)
  • Oracle Warehouse Builder and Oracle Data Integrator (ODI)
  • SAP BusinessObjects (Data Integrator / Data Services)
  • Pervasive Data Integrator
  • Ab Initio
  • Microsoft SQL Server Integration Services (SSIS)
  • SAS Data Integration
  • SyncSort DMExpress
  • iWay Software Integration Server

Therefore, we have a lot of experience with both data integration tools and cloud connectivity.

Salesforce Data Integration

Progress DataDirect Connect XE  for Salesforce Data Integration using your in-house ETL tool

Top 5 reasons to choose Progress DataDirect for your ETL data integration with Salesforce:

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.

Operational versus Strategic BI to Salesforce

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.

Get started today!

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.

Sumit Sakar

Sumit Sarkar

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.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
Then, Now and Beyond: The Future of Back Office Software
Read More
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More