(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
#HOW TO USE TABLEAU ON MAC DRIVER#
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.
#HOW TO USE TABLEAU ON MAC HOW TO#
This article describes how to connect Tableau
0 kommentar(er)
