Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »



You can create a connection to a Microsoft Azure SQL database from the Trifacta platform. This section describes how to create connections to Microsoft SQL DB.


  • 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 DB, see


  • This is a read-only connection. 


  • 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 .


To create this connection:

For additional details on creating a SQL DB connection, see Enable Relational Connections.

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

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

Enter your hostname. Example:
PortSet this value to 1433.
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 Trifacta platform from applying its own type inference to each column on import. The default value is enabled.


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.


  • No labels

This page has no comments.