Azure SQL Data Warehouse

ExpandedToggleIcon        Connection Dialog

The following connection options are required for connecting to Azure SQL Data Warehouse:

1.Server - The name or IP address of the Azure SQL Data Warehouse server to which to connect.
2.User - The user name to login with.
3.Password - The password to login with.
4.Database - The name of the database to connect to.


Entering these options is enough for reading data from Azure SQL Data Warehouse and loading data to Azure SQL Data Warehouse using normal Insert, Update, and Delete operations. If you want to use a highly efficient BulkInsert operation to quickly load large volumes of data to Azure SQL Data Warehouse via the PolyBase technique, you also need to switch to the Storage tab of the connection editor and provide parameters to connect to Azure Storage:

1.Storage Account - The Azure Storage account name.
2.Storage Account Key - Your 512-bit storage access key.
3.Storage Endpoints Protocol - determines the protocol to use - HTTPS or HTTP.


In addition to the required options, Advanced connection options may be set for more fine connection tuning.


ExpandedToggleIcon        Advanced Connection Options

The following table describes the options that you can include in the Connection String using the Advanced Connection Editor tab:





Application Name

The name of the application, or '.NET SQLClient Data Provider' if no application name is provided.


The application workload type when connecting to a database.

Asynchronous Processing

When true, enables asynchronous operation support.


The name of the primary database file, including the full path name of an attachable database. The path may be absolute or relative by using the DataDirectory substitution string. If DataDirectory is used, the database file must exist within a subdirectory of the directory pointed to by the substitution string.


The authentication method to use for connecting to SQL Azure Data Warehouse.

Connection Lifetime

The time span in seconds for connection to live.

Connection Reset

Determines whether the connection is reset when taken from the connection pool.

Context Connection

true if an in-process connection to SQL Azure Data Warehouse should be made.

Current Language

The SQL Azure Data Warehouse Language record name.

Data Source

The name or network address of the instance of SQL Azure Data Warehouse to which to connect.

Default Command Timeout

The time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. 0 indicates no limit.


When true, SQL Azure Data Warehouse uses SSL encryption for all data sent between the client and server if the server has a certificate installed. Recognized values are true, false, yes, and no.


true indicates that the SQL Azure Data Warehouse connection pooler automatically enlists the connection in the creation thread's current transaction context.

Failover Partner

The name of the failover partner server where database mirroring is configured.

Initial Catalog

The name of the database.

Integrated Security

When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.

Load Balance Timeout

The minimum time, in seconds, for the connection to live in the connection pool before being destroyed.

Max Pool Size

The maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

The minimum number of connections allowed in the pool. The default value is 0.


When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection. Recognized values are true and false.


When true, an application a connection must attempt connections in parallel for multi-subnet failover or aggressively retry the TCP connection for a subnet failover.

Network Library

The network library used to establish a connection to an instance of SQL Azure Data Warehouse. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmslpcn (Shared Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP). The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.

Packet Size

Size in bytes of the network packets used to communicate with an instance of SQL Azure Data Warehouse. The default value is 8192.


The password for the SQL Azure Data Warehouse account logging on.

Persist Security Info

When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password. Recognized values are true, false, yes, and no.


If true, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.


true if replication is supported using the connection.

Storage Account Key

Your 512-bit storage access key.

Storage Account Name

The Azure Storage account name. Devart SSIS Data Flow Components use PolyBase to ensure fastest data loading to Azure SQL Data Warehouse. The loads data to Azure Blob Storage as CSV files and uses PolyBase to import data from these files to Azure SQL Data Warehouse, and then deletes the CSV files after the import.

Storage Endpoints Protocol

Determines the protocol to use - HTTPS or HTTP.

Transaction Scope Local

If there are several connections with the same connection string (which includes "Transaction Scope Local=true;") within a scope of TransactionScope, our provider will use only one connection internally. The default value is false.


When set to true, SSL is used to encrypt the channel but to bypass walking the certificate chain to validate trust. If the connection string has TrustServerCertificate set to true but Encrypt is not set to true, the channel is not encrypted. Recognized values are true, false, yes, and no. For more information, see "Encryption Hierarchy" and "Using Encryption Without Validation" in SQL Server 2005 Books Online.

Type System Version

A string value that indicates the type system the application expects. Possible values are:

Type System Version=SQL Server 2000;

Type System Version=SQL Server 2005;

Type System Version=Latest;

User ID

The SQL Azure Data Warehouse login account.

User Instance

A value that indicates whether to redirect the connection from the default SQL Server Express instance to a runtime-initiated instance running under the account of the caller.

Validate Connection

Specifies whether to validate connections that are being got from the pool.

Workstation ID

The name of the workstation connecting to SQL Azure Data Warehouse. The default value is the local computer name.