Microsoft SQL Server Connection Details

Provide the information of the Microsoft SQL Server that this connection connects to.

The SQL Server Connector dialog box contains the following fields:
Field	Description
Name	A name for the Microsoft SQL Server connection that you are creating
Description	A short string describing the connection
Host	URL of the server that hosts the Microsoft SQL Server database
Port	Port number on which the Microsoft SQL Server database listens Note: By default, the Microsoft SQL Server Connector cluster is configured with port 1433. For custom configurations the valid port range is 1024 - 32767.
Database Name	Name of the Microsoft SQL Server database
User	User name of the Microsoft SQL Serverdatabase user
Password	Password for the Microsoft SQL Server database account
Maximum Open Connections	Sets the maximum number of open connections to the database. If Maximum Idle Connections is greater than 0 and the Maximum Open Connections is less than the Maximum Idle Connections, then the Maximum Idle Connections is reduced to match the Maximum Open Connections value. Default: 0 (If value is less than or equal to 0, then there is no maximum limit to the number of open connections to the database.)
Maximum Idle Connections	Sets the maximum number of connections in the idle connection pool. If Maximum Open Connections is greater than 0, but less than the Maximum Idle Connections, then the Maximum Idle Connections is reduced to match the Maximum Open Connections value. Default: 2 If value is less than or equal to 0, then no idle connections are retained.
Maximum Connection Lifetime	Sets the maximum amount of time for which a connection can be reused. Expired connections are closed before reuse. Default: 0 (If value is less than or equal to 0, then connection can be used forever.) Valid time units: ns, us (or µs), ms, s, m, h. Example: 60s, 60m, 6h45m.
Maximum Connection Retry Attempts	Maximum number of attempts the Microsoft SQL Server connector tries to connect to a database server in case of connection failure. Default: 3 seconds
Connection Retry Delay	The time interval between the connection retry attempts. Default: 5 seconds
On-Premise Database	Enables the activities of a Flogo Database connector to be routed to your on-premise database through the TIBCO Cloud™ Integration - Hybrid Agent. For more information, see the TIBCO Cloud Integration documentation.
Secure Connection	True: Establishes the secure connection by providing public key certificate when set to True. CA Certificate: Certificate Authority (CA) certificate. Validate Server Certificate: Verifies CA Certificate and the server host name to ensure that it matches the Common Name in the server certificate.

Note:

Maximum Open Connections must be less than the limit on the number of connections imposed by your database and infrastructure.
Higher Maximum Open Connections and Maximum Idle Connections values can lead to better performance. However, having a large idle connection pool (with connections that are not reused) can lead to reduced performance.
To mitigate the risk mentioned in the preceding point, set a relatively short Maximum Connection Lifetime. However, it must not be so short that leads to connections being ended and re-created unnecessarily often.