0 votes
1 view
in Others by (2.5k 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)

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...

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 22, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 16, 2020 in Azure by dante07 (13.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !

Categories

...