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

...

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.
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
;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
Credential Type

Options:

  • basic - (default) You provide the username and password to use as part of the connection definition.

  • Kerberos delegate - Connection uses the Kerberos-delegated principal to connect to the database. No credentials are submitted as part of the connection definition. This method requires additional configuration. See Enable SSO for Relational Connections.

User Name(basic credential type only) Username to use to connect to the database.
Password(basic credential type only) 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.

Test ConnectionAfter you have defined the connection credentials type, credentials, and connection string, you can validate those credentials.
Connection NameDisplay name of the connection
Connection DescriptionDescription of the connection, which appears in the application.

...