Connect Tableau to Azure Synapse Analytics

Some organizations choose to store their visualization source data in Azure Synapse Analytics, and then connect to Azure Synapse Analytics from Tableau.

You may send an Apache Parquet, Apache Avro, CSV, or JSON file from Amperity to Azure Blob Storage, load that data to Azure Synapse Analytics, and then connect to that data from Tableau.

What is Azure Synapse Analytics?

Azure Synapse Analytics is a limitless analytics service and data warehouse. Azure Synapse Analytics has four components: SQL analytics, Apache Spark, hybrid data integration, and a unified user experience.

Add workflow

Amperity can be configured to send data to an Azure Blob Storage container, after which Azure Synapse Analytics can be configured to load that data. Tableau can be configured to connect to Azure Synapse Analytics and use the Amperity output as a data source.

You may use the Azure Blob Storage container that comes with your Amperity tenant for the intermediate step (if your Amperity tenant is running on Azure). Or you may configure Amperity to send data to an Azure Blob Storage container that your organization manages directly.

Connect Tableau to Azure Synapse Analytics.

To connect Tableau to Azure Synapse Analytics

The steps required to configure Amperity to send data that is accessible to Tableau from Azure Synapse Analytics requires completion of a series of short workflows, some of which must be done outside of Amperity.

  1. Use a query return the data you want to make available to Tableau for use with data visualizations.

  2. Send an Apache Parquet, Apache Avro, CSV, or JSON file to Amazon S3 from Amperity.

  3. Load data from Azure Blob Storage to Azure Synapse Analytics.

  4. Connect Tableau to Azure Synapse Analytics , and then access the data sent from Amperity.

  5. Validate the workflow within Amperity and the data within Tableau.

  6. Configure Amperity to automate this workflow for a regular (daily) refresh of data.