Back

Explore Courses Blog Tutorials Interview Questions

tableau and mariadb connectivity issues

0 votes
2 views
in Others by (2.6k points)

I am trying to connect Tableau Desktop (tried version 9.2 and 2018.1 both) with MariaDB (Server version: 10.0.20-MariaDB-log MariaDB Server). I am selecting MySQL in the list of data source servers in Tableau. The connection is getting established but

1. Databases are not visible  
2. Custom SQL is not available Data refresh  
3. Live or extract options are not visible

1 Answer

0 votes
by (7.2k points)
edited by

When you are connecting to MySQL, the data source works perfectly fine if we need to connect to MariaDB. You need to take care of some points because there are few differences.

Follow these tracks to solve your problem:

In connecting to the data source, select Other Databases (ODBC)

Select Driver and choose MySQL ODBC 5.3 Unicode Driver

Provide connection details like server IP, port, username, and password that is used to connect with MariaDB

After doing this, you will get your solutions...

Get trained to use Tableau with full potential through Tableau Online Training.

Related questions

0 votes
1 answer
How can I establish connectivity between Tableau and SQL Server?
asked Jul 30, 2019 in BI by Ashok (47.2k points)
0 votes
4 answers
what exactly is the difference between mysql and mariadb?
asked Feb 25, 2021 in SQL by RohitSingh (2.6k points)
0 votes
1 answer
How does supply chain issues contribute to Inflation?
asked Apr 14, 2023 in Others by vyeshma (32.3k points)
0 votes
1 answer
Netlogo Export/Tableau issues
asked Jul 22, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
What is the way to find out MySQL/ MariaDB version for Maven
asked Mar 31, 2021 in SQL by rahulnayar01123 (6.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...