How to Connect Tableau Public to an Oracle Database

As a user of Tableau Public, you may already have the required driver installed on your computer. However, this connector requires a driver to talk to the database. If you are using version 2020.2 or later, make sure to check out the instructions for requiring SSL for Oracle JDBC Connections.

To get started, gather the following connection information:

* The name of the server that hosts the database, as well as the Oracle service name and port, or the TNS name

* Authentication method: Integrated Authentication or user name and password

* Are you connecting to an SSL server? If so, make sure to configure the Oracle client before use with Tableau.

Before proceeding, it's essential to review some key settings:

* Setting an Oracle Connection to Use TNSNames.ora or LDAP.ora

* Note that 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 check out the changes described in the Knowledge Base article.

Once you have all the necessary information, follow these steps:

1. Open Tableau Public and select 'Connect to Data'

2. Choose Oracle as your database connection

3. Enter the server name, service name, port, and authentication method

4. If connecting to an SSL server, ensure that the Oracle client is configured

After successfully connecting to the Oracle database, you can start creating visualizations using Tableau's intuitive drag-and-drop interface.

Additional Resources

* Learn more about connecting to data and creating visually appealing dashboards through Tableau's free tutorials, white papers, and webinars.

* Explore sample Excel files explaining how to format data for Tableau and learn where to get additional help with the software.

* Discover Tableau NIH Library Training Resources, including information on biological data visualization.

Getting Started

Tableau Public is available for both Windows and Mac. You can upload Excel, Access, TXT, and CSV files using Tableau Desktop. Dashboards allow users to combine multiple views of their data into one analytics tool, making it easy to explore data without needing advanced programming skills.

Reserve up to two hours daily for project work or demonstration at the NIH Library's Data Services workstation, where Tableau Desktop is installed.

By following these steps and taking advantage of the resources available, you can connect Tableau Public to an Oracle database and start exploring your data in a more interactive and visually appealing way. Happy analyzing!

Tableau public