Qlik Catalog Connect with Azure Synapse Analytics

[lguevara]

Hi,

I Have Datawarehouse and DataMart in Azure Synapse Analytics, and I want to connect since Qlik Catalog

But in the options not found this type of connections.

JDBC Java Database Connectivity

Protocol: JDBC API Sources Include: DB2, HIVE, MYSQL, ORACLE, POSTGRESQL, SALESFORCE, SQLSERVER, TERADATA

Its posible connect Qlik Catalog with Azure Synapse Analytics and How?

Thanks

[brunnovb_in · Accepted solution]

Hello lguevara!

Reviewing Microsoft's documentation, you can use this connection string (SQLSERVER):

• jdbc:sqlserver://yourserver.database.windows.net:1433;database=yourdatabase;user={your_user_name};password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
• Reference: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-conn...

So I'd suggest something like this: jdbc:sqlserver://SERVIDOR.URL:1433;database=DW_HR_NEW

Best,

Brunno V.B.

[brunnovb_in]

lguevara,

Adding information about new drivers, you can add new database drivers, for example DATABRICKS, in the Qlik Catalog WEB UI (ADMIN>Database Drivers) and it's also important to add the jdbc (jar file) in the folder: /usr/local/qdc/apache-tomcat-9.XX .XX /webapps/qdc /WEB-INF/lib/.

I've added a new database driver in my Qlik Catalog server, as you can see below.

Best,

Brunno.