The Progress® DataDirect® for ODBC Salesforce™ driver supports the standard SQL query language to fetch, insert, update, and delete data from Salesforce.com and Force.com. To support SQL access to Salesforce, the driver creates a map of the Salesforce data model and translates SQL statements provided by the application to Salesforce queries (SOQL) and Web service calls.

The driver optimizes performance when executing joins by leveraging data relationships among Salesforce objects to minimize the amount of data that needs to be fetched over the network. The Salesforce driver recognizes the relationships among standard objects and custom objects and can access and update both. Relationships among objects can be reported using the SQLForeignKeys and SQLPrimaryKeys functions.

The driver also provides a client-side data cache. You can improve performance for some queries by defining rules that specify which data to cache on the client as well as when the cached data becomes invalid and needs to be refreshed.

The documentation for the driver also includes the Progress DataDirect for ODBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for ODBC, including content on troubleshooting and supported functions. For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.