Tableau Now Offers Deeper Integration with Microsoft Azure

By Jeff Feng 10 Juil, 2015

Data in the Clouds

For years, Tableau has integrated with a number of Microsoft technologies including SQL Server, SQL Server Analysis Services, Excel, Access, Sharepoint Server, PowerPivot, and Microsoft Azure Marketplace DataMarket to help people visualize their data. With more data moving to the cloud, we’ve worked with Microsoft to provide deeper integration with Azure.

We are excited to announce new integrations with Spark on Azure HDInsight, a cloud-hosted Apache Spark service, Azure SQL Data Warehouse, a fully-managed elastic data warehouse as a service, and Azure SQL Database, a relational database as a service. These services are a perfect companion to Tableau Online, our secure and scalable cloud analytics solution.

The integration supports both live connectivity and in-memory extracts. This means that you can take full advantage of the power of Azure which provides you with real-time access to your data directly in the cloud, no extracts or snapshots required. Our connectivity to these cloud-hosted services not only reflects a change in user preference for storing data, but also enables customers to both store and analyze data completely in the cloud.

Spark on Azure HDInsight is Microsoft’s new big data service powered by the cloud. We are seeing tremendous adoption of Spark in the marketplace and it's exciting to see Microsoft provide another option for customers. Our connector to Azure's hosted Spark cluster enables business analysts, developers, and data scientists to interactively explore large data sets and data models.

Tableau is the perfect visual analytics solution for Spark providing an easy to use, fast, and interactive analytics platform for everyone. Users do not need to write Spark SQL or code to start answering questions of the data. Simply connect and go, and your data comes to life. (See interactive data analysis in action with Tableau & Spark on HDInsight in this video by Asad Khan, principal program manager for Big Data at Microsoft.)

Additionally, Azure SQL Data Warehouse is an enterprise-class cloud data warehouse that was first announced at Microsoft’s Build developer conference on April 29. This service compliments Azure SQL Database, Microsoft's database as a service. Tableau makes it easy to connect to SQL Data Warehouse and SQL Database with our new optimized connector. Combined with Tableau Online, you can now deploy a complete enterprise-scale BI, DW, & database solution completely in the cloud in minutes.

“Increasingly, organizations are both hosting and analyzing data in the cloud because of the cost efficiency, elasticity and agility the solution offers,” said Tiffany Wissner, senior director of data platform marketing at Microsoft. “We are delighted to work with Tableau to provide direct connectivity from Tableau to Spark on HDInsight, SQL Data Warehouse and SQL Database because their tool empowers all users within organizations to visualize and ask deeper questions of their data.”

Connectivity to Spark on HDInsight and SQL Data Warehouse is now generally available in Tableau 9.0.3 or later for Tableau Desktop, Tableau Server and Tableau Online. Connectivity to SQL Database will be available in the coming weeks.

Test Drive: To try out Tableau Online and experience rapid-fire cloud BI against your own data today, take a test drive here.


Respond: Do you have an interesting cloud data or big data use case? We’d love to hear about it. Please reach out and let us know.


Submitted by Thierry (non vérifié) on

Excellent news.

Submitted by Zsombor Z. on

The Azure SQL DB connection in the desktop version 9.0 and 9.1 is not available. Right?

Submitted by Zsombor Z. on

Hi Jeff,

If you have a server in the Microsoft Cloud and is dedicated to you then it works, normal, because that is a regular SQL server connection, connection to a normal SQL server.

But if you use the Azure SQL DB where the instances are shared, basically each user owns a DB then when you connect you need to specify the name of the database. This is how it works with Azure SQL DB.

Since the connection window of the SQL Server in Tableau does not allow to specify a database name, it will not connect, it will give you an error message.

The only way to connect is via ODBC, but this is sub-optimal, knowing the issues that ODBC has (performance, restrictions on the ODBC connection in Tableau - date columns, etc.)

So I would say that this is not possible.

Contact me if you need more details about how do you need to connect to an Azure SQL DB.


Submitted by Jeff Feng (non vérifié) on

Hi Zsombor,

Sorry for the delay as I didn't see your comment until now. If you could, please send me a personal message to so that we can learn about the details in supporting your use case.


Submitted by Lou (non vérifié) on

Hi Jeff,

I'm wondering if you have resolution on connecting to Azure SQL DB? I'm actually interested to learn of the connectivity options with Azure SQL Data Warehouse. In particular, is a live connection supported by Tableau online?

Submitted by Alexander H. on


Is there any news on how to connect to SQL Azure?

Thanks in advance,

Submitted by Saurabh Kansal (non vérifié) on

How can i integrate Tableau with Azure ML studio ?

Submitted by Claire S. on

Has anyone successfully connected to Azure SQL DB from Tableau natively? Or is the only option the ODBC route?


Submitted by Zsombor Zsuffa (non vérifié) on

I am looking now on version 9.3 and the problem with the connection to Azure SQL DB is not resolver. I documented the problem clearly and I sent it to Tableau but there is not solution implemented yet.

Submitted by Margrettd (non vérifié) on

Have you ever imagined how the world used to carry out all business activities without having an easy access to the internet? Thankfully, we are born in the era in which everything can be managed online. As for example, you can sell your products and services through your website. All you need to do is to hire web development experts, choose the most appropriate domain name, and get in touch with the most reliable web hosting service provider that suits your budget. You can also seek suggestions by visiting and following a few steps quickly.

Ajouter un nouveau commentaire