Introduction
This documentation provides a step-by-step guide to resolving the OAuth 2.0 authentication error encountered while publishing Data Sources on the Tableau Server using our Tableau connectors or JDBC connectors on Tableau Desktop. The error arises due to the absence of the "OAuthSettings.txt" file, which contains the Access Token and Refresh Token, on the machine where the Tableau Server is installed. This document outlines the solution for Windows operating systems.
Error Description
When attempting to publish data sets on the Tableau Server, you may encounter the following error:
Solution Steps
To resolve this issue, follow these steps:
Step 1: Open Connection Properties
-
Navigate to `C:\Program Files\CData\CData Tableau Connector for <DataSource> <Version>\lib\plugins`. Replace <Data Source> and <Version> with the relevant folder you are working with.
-
Double-click on the “builder.bat” file (a Windows Batch file). This action opens a window with all the connection properties.
Step 2: Set Connection Properties
-
Configure Connection Properties: Set all the necessary connection properties for establishing a successful connection.
-
Set OAuthSettingsLocation Property: Add the following connection property:
OAuthSettingsLocation: C:\Program Files\Tableau\Drivers\OAuthSettings.txt
Ensure that this file path points to a valid location accessible by both Tableau Desktop and Tableau Server.
Step 3: Test Connection and Generate OAuthSettings.txt
-
Test Connection: Successfully establish the connection.
-
Move OAuthSettings.txt to Server: After a successful connection, move the generated "OAuthSettings.txt" file to the following path on the server machine where Tableau Server is installed:
C:\Program Files\Tableau\Drivers\OAuthSettings.txt
-
Generate a new OAuthSettings: After moving the first OAuthSettings.txt file to the server you need to create another one for the Tableau desktop.
Step 4: Verify File Locations
Ensure that both machines have their own "OAuthSettings.txt" file in the ` C:\Program Files\Tableau\Drivers\OAuthSettings.txt ` path. The path should be reachable from the Tableau service to avoid permission issues. Verify that the OAuthSettingsLocation property is set as follows:
OAuthSettingsLocation: C:\Program Files\Tableau\Drivers\OAuthSettings.txt
Step 5: Publish Data Source on the Tableau Server
Once the OAuthSettings.txt file exists in the correct path on both machines and the OAuthSettingsLocation property is correctly configured, you can proceed to publish the Data Source to the Tableau Server without encountering any issues.
By following these steps, you resolve the OAuth 2.0 authentication error and enable seamless data set publishing on the Tableau Server using our connectors.
Note: This solution is specific to Windows operating systems. Make sure to adapt the instructions accordingly if you are using a different operating system.
Please reach out to [email protected] if this does not resolve the problem for you.
