Welcome to the Progress DataDirect for ODBC for Salesforce™ Driver
The Progress DataDirect forODBC Salesforce driver supports the standard SQL query language to fetch, insert, update, and delete data from Salesforce.com, Force.com, and Database.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.
Note: For the Salesforce Web Service API versions supported by the Salesforce driver, refer to the Supported Configurations page on the Progress DataDirect Web site. You can also query the SYSTEM_REMOTE_SESSIONS system table to get the version of the Web Service API the driver supports.
