-
1. Re: Fetching Data with MySQL and Auto Update of Data
Chris McClellanJan 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.
-
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
-
3. Re: Fetching Data with MySQL and Auto Update of Data
Chris McClellanJan 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.
-
4. Re: Fetching Data with MySQL and Auto Update of Data
Harshit Gulati Jan 10, 2018 1:05 AM (in response to Chris McClellan) -
5. Re: Fetching Data with MySQL and Auto Update of Data
Chris McClellanJan 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.
-
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.
-
7. Re: Fetching Data with MySQL and Auto Update of Data
Chris McClellanJan 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.