How to create connection to Azure synapse analytics

[Guruapexon]

How to create connection to azure synapse analytics:

Kindly let me know the steps to connect to the tables in azure synapse analytics 

and what are the details required for doing so

[Chip_Matejowsky · Accepted solution]

Hello @Guruapexon,

You can use the Qlik ODBC Connector package to connect to Azure Synapse Analytics. Refer to the Qlik online Help entries Azure Synapse Analytics and Create an Azure Synapse Analytics Connection for details.

Best Regards

[Guruapexon]

Thanks for the Reply,

We have gone through the steps, we are using Qlik Sense September 2019 version, does this support installing the Azure Synapse Analytics connector and we the version of Azure is 

Microsoft Azure Synapse SQL Analytics - 10.0.20438.0 

Are these compatible.

[Chip_Matejowsky · Accepted solution]

Hi @Guruapexon,

The Qlik Sense Help entry Azure Synapse Analytics lists the supported offerings (Qlik products) and supported Azure Synapse Analytics versions

Supported offerings

• Qlik Sense Enterprise on Windows
• Qlik Sense Enterprise SaaS
• QlikView (Requires separate installation)

Supported Azure Synapse Analytics versions

The following data versions are supported:

• 2020

Best Regards

[Guruapexon]

Can we know the specific Azure Synapse Analytics driver name that needs to be installed in Qliksense server node so that we can create a direct ODBC connection (System DSN) and use this System DSN in Qlik sense to connect to this database.

[Chip_Matejowsky · Accepted solution]

Hi @Guruapexon,

That would be more of a question for Azure Synapse Analytics and what driver(s) it supports. I did a basic Google search on "Azure Synapse Analytics driver" and the following returns were shown:

• https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connect-overview
• https://www.cdata.com/drivers/azuresynapse/odbc/
• https://www.devart.com/odbc/sqlsynapse/

Suggest that you ask the DBA who's responsible for this Azure Synapse Analytics db what they recommend.

Best Regards

[Guruapexon]

Is Azure Syanpse Analytics Connector and Azure SQL Database Connector both are same or what are the differences,  in what scenario we should use the 1st and 2nd specifically.

[Guruapexon]

The Azure Synapse Connector has same functionality of Azure SQL Connector in QlikSense versions prior to 2021.

Is this true ?

[Guruapexon]

Actually we need to connect to Azure Synapse Analytics DB, and we using Qliksense ver 2019, so can we use Azure SQL Database connector to connect Azure Synapse Analytics DB. Kindly confirm

[Chip_Matejowsky · Accepted solution]

Hi @Guruapexon,

Yes, they are both part of the ODBC Connector, as I stated in my first response to your query. 

Best Regards