KNOWLEDGE BASE

Error Code 37CE01A3 "The drivers required to connect to the data source are not installed" Connecting to Oracle from a Mac


Published: 31 Jan 2020
Last Modified Date: 15 May 2020

Issue

When attempting to connect to Oracle from Tableau Desktop on a Mac, the following error occurs: 
An error occurred while communicating with Oracle 
The drivers required to connect to the data source are not installed. 
Note that you might need to make local configuration changes to resolve the error. 
Error Code: 37CE01A3 

clntsh not found 
Unable to connect to the Oracle server "<Server Name>". Check that the server is running and that you have access privileges to the requested database. 
Download and install the drivers, and then connect. 

Environment

  • Tableau Desktop 2020.1, 2019.4.4, 2019.3.5, 2019.2.9, 2019.1.13, 2019.3.15, 2019.2.18, 2018.1.21, 10.5.24, 10.4.25 and newer versions
  • macOS Mojave 10.14.5 and newer
  • macOS Catalina 10.15.0 and newer

Resolution

Option 1

Use Tableau Desktop 2019.4.3, 2019.3.4, 2019.2.8, 2019.1.12, 2018.3.14, 2018.2.17, 2018.1.20, 10.5.23, 10.4.24 or an older version. Click the following link for downloads of current and previous versions of Tableau Desktop: Tableau Desktop Downloads and Release Notes.

Option 2:
    1. Upgrade to Tableau Desktop 2020.1 
    2. Download and install AdoptOpenJDK 8
        a. Choose version OpenJDK 8 (LTS)
        b. Choose JVM HotSpot
    3. Download the JDBC driver (ojdbc8.jar) from Oracle's download page
    4. Copy the JAR file to ~/Library/Tableau/Drivers (the directory may have to be manually created if it does not exist on your computer)
    5. Launch Tableau Desktop 2020.1 and reconnect to Oracle. 

Cause

Current versions of the Oracle Call Interface (OCI) libraries, used by Tableau to connect to Oracle databases, do not function as expected under the latest macOS software notarization requirements enforced by Apple. Our development team is working with Oracle to resolve this connection issue as soon as possible. 
Did this article resolve the issue?