Skip to main content

Azure SQL Database Connections

You can create a connection to a Microsoft Azure SQL Database from Designer Cloud Powered by Trifacta Enterprise Edition. This section describes how to create connections of 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 Database, see https://azure.microsoft.com/en-us/services/sql-database/.

Note

This database connection is a specialized version of a SQL Server connection.

Note

For Azure deployments, some additional configuration properties must be applied. See Configure for Azure .

Supported Versions: Azure SQL Database version 12 (other versions are not supported)

Supported Environments:

Operation

Designer Cloud Powered by Trifacta Enterprise Edition

Amazon

Microsoft Azure

Read

Supported

Not supported

Supported

Write

Supported

Not supported

Supported

Limitations

  • Connections of this type cannot be created via API.

Prerequisites

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

Configure

  • For additional details on creating an Azure SQL Database connection, see Relational Access.

Please create an Azure SQL Database connection and then specify the following properties with the listed values:

Property

Description

Host

Enter your hostname. Example:

testsql.database.windows.net

Port

Set this value to 1433.

Connect String options

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

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

Tip

If you have access to the Azure SQL Database through the Azure SQL Database 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

(forbasicCredential 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 todisabledto prevent Designer Cloud Powered by Trifacta Enterprise Editionfrom applying its own type inference to each column on import. The default value isenabled.

Configure for SSO

If you have enabled Azure AD SSO integration for the Designer Cloud Powered by Trifacta 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.

In this section: