Thin sql client odbc install#

One way to do this is to connect to the server via SQL*Plus. For additional information see - Oracle FAQ or refer to the Oracle documentation for the version you are using.Īfter the Oracle Client is set up on the Jitterbit Agent, you should test the server to ensure that Jitterbit has connectivity to the database. This is part of the standard Oracle Client setup procedure. Once you have installed the Oracle Client, configure the tnsnames.ora file to reference the database you are planning to use.

Thin sql client odbc install#

To resolve these issues please install the 32-bit version.

If you are using a 64-bit Oracle Client and ODBC driver, you will experience problems connecting to your Oracle database. Currently, the Oracle ODBC driver installed on all Agents in the Agent Group must be 32-bit. Jitterbit currently supports 32-bit drivers. See Agents > Agents and Agents > Agent Groups for more information. If you are using multiple Private Agents within an Agent Group, the Oracle Client must be installed on all Agents in the group. Install the Oracle Client on the Jitterbit Private Agentīefore you can establish a connection to Oracle via ODBC, you must have the Oracle Client (including the Oracle ODBC driver) installed on your Jitterbit Private Agent. The JDBC driver is recommended for additional features, such as manual creation of SQL scripts, that are not available via an ODBC connection. NOTE: You can also connect to an Oracle database using a JDBC driver.