New Tableau Online Direct Connection to Hosted Databases

By Ashley Jaschke February 4, 2015

We are happy to announce new Tableau Online direct connectivity to Internet hosted databases. Our live connections to Amazon Redshift and Google BigQuery have been so popular among our Tableau Online customers that we've added more in the latest Online maintenance release. You can now establish a direct connection to your cloud hosted MySQL, PostgreSQL or Microsoft SQL Server databases in just two steps.

For Tableau Online customers that are using popular hosting platforms like Amazon RDS, Amazon EC2, or Microsoft Azure for their MySQL, PostgreSQL, or Microsoft SQL Server databases this means worksheets and dashboards can be configured to be in constant sync with their datasources. The video below by Tableau’s Dustin Smith demonstrates just how easy it is to take advantage of this new capability in Tableau Online by using real-time social media data (special thanks to our friends at DataSift).


Full screen viewing is recommended

It’s easy to get started with a few simple steps:

1. As a Tableau Online admin, go into the Maintenance tab and click to “Allow live connections to MySQL, PostgreSQL, and SQL Server data hosted on the Internet.”

2. Add the Tableau Online IP to the authorized list (whitelist) in your hosted data provider account and you’re ready to publish Workbooks that connect live to the data sitting in your cloud databases.

Learn more about cloud analytics or visit our Online Help page for more information for setup instructions.

Comments

Submitted by Sten L. on

Would this work for any MySQL, PostgreSQL or MS SQL hosted on a server connected to the internet, or just the cloud solutions mentioned?

Submitted by Ashley J. on

It should work for any hosted solutions as long as you have whitelisted the Tableau Online IP. Please let me know if you have any issues.

Submitted by Guest (not verified) on

How do I find the tableau online IP? How does one add it to white list on AWS EC2? Thanks!

Submitted by Jenny Zhang (not verified) on

Does Tableau also provide ability to schedule refresh jobs for MySQL data extract in Tableau online? Which version of Tableau has this direct connection to hosted databases? Thank you very much.

Submitted by Jenny Z. on

Does Tableau also provide ability to schedule refresh jobs for MySQL data extract in Tableau online? Which version of Tableau has this direct connection to hosted databases? Thank you very much.

Submitted by Ashley J. on

Yes, it provides the ability to schedule refresh jobs for your MySQL data (assuming that it is internet hosted). Tableau Online has the feature available in the current version it's running today. Check out Dustin's demo above to see how it works and let us know if you have any other questions.

Submitted by Johna951 (not verified) on

Fantastic website. A lot of useful information here. I'm sending it to a few pals ans also sharing in delicious. And naturally, thank you in your sweat! eeccadeaebfg

Submitted by Jenny Z. on

Hi,

The link you provided does not work anymore. Can you provide a new link? Thank you very much.

Submitted by Javier Melchor (not verified) on

Hello..very interesting... I´d like to use this improvement but, in my case, the difference is that i am taking the data from my database stored in Mongodb via ODBC Driver and publishing an extract in Tableau online...Is there a way to do the same with NoSQL databases?

Thanks for your help!

Regards

Submitted by soumen (not verified) on

Is this facility also available for data residing in Amazon S3?
if not then please let me know if there is a way to connect Tableau online to Amazon s3 objects so that extract refreshes may be automated in a live fashion

Submitted by chukchuk (not verified) on

You can watch movies to get some entertainment. You can use this app on Android/iOS. Here is the direct download link to get latest movies on Android smartphones.
https://spielhackcheats.de

Submitted by eCareerbay (not verified) on

Hi admin,

eCareerbay is a platform built to bridge the gap between employers and job seekers, enabling them to exchange information, quickly, securely, effectively and inexpensively.

Thanks

Submitted by eCareerbay (not verified) on

Hi admin,

eCareerBay is an online platform for employers/recruiters to hire quality talent and for job seekers to search and apply for their dream jobs. I like your blogs.

Submitted by Zack (not verified) on

Can Tableau online connect to a private subnet (Redshift) using SSH tunnel/reverse tunnel etc?

Submitted by SRIDHAR S. on

@Zack, Are you able to Tableau online connect to a private subnet (Redshift) using SSH tunnel? Your response is greatly apprciated.

Submitted by Deepika S. on

Hi,

I have a datasource which is present in AWS.How to create workbook which access this data and then available on cloud to view.
Do I have to create this in desktop and connection made to AWS and then publish on tableau online?In that case how tableau online be aware of the datasource associated with workbook? or I have to publish that datasource as well on Tableu online?
Can I host the tableau workbook in my company AWS environment?If yes what could be needed?

Submitted by suraj N. on

HI Shridhar, Greatly appreciate if you could you share your findings, as we are also looking for an similar alternative..

Thanks,
Suraj

Add new comment

non-humans click here