ETL Validator can be used to compare data between Azure SQL Data Warehouse and other data sources. This post details the steps to create a Data Source connection to Azure SQL Data Warehouse.
ETL Validator Server uses JDBC driver to connect to SQL Server data sources. There are two JDBC driver options supported by ETL Validator - JTDS (default in ETL Validator) and Microsoft JDBC Driver for SQL Server. However, only the Microsoft JDBC Driver for SQL Sever supports connecting to the Azure SQL Data Warehouse.
Follow these steps to create a connection for Microsoft SQL Data Warehouse in ETL Validator:
- Add a new data source connection and select ' Microsoft SQL Server'
- Choose the 'Custom' option so that you can specify the JDBC Connection string as shown below
Sample JDBC URL format: jdbc:sqlserver://<hostname>:<port number>;Databasename=<database name>
Note that the default connection string has "jdbc:jtds:sqlserver" in the beginning. But this uses the JTDS JDBC driver which cannot connect to Azure SQL Data Warehouse. By changing the connection string to 'jdbc:sqlserver', ETL Validator will use the Microsoft JDBC driver for SQL Sever.