How to Connect to Azure Synapse Analytics

Azure Synapse Analytics is a cloud-based Enterprise Data Warehouse that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.

Connect to MicroStrategy Web and click Add External Data from the Home page.
Select Azure Synapse Analytics from the Connect to Your Data window.
Select a query type from the Select Import Options window.
Click the icon next to Data Sources to add a new data source.
Select the DSN-less Data Sources option.
Edit the Host Name, Port Number, and Database Name as needed.
By default, the MicroStrategy ODBC Driver for SQL server produces the following connection string:
Copy
```
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname=; Port=1433; Database=; EncryptionMethod=1; ValidateServerCertificate=0;EnableQuotedIdentifiers=1;
```
To edit the string, click Show connection string > Edit connection string and edit from the Connection String dialog.
Enter your credentials and rename the Data Source Name.
Click Save.

How to Connect to Azure Synapse Analytics

Related Topics