Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This section describes how to create connections to Microsoft SQL Datawarehouse (DW).

Tip

Tip: This connection is now known as Azure Synapse Analytics.

Limitations

  • Microsoft SQL DW connections are available only if you have deployed the
    D s platform
    onto Azure.
  • No data validation is performed during publication SSL connections to SQL DW . Your job fails if the schema for the 

    D s item
    itemdataset
     varies from the target schema.are required.

    Info

    NOTE: In this release, this connection cannot be created through the CLI or APIs. Please create connections of this type through the application.

  • SSL connections to SQL DW are required.

Pre-requisites

  • If you haven't done so already, you must create and deploy an encryption key file for the
    D s item
    itemnode
    to be shared by all relational connections. For more information, see Create Encryption Key File.

...

  • Read-Only connection: The authenticating DB user must have read permissions to any SQL DW databases, schemas and tables to which the user should have access.
  • Read-Write connection: In addition to the above, the authenticating DB user must have the following permissions:

    Code Block
    CREATE TABLE**
    ALTER ANY SCHEMA
    ALTER ANY EXTERNAL DATA SOURCE
    ALTER ANY EXTERNAL FILE FORMAT
     


    • The authenticating DB user must also have read access to the external data source.

...

When specifying a SQL DW Read-Write connection, you must 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. 

Info

NOTE: This setting is not used for SQL DW Read-Only connections.

The External Data Source enables publishing and support for large-scale data ingestion. If the External Data Source is not provided, the connection is Read-Only and does not scale well:

  • The connection is read-only.
  • The native ingestion of the 
    D s platform
     is used.

Requirements:

...

PropertyDescription
Host
Enter your hostname. Example:

 

Code Block
testsql.database.windows.net


PortSet this value to 1433.
DatabaseSet this value to the default database name.
External Data Source NameFor 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 NameUsername to use to connect to the database.
PasswordPassword associated with the above username.
Default Column Data Type Inference

Set to disabled to prevent the

D s platform
from applying its own type inference to each column on import. The default value is enabled.

...