You can apply the following features to relational connections to ensure compliance with enterprise practices.
Connection Security Level | Description | |
---|---|---|
Private | Private connections are created by individuals and are by default accessible only to the individual who created them. | |
Private and shared | Optionally, they can be shared by individuals with other users.
| |
Global | Global connections are either created by administrators or are private connections promoted to global by administrators. |
By default, users are permitted to share credentials through the application. Credentials can be shared in the following ways:
As needed, credential sharing can be disabled.
NOTE: If enterprise policy is to disable the sharing of credentials, collaborators may need to be permitted to store their source data in shared locations. |
Tip: Credential sharing can be disabled by individual users when they share a connection. The connection is shared, but the new user must provide new credentials to use the connection. |
Steps:
To disable credential sharing at the global level:
Locate the following parameter. Set this property to false
:
"webapp.enableCredentialSharing": true, |
The following features enhance the security of individual and global relational connections.
Relational database passwords are encrypted using key files:
This encryption key file must be created and installed on the . For more information, see Create Encryption Key File.
You can enable SSL by adding the following string to the Connect String Opts field:
?ssl=true; |
Tip: Some connection windows have a Use SSL checkbox, which also works. |
For long loading relational sources, a timeout is applied to limit the permitted load time. As needed, you can modify this limit to account for larger load times.
Locate and edit the following parameter:
"webapp.connectivity.longLoadTimeoutMillis": 120000, |
Property | Description |
---|---|
longLoadTimeoutMillis | Max number of milliseconds to wait for a long-loading data source. The default value is 120000 (2 minutes). |
For additional relational configuration settings, see Configure Data Service.
Relational connections can be configured to leverage your enterprise Single Sign-On (SSO) infrastructure for authentication. Additional configuration is required. For more information, see Enable SSO for Relational Connections.