You can create connections to one or more Microsoft SQL Server databases from .
If you plan to create an SSO connection of this type, additional configuration may be required. See Enable SSO for Relational Connections.
To create this connection:
For additional details on creating a SQL Server connection, see Enable Relational Connections.
This connection can also be created using the API.
Property | Description | |
---|---|---|
Host | Enter your hostname. Example:
| |
Port | Set this value to 1433 . | |
Connect String options | Please insert the following as a single string (no line breaks):
where:
| |
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 | |
Test Connection | After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials. | |
Connection Name | Display name of the connection | |
Connection Description | Description of the connection, which appears in the application. |
For more information, see Database Browser.
For more information on how values are converted during input and output with this database, see SQL Server Data Type Conversions.