You can translate the document:
Goal
This document describes how to connect to Microsoft Azure Synapse SQL (previously known as Azure SQL Data Warehouse).
Content
The Azure Synapse SQL is Transact-SQL compatible, i.e. all mechanisms applicable to SQL Server are applicable to Azure Synapse SQL.
Accessing SQL Data Warehouse from Denodo is a standardized JDBC connection. Therefore, the Microsoft JDBC driver delivered with Denodo can be used.
Prerequisite:
- The Supported Database adapters are Azure SQL and Azure Synapse SQL.
- Get the Connection String to the Azure SQL Data Warehouse database from the Azure Dashboard:
- Note that you might need to provide a firewall rule in Azure which allows your client to access the cloud instance of Azure SQL Data Warehouse.
In order to create a JDBC data source in Denodo follow these steps.
- From Design Studio, create a new JDBC data source from Integrate tab of Quick Access page
- Navigating to “Connect to a data source”. This will open the wizard to list a connection to a data source with a JDBC driver.
- Select data source “Azure Synapse SQL (aka Azure SQL Data Warehouse)” from Analytical & Big Data or “Azure SQL” from SQL list. This will connect to the respective data source.
- Fill all the required fields.
- Name: Name of the new data source.
- Database URL:
- The specific Database URI can be found in the Azure database connection string settings. An example JDBC URI connection string can be found here.
- Login and Password: Credentials to access the database.
- Click on “Test Connection” to make sure the connection is successful.
Example for Azure Synapse SQL
Example for Azure SQL
- Introspect the data source to create base views.
- Query the created base views.
References
Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.