KNOWLEDGE BASE

Tableau Prep outputs values with incorrect number format to external Oracle database


Published: 22 Jul 2021
Last Modified Date: 30 Jul 2021

Issue

After Tableau Prep's output of Excel data file to Oracle database, the new database table shows negative and false numbers unlike in Tableau Prep.

User-added image

Environment

  • Tableau Prep 2021.2.1
  • Windows 10
  • Oracle

Resolution

Instead of using Oracle OCI driver, follow these steps below to use Oracle JDBC driver (ojdbc8.jar)

1: Go to Control Panel -> Uninstall a Program

2: Search for "oracle" and uninstall anything like "Tableau202x. ... Oracle Driver"

3: Download the Oracle JDBC driver (ojdbc8.jar) from https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19c-downloads.html

4: Copy the .jar file to this folder: C:\Program Files\Tableau\Drivers

Cause

Beginning with version 2020.2, Tableau recommends that you use the JDBC driver with this connector. The newer JDBC driver resolves some limitations found with the OCI driver.
Did this article resolve the issue?