The Progress® DataDirect® for JDBC™ for Salesforce™ driver supports standard SQL query language to select, insert, update, and delete data from Salesforce.com and other Web service data stores that use the Salesforce API such as Force.com, and Veeva CRM. 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 with the metadata methods getBestRowIdentifier(), getColumns(), getExportedKeys(), getImportedKeys(), getPrimaryKey(), getTables(), and getTypeInfo().

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 JDBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for JDBC, including content on troubleshooting, supported SQL escapes, and DataDirect tools.

For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.