KNOWLEDGE BASE

Unable to refresh extract of Maxcompute data source on Tableau Server


Published: 24 Mar 2022
Last Modified Date: 26 Mar 2022

Issue

Unable to refresh extract of Maxcompute data source and the following error appears:
 
java.lang.RuntimeException: No suitable driver installed, or the URL is incorrect

 

Environment

  • Tableau Linux Server
  • Alibaba MaxCompute

Resolution

Install Alibaba MaxCompute Driver on all nodes where the Backgrounder process is configured.
  1. Download the latest JDBC driver (odps-jdbc-[version]-jar-with-dependencies.jar file) from the Aliyun GitHub site.
  2. After you download the .jar file, copy it to this location on the Linux computer:
     /opt/tableau/tableau_driver/jdbc

If the directory doesn't exist, create it and make sure it's readable by the "Tableau" user. To do this follow these steps:
  1. Create the directory: 
    • sudo mkdir -p /opt/tableau/tableau_driver/jdbc
  2. Copy the downloaded driver file to the location, replacing [/path/to/file] with the path and [driver file name] with the name of the driver you downloaded:
    • sudo cp [/path/to/file/][driver file name].jar /opt/tableau/tableau_driver/jdbc
  3. Set permissions so the file is readable by the "tableau" user, replacing [driver file name] with the name of the driver you downloaded:
    • sudo chmod 755 /opt/tableau/tableau_driver/jdbc/[driver file name].jar

Cause

Alibaba MaxCompute Driver is not installed on node 2 (2 nodes Tableau Server cluster).
Did this article resolve the issue?