The Progress DataDirect team of data connectivity professionals at DreamForce 12 engaged with hundreds of organizations on direct SQL access via ODBC and JDBC to Salesforce across several venues:
SOQL is a highly capable query language for data access on the Salesforce plaform, but sometimes you just need SQL. We commonly heard requests for the following SQL-92 features available via ODBC and JDBC:
We also heard from developers that they commonly run into governor limits within APEX code. These limits would not apply to SQL access since ODBC and JDBC drivers run outside of the APEX runtime.
Our real-time ODBC and JDBC architecture translates SQL into SOQL, and effectively pushes down operations supported by SOQL to the Salesforce API; and the driver handles the rest. For example, since SOQL does not support GROUP BY operations that return more than 2000 rows, the driver processes the GROUP BY operation internally WITHOUT the requirement for a staging database.
Salesforce Developers in the devzone sessions and theaters appreciated and recognized how much work went into our SQL-92 ODBC and JDBC drivers; and we heard this several times. They are correct - DataDirect R&D put several years of work into enabling real-time standards based ODBC/JDBC access to Salesforce. The drivers connect to Salesforce.com, Database.com and force.com and are built on the flagship Connect platform that includes connectivity for Hadoop Hive, IBM DB2, Greenplum, Informix, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Salesforce.com, Sybase, Sybase IQ, Teradata, and dozens more on the roadmap!
Organizations adopting Salesforce observed that the drivers implement the latest versions of 3 Salesforce APIs in a single driver, and we release service packs as new API versions are published. For R&D directors and consultants, this provides a significant ROI since their teams can leverage existing SQL skills without having to learn the latest APIs.
Our sessions and demos were eye openers for organizations not using direct SQL-92 access via ODBC and JDBC to Salesforce. There seem to be a lot of one off connectors/adapters out there. Standard's based SQL access solved this challenge for us already; and shops can instantly connect to Salesforce from existing applications. The use case list shared in the session below was heavily photographed. As a disclaimer, we are vendor neutral, and this is not an endorsement of any particular product.
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.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.