How to access MYSQL Database from tableau?

0 votes
How to access MYSQL Database from tableau?
Mar 19 in Tableau by Sindhu
30 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi Sindhu, 

1. Double click on Mysql on the connect pane on right side of welcome screen.

2. A dialog box below opens.

3. Enter the server, username and password for the server. 3306 is the default value for port.

4. For some, You would be asked to install drivers and connect, then you have to download and install Mysql connector from here ( https://dev.mysql.com/downloads/connector/odbc/?_fsi=lf8zcWf6 )

5. Now click and sign in.

6. Now select the database required.

7. You can see 2 buttons in the data section. (select automatically update to update data whenever updated to refresh )

8. Then drag or select the sheets required and go to Worksheet.

Hope this helps you.

answered Mar 19 by CHERUKURI
• 15,420 points

Related Questions In Tableau

0 votes
1 answer

How to connect to sap hana database from Tableau?

Hi, Follow these steps to connect to data ...READ MORE

answered Mar 22 in Tableau by CHERUKURI
• 15,420 points
37 views
0 votes
1 answer

How to connect to oracle database from Tableau?

Hi, Follow these steps to connect to oracle ...READ MORE

answered Mar 22 in Tableau by CHERUKURI
• 15,420 points
26 views
0 votes
1 answer

How to connect to IBM DB2 database from Tableau?

Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22 in Tableau by CHERUKURI
• 15,420 points
35 views
0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,490 points
292 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,100 points
30 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
893 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
104 views
0 votes
1 answer
0 votes
1 answer

How to access MariaDB Database from tableau?

Hi Nithin,  1. Click on More and then ...READ MORE

answered Mar 19 in Tableau by CHERUKURI
• 15,420 points
25 views
0 votes
1 answer

how to access google Drive files from Tableau?

Hi, 1. Click on google drive from more ...READ MORE

answered Mar 19 in Tableau by CHERUKURI
• 15,420 points
34 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.