The following drivers use a Java-based SQL engine to provide SQL support:
  • Aha!
  • Apache Cassandra
  • Autonomous REST Connector
  • GitHub
  • Google Analytics 4
  • Google BigQuery
  • HubSpot
  • Microsoft Dynamics 365
  • Microsoft SharePoint
  • MongoDB
  • Oracle Service Cloud
  • Salesforce
  • SAP S/4HANA
  • Snowflake
  • TeamCity

The SQL Engine can be run in one of the following modes: direct, server, Broker, or auto. When set to direct mode, both the driver and its SQL engine run in the ODBC application's address space. However, some applications may experience problems loading the JVM because the process exceeds the available heap space.

To avoid this issue, you can configure the driver to operate in server mode or Broker mode. Both server and Broker mode allow the driver to connect to an SQL engine JVM running as a separate service. The primary difference is that Broker mode uses the driver's Broker to start and stop the service as needed, while server mode requires the service to be explicitly started and stopped by the application or a user. Currently, Broker mode is supported only by the MongoDB driver.

When set to auto mode, the SQL Engine attempts to run in server mode first, but will failover to direct mode if the initial mode is unavailable. Refer to your driver's documentation for more information on the behavior of auto mode.

For more information on default settings and configuring the driver to operate in Broker and server mode, refer to the user’s guide for your driver.

If you plan to use server mode, your installer can use the following executables to install and uninstall the SQL engine server.
Note: Note that the SQL engine server executable files are not used by the driver for Broker or direct mode.
For the Aha! driver:
  • 32-bit: install_dir\ahaserver32.exe
  • 64-bit: install_dir\ahaserver64.exe
For the Apache Cassandra driver:
  • 32-bit: install_dir\cassandraserver32.exe
  • 64-bit: install_dir\cassandraserver64.exe
For the Autonomous REST Connector:
  • 32-bit: install_dir\autorestserver32.exe
  • 64-bit: install_dir\autorestserver64.exe

For the GitHub driver:

  • 32-bit: install_dir\githubserver32.exe
  • 64-bit: install_dir\githubserver64.exe

For the Google Analytics 4 driver:

  • 32-bit: install_dir\googleanalytics4server32.exe
  • 64-bit: install_dir\googleanalytics4server64.exe

For the Google BigQuery driver:

  • 32-bit: install_dir\googlebigqueryserver32.exe
  • 64-bit: install_dir\googlebigqueryserver64.exe

For the HubSpot driver:

  • 32-bit: install_dir\hubspotserver32.exe
  • 64-bit: install_dir\hubspotserver64.exe

For the Microsoft Dynamics 365 driver:

  • 32-bit: install_dir\dynamics365server32.exe
  • 64-bit: install_dir\dynamics365server64.exe

For the Microsoft SharePoint driver:

  • 32-bit: install_dir\sharepointserver32.exe
  • 64-bit: install_dir\sharepointserver64.exe

For the MongoDB driver:

  • 32-bit: install_dir\mongodbserver32.exe
  • 64-bit: install_dir\mongodbserver64.exe

For the Oracle Service Cloud driver:

install_dir\rightnowserver.exe

For the Salesforce driver:

  • 32-bit: install_dir\salesforceserver32.exe
  • 64-bit: install_dir\salesforceserver64.exe

For the Snowflake driver:

  • 32-bit: install_dir\tools\snowflakeserver32.exe
  • 64-bit: install_dir\tools\snowflakeserver64.exe

For the SAP S/4HANA driver:

  • 32-bit: install_dir\tools\s4hanaserver32.exe
  • 64-bit: install_dir\tools\s4hanaserver64.exe

For the TeamCity driver:

  • 32-bit: install_dir\teamcityserver32.exe
  • 64-bit: install_dir\teamcityserver64.exe