The driver translates the SQL statements provided by the application to Salesforce queries (SOQL) and Web service calls. Refer to "SQL Statements and Extensions for the Salesforce Driver" in the DataDirect Connect Series for ODBC Reference for the SQL statements that the driver supports.The driver uses a client-side data cache for improved performance. You can define rules that specify which data to cache on the client as well as when the cached data becomes invalid and needs to be refreshed (see Client-Side Caches for details).
The driver is supported in the Windows, UNIX, and Linux environments. See Environment-Specific Information for detailed information about the environments supported by this driver.The following figure shows the different components of an environment that uses the Salesforce driver to access Salesforce. Depending on your license from Salesforce.com, the driver could instead connect to Force.com or Database.com.When an application connects to Salesforce through the driver, connectivity to Salesforce is real-time, out of the box. In the background, the driver establishes a Web service session with the Salesforce instance and a database session that opens an embedded database. The application can establish multiple sessions with Salesforce; however, additional Web service and database sessions are always opened in the ratio of one database session per Web service session. The database session maintains the object-to-relational table mapping. In addition, it maintains cached tables and local tables, as well as maintaining views. See Database Configuration File for more details.On Windows, the SQL Engine can be run within the same process space as the ODBC application, or it can be run as a separate process. Some applications may experience problems loading the JVM required for the SQL Engine because the process exceeds the available heap space. If your application experiences problems loading the JVM, you can configure the Salesforce driver to run in a separate 32-bit process within its own JVM. See Configuring the SQL Engine Server for more information.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |