Create SQL DB Connections

...

Property Description

Host

Enter your hostname. Example:

Code Block
testsql.database.windows.net

Port Set this value to 1433.

Connect String options

Include any options required for your environmentPlease 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 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.

User Name Username to use to connect to the database.

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

...

Versions Compared