Create SQL DB Connections

...

You can create a connection to a Microsoft Azure SQL database from the

D s platform

. This section describes how to create connections to Microsoft SQL DBof this type.

This connection type supports data ingestion into ADLS/WASB. When large volumes of data are read from an Azure SQL database during job execution, the data is stored in a temporary location in ADLS/WASB. After the job has been executed, the data is removed from the datastore. This process is transparent to the user.
For more information on Azure SQL DBDatabase, see https://azure.microsoft.com/en-us/services/sql-database/.

...

For additional details on creating a SQL DB connection, see Enable Relational Connections.
For details on values to use when creating via API, see Connection Types.

This connection is a SQL Server connection type with special settings for some properties. Please create a an Azure SQL Server connection Database connection and then modify specify the following properties with the listed values:

Property Description

Host

Enter your hostname. Example:

Code Block
testsql.database.windows.net

Port Set this value to 1433.

Connect String options

Please insert the following as a single string (no line breaks):

Code Block

;database=<DATABASE_NAME>

;encrypt=true;trustServerCertificate=false;
hostNameInCertificate=*.database.windows.net;loginTimeout=30;

where:

<DATABASE_NAME> is the name of the SQL DB database to which you are connecting

Tip
Tip: If you have access to the Azure SQL

DB

database through the Azure Portal, please copy the Connect String from that configuration. You may omit the username and password from that version of the string.

Database

(optional) Name of the Azure SQL database to which you are connecting.

User Name (for basic Credential Type) Username to use to connect to the database.

Password (for basic Credential Type) Password associated with the above username.

Credential Type

basic - Specify username and password as part of the connection

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 .

Use

For more information, see Database Browser.

...

For more information on how values are converted during input and output with this database, see see SQL Server Data Type Conversions.

Page tree

Versions Compared

Old Version 1

New Version 2

Key

Use