Skip to main content
GroupsNewbie, Tableau ServerTariq Aziz's Question
Tariq Aziz asked in Newbie, Tableau Server
Jan 9, 2023, 6:04 PM

Data-source connection issue - Tableau Server unable to connect and run extracts on databricks database.

Hello Guys,

We recently deployed our Tableau Server (Prod, QA). There are clients who can't refresh their extracts due to data-source connection issues. The error displayed when connecting through the server is a missing driver. When I tested the connection using 'test connection' it fails instantly.

 

The servers are in a different AWS env than before where teams were able to connect to their data bricks databases.

 

I pinged the database server from the production machine but the request timed out. When pinged by the QA machine, the request succeeded. I believe there are some issues related to the change in aws env (IP whitelisting or etc.).

 

Database: databricks database.

Driver: Simba ODBC driver for databricks.

Driver version on server machines: Simba ODBC 2.6.5

Driver version on user machines: Simba ODBC 2.6.25

 

Any help in the direction I could take will be helpful.

2 answers
  1. Rich Millngton (FeverBee)
    Jan 12, 2023, 10:43 PM

    Based on the information provided, it seems like there are a few potential issues that could be causing the data-source connection issues with your Tableau Server and Databricks database:

     

    1. IP Whitelisting: As you mentioned, there could be an issue related to IP whitelisting in the new AWS environment. Verify that the IP address of the Tableau Server is whitelisted on the Databricks database server and that the necessary ports are open.
    2. Driver Version: The driver version on the server machines is different from the user machines, which could be causing compatibility issues. Make sure that the same version of the driver is installed on both the Tableau Server and the user machines.
    3. Network Connectivity: The fact that the ping request to the database server timed out when coming from the production machine, but succeeded when coming from the QA machine, suggests that there may be network connectivity issues that are preventing the Tableau Server from reaching the Databricks database.
    4. Firewall: Check if there is any firewall blocking the connection.
    5. Permission: Check if the Tableau Server has the necessary permissions to access the Databricks database.
    6. Configuration: Check if the ODBC driver is correctly configured and the necessary environment variables are set.
    7. Third-Party Security : If you are running any third-party security solutions, check if it is blocking the connection.

     

    You can try to troubleshoot the issue by checking the log files of the Tableau server and the Databricks database, as well as trying to connect to the database using a different tool (such as the Simba ODBC Driver Manager) to see if the issue is specific to Tableau Server.

    You can also contact Tableau Support or Databricks Support for additional help in troubleshooting the issue.

Write an answer...
0/9000