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 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.
To disable credential sharing at the global level:
Locate the following parameter. Set this property to
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:
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:
|Max number of milliseconds to wait for a long-loading data source. The default value is |
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.