Connecting Tableau to SQL Azure via ODBC Driver (2024)
Importing SQL Azure Data Into Tableau Through an ODBC Connection
This article explains to establish and ODBC connection to SQL Azure from Tableau Desktop. Tableau is a data visualization tool that allows you to pull in raw data, perform analysis on it, and create meaningful reports to get actionable insights. With Tableau Desktop and our suite of ODBC drivers, you can connect to various relational and non-relational databases, both cloud and on-premise.
Run Tableau Desktop.
On the start page, select More... in the Connect pane.
Choose Other Databases (ODBC).
Expand the DSN drop-down list and select the DSN that you have created and configured for SQL Azure. Alternatively, if you have not created a DSN, you can choose the Driver option and select Devart ODBC Driver for SQL Azure from the drop-down.
Click Connect.
After a successful connection, click Sign in.
Select the needed database and schema in SQL Azure.
You should see the list of all tables you have access to in the connected data source.
Drag-and-drop the table name to the area where it says Drag tables here to retrieve the data, or click New Custom SQL to write a query that will select only specific data from the table.
In Windows, search for ODBC Data Sources, and open the ODBC Data Sources desktop app. Select Add. Select ODBC Driver 17 for SQL Server then Finish. Enter a name and description for the connection and the cluster you want to connect to, then select Next.
Tableau natively connects to Google Cloud SQL. Simply download Tableau Desktop to get started, click on the Google Cloud SQL connector, and fill out the connection information. Your tables will be available instantly in Tableau to join, analyze and even blend with other datasources.
Tableau allows you to utilize solutions like Snowflake and SAP HANA on Azure, and live connectivity provides real-time access to data directly in the cloud. Tableau provides a fast and scalable enterprise analytics platform for the Azure data services that organizations already use.
The database drivers that are installed on the Tableau Server can be seen from the Program and Feature section in the Control Panel. Additionally drivers can be found by going to the start menu and searching for "ODBC Data Source Administrator".
To connect to Azure SQL Database using Python, install the pyodbc driver. This package acts as a data provider for connecting to databases, executing commands, and retrieving results.
Sign in to the Azure portal. Select SQL Databases from the left-hand menu, and select your database on the SQL databases page. Select Connection strings under Settings and copy the complete ADO.NET connection string. For Azure SQL Managed Instance copy connection string for public endpoint.
The first time you run Azure Data Studio the Welcome page should open. If you don't see the Welcome page, select Help > Welcome. Select New Connection to open the Connection pane:Something like: servername.database.windows.net.
Address: Apt. 536 6162 Reichel Greens, Port Zackaryside, CT 22682-9804
Phone: +9958384818317
Job: IT Representative
Hobby: Scrapbooking, Hiking, Hunting, Kite flying, Blacksmithing, Video gaming, Foraging
Introduction: My name is Jamar Nader, I am a fine, shiny, colorful, bright, nice, perfect, curious person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.