Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0641

...

  • 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 Databasedatabase, see https://azure.microsoft.com/en-us/services/sql-database/.

Limitations

  • This is a read-only connection. 

Pre-requisites

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

Configure

This connection can also be created using the following property substitutions via API. You must create a connection of SQL Server type. 

...

PropertyDescription
Host
Enter your hostname. Example:

 

Code Block
testsql.database.windows.net
PortSet this value to 1433.
Connect String options

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

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

Tip: If you have access to the Azure SQL 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
  • Azure Token SSO - Use the SSO principal of the user creating the connection to authenticate to the Azure SQL database. Additional configuration is required. See Enable SSO for Azure Relational Connections.
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 .

Configure for SSO

If you have enabled Azure AD SSO integration for the 

D s platform
, you can create SSO connections to Azure relational databases. See Enable SSO for Azure Relational Connections.

Use

For more information, see Database Browser.

Data Conversion

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

...