topic Re: Qlik Catalog Connect with Azure Synapse Analytics in Catalog and Lineage

Qlik Catalog Connect with Azure Synapse Analytics

lguevara — Mon, 09 Jan 2023 22:29:18 GMT

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

Re: Qlik Catalog Connect with Azure Synapse Analytics

brunnovb_in — Mon, 09 Jan 2023 23:02:43 GMT

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-connection-strings

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

Best,

Brunno V.B.

Re: Qlik Catalog Connect with Azure Synapse Analytics

brunnovb_in — Mon, 09 Jan 2023 23:14:30 GMT

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.