7 Replies Latest reply on Jan 10, 2018 12:28 PM by Chris McClellan

Fetching Data with MySQL and Auto Update of Data

Harshit Gulati Jan 10, 2018 12:31 AM

Hi All,

Greetings for the Day!!

I am having Tableau Public and I want to fetch data from MySQL table.

The hurdles that I am facing are -

->How to connect MySQL with Tableau Public.

->Whenever a new Data gets added to my MySQL table, how will it reflect in Tableau(I don't want to uplaod source data file again and again)

In short my requrement is to make a Tableau workbook, in which, data source is MySQL table, and data gets updated after every new record(Row/Field) is added to table.

Please let me know if there ias any wayout for these problems. As I have asked these questions several time but yet not got any appealing answer.

Thanks in Advance

Warm Regards,

Harshit

1. Re: Fetching Data with MySQL and Auto Update of Data

Chris McClellan Jan 10, 2018 12:52 AM (in response to Harshit Gulati)

You can't connect directly to MySQL from Tableau Public, according to this : https://community.tableau.com/docs/DOC-9135#subhead20

Have you tried Tableau Desktop (Professional) yet ? You can download and use for free for 14 days.
Like Show 0 Likes(0)

Actions
2. Re: Fetching Data with MySQL and Auto Update of Data

Harshit Gulati Jan 10, 2018 12:54 AM (in response to Chris McClellan)

Hi Chris,
If I am having Tableau Desktop, can you explain me how to proceed with such scenario then?
Thanks
Like Show 0 Likes(0)

Actions
3. Re: Fetching Data with MySQL and Auto Update of Data

Chris McClellan Jan 10, 2018 12:58 AM (in response to Harshit Gulati)

I haven't used mySQL much, but it should work the same as any other RDBMS. You can see how it works here : MySQL

If you have a live connection and update the database, the new data will be visible in Tableau as soon as you run the next query - which could be as simple as changing a filter value.

If you have an extract connection, you will need to refresh the extract to see the changed data.
Like Show 0 Likes(0)

Actions
4. Re: Fetching Data with MySQL and Auto Update of Data

Harshit Gulati Jan 10, 2018 1:05 AM (in response to Chris McClellan)

Chris, if in Live connection, I turn on this button, what will happen? Will then data on Tableau will get refreshed (No filter value or other actions performed)
Like Show 0 Likes(0)

Actions
5. Re: Fetching Data with MySQL and Auto Update of Data

Chris McClellan Jan 10, 2018 1:12 AM (in response to Harshit Gulati)

No, that's only the data window.

To refresh the data you actually have to do something in Tableau to make it requery that database.
Like Show 0 Likes(0)

Actions
6. Re: Fetching Data with MySQL and Auto Update of Data

Harshit Gulati Jan 10, 2018 1:26 AM (in response to Chris McClellan)

Thanks Chris. But I was looking for something totally automatic. That No one do nothing, and all the data gets updated.
Like Show 0 Likes(0)

Actions
7. Re: Fetching Data with MySQL and Auto Update of Data

Chris McClellan Jan 10, 2018 12:28 PM (in response to Harshit Gulati)

OK, so I think you're trying to say this ...

"I want to create a dashboard that automagically refreshes every X minutes to show the new data in the database with no human intervention at all."

The answer is - YES, you can do this, but you have to create a workbook with a live connection (VERY easy), publish it to Tableau Server (this won't work with Tableau Public) and then embed it in a webpage that has some Javascript that refreshes the page every X minutes.

You can do all this on demo software - a demo version of Tableau Desktop and a demo version of Tableau Server BUT if this automatically refreshing webpage is displayed on a screen where multiple people can see it then you must buy a core license of Tableau Server to enable "guest access". Talk to your local Tableau Account Manager about these options.
Like Show 0 Likes(0)

Actions