Microsoft's SQL Server Parallel Data Warehouse (PDW) is a version of SQL Server built specifically for high performance data warehousing to deliver high performance for data warehouse implementation. QuerySurge customers who use PDW as a major Data Warehouse component need to connect QuerySurge to PDW in order to test their ETL processes. This article explains how to connect QuerySurge with PDW.
Setting up a Connection to SQL Server PDW
Connecting to SQL Server PDW is done using the Connection Extensibility feature of the QuerySurge Connection Wizard. The following steps describe what you'll need to set up your QuerySurge Connection to PDW.
- QuerySurge connects to PDW using the "standard" SQL Server JDBC driver.
- Deploy the SQL Server JDBC driver to your Agent(s), if you did not do so when you installed your Agent(s). The procedure for deploying a new driver to a QuerySurge Agent is here (for Agents on Windows) and here (for Agents on Linux).
- Log into QuerySurge as a QuerySurge Admin user, and navigate to the Admin view. Steps for using the Connection Extensibility feature can be found here. To use the Connection Extensibility option in the Connection Wizard with the SQL Server driver, you'll need the following information:
Note that you'll need to provide the URL with the proper values for the server host, the port and the database name. (The default SQL Server port is 1433.) When you've entered your information, the Connection Wizard will look similar to this:
Note: You'll need to append
pdw=trueto the URL so that QuerySurge handles your PDW Connection properly. This is a QuerySurge-specific notation.
If you have a Test Query, feel free to enter it to help verify that your Connection parameters are correct. It should be a standard query that returns a small amount of information - one row is enough.
- If you entered a Test Query, you can use the Test Connection button to test whether your Connection is set up properly:
Once your driver is set up, you should be able to write SQL queries against PDW in QuerySurge.