How to connect to Azure SQL Data Warehouse from Denodo

Applies to: Denodo 7.0
Last modified on: 06 Nov 2019
Tags: Cloud JDBC data sources SQL Server

Download document

Goal

This document describes how to connect to Microsoft Azure SQL Data Warehouse from Denodo.

Content

The Azure SQL Data Warehouse is Transact-SQL compatible, i.e. all mechanisms applicable to SQL Server are applicable to Azure SQL Data Warehouse.

Accessing SQL Data Warehouse from Denodo is a standardized JDBC connection. Therefore, the Microsoft JDBC driver delivered with Denodo can be used.

Prerequisite:

  1. The Supported Database adapters are Microsoft SQL Server 20**driver. (eg.2016,2014).
  2. The Microsoft JDBC driver is delivered with Denodo 7.0.
  3. The Microsoft JDBC driver is delivered with Denodo 6.0 from update 20170515. For prior updates of Denodo 6.0, the Microsoft SQL Server driver can be downloaded from the Microsoft Website here.
  4. Since Denodo update denodo-vdp-v70-update-20190312 the database adapter Azure SQL Data Warehouse is available. The Microsoft JDBC driver is set automatically to mssql-jbc-7.x
  5. Get the Connection String to the Azure SQL Data Warehouse database from the Azure Dashboard:
  1. 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.

  1. From the Virtual DataPort Administration tool, create a new JDBC data source by selecting “File > New > Data source > JDBC”. This will open the wizard to create a connection to a data source with a JDBC driver.
  2. Fill all the required fields.
  • Name: Name of the new data source.
  • Database adapter: 
  • Denodo versions prior to denodo-vdp-v70-update-20190312: Version of the database, select Microsoft SQL Server 2016 (MS Driver).
  • Denodo versions from denodo-vdp-v70-update-20190312 and later: select Azure SQL Data Warehouse
  • Login and Password: Credentials to access the database.
  • Click on “Test Connection” to make sure connection is successful.

asdfasd

Example prior to denodo-vdp-v70-update-20190312

Example for denodo-vdp-v70-update-20190312 and later

Note: The specific Database URI can be found in the Azure database connection string settings. An example JDBC URI connection strings can be found here.

  1. Introspect the data source to create base views.

References

Virtual DataPort Administration Guide: JDBC Sources

Virtual DataPort Administration Guide: Supported JDBC Data Sources

Azure SQL Data Warehouse

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training