For more information, see Run Initial SQL. (Optional) Select Initial SQL to specify a SQL command to run at the beginning of every connection, such as when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. Select the Require SSL check box when connecting to an SSL server. Specify whether to use Integrated Authentication or a specific user name and password. Select how you want to sign in to the server. If you enter the TNS name, do not enter the Oracle service name and port number. (in the ORACLE_HOME/network/admin directory by default) and search for the net_service_name section. Note: To find the correct service name, open the tnsnames.ora file

If you enter the server name, you must enter the Oracle service name and port number. Start Tableau and under Connect, select Oracle.įor a complete list of data connections, select More under To a Server. Make the connection and set up the data source See the Driver Download (Link opens in a new window) page for instructions. Note: If you experience issues using the JDBC driver for this connector, an OCI driver is still available and can be used instead. The newer JDBC driver resolves some limitations found with the OCI driver, such as no spatial support or Kerberos delegation on Linux. (available from the Driver Download (Link opens in a new window) page) with this connector.

JDBC driver versus OCI driverīeginning with version 2020.2, Tableau recommends that you use the JDBC driver If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download (Link opens in a new window) page where you can find driver links and installation instructions. You might already have the required driver installed on your computer. This connector requires a driver to talk to the database. (Optional) Initial SQL statement to run every time Tableau connects If you are using version 2020.2 or later, see Require SSL for Oracle JDBC Connections. Name of the server that hosts the database you want to connect to and the Oracle service name and port, or the TNS nameĪuthentication method: Integrated Authentication or user name and passwordĪre you connecting to an SSL server? You must configure the Oracle client before you can use SSL with Tableau. Before you beginīefore you begin, gather this connection information: Setting an Oracle Connection to Use TNSNames.ora or LDAP.ora. Note: Beginning with Tableau 2020.2, if you want to publish a data source or workbook using net_service_names to Tableau Server, be sure to review the changes described in the Knowledge Base article, To an Oracle database and set up the data source. This article describes how to connect Tableau

Run oracle sql client for mac