This section describes how to create connections to Microsoft SQL Datawarehouse (DW).
Tip: This connection is now known as Azure Synapse Analytics.
SSL connections to SQL DW are required.
NOTE: In this release, this connection cannot be created through the APIs. Please create connections of this type through the application.
The supports two types of connections to an Azure SQL DW data warehouse:
|SQL DW Read-Only|
Read-only access to the SQL DW data warehouse. This connection is available on the Import Data page only.
To create, see Import Data Page.
This connection requires fewer permissions on the data warehouse and its databases but is less performant.
|SQL DW Read-Write|
Read-write access to the SQL DW data warehouse. This connection is available for reading, direct publishing, and ad-hoc publishing.
To create, see Connections Page.
This connection requires more permissions. You must also specify an External Datasource Name. See below.
Read-Write connection: In addition to the above, the authenticating DB user must have the following permissions:
CREATE TABLE** ALTER ANY SCHEMA ALTER ANY EXTERNAL DATA SOURCE ALTER ANY EXTERNAL FILE FORMAT
When specifying a SQL DW Read-Write connection, you can provide an External Data Source Name value as part of the connection definition. The External Data Source enables publishing and support for large-scale data ingestion.
NOTE: This setting is not used for SQL DW Read-Only connections.
If the External Data Source is not provided:
To create this connection:
Please create a connection of this type in the appropriate page and modify the following properties with the listed values:
Enter your hostname. Example:
|Port||Set this value to |
|Database||Set this value to the default database name.|
|External Data Source Name||For read-write connections, you must provide an External Data Source. Otherwise, the connection is read-only. See above for details.|
|Connect String options|
Include any options required for your environment:
|User Name||Username to use to connect to the database.|
|Password||Password associated with the above username.|
|Default Column Data Type Inference|
If you have enabled Azure AD SSO integration for the , you can create SSO connections to Azure relational databases.
NOTE: When Azure AD SSO is enabled, write operations to SQL Datawarehouse are not supported.
See Enable SSO for Azure Relational Connections.
For more information on locating data, see Database Browser.
For more information, see Using SQL DW.
For more information on how values are converted during input and output with this database, see SQL DW Data Type Conversions.