Using User Attributes for Connection Parameters

User attributes can be used for the connection parameters in a connection definition. Attributes can be defined for the full connection string, the host name, the port number, the cluster name, the user name, or the password, and any other parameters supported by the connector. The attributes are passed to the connection string via custom attributes specified in the user definition or dynamically in the custom attributes specified in the SAML or LDAP configurations for your Composer installation. This topic describes how to set up this functionality.

You can also insert variables directly in the connection parameters of a connection definition. See Inserting Variables for Connection Parameters.

Step 1: Review and Select Connector Parameters for Which Attributes Can Be Used

To review and select connector parameters for which user attributes can be used:

  1. Log into Composer as a supervisor.

  2. Select Connectors on the supervisor menu (). The Manage Connector Services page appears.

  3. In the Connectors section of the page, select the connector whose parameters you want to review. Alternatively, you can create a new connector definition and review and modify the parameters in the new definition. See Defining a New Connector.

    Either the Edit Connector or the Create New Connector page for the connector appears.

  4. Review the connector parameters that appear at the bottom of the Edit Connector or Create New Connector page.

  5. If you want to be able to select a custom attribute as the value for a connection parameter, make sure the User Attribute checkbox is selected.

  6. Alter the other connector parameters, as needed.

    • If a connector parameter is required, make sure its Required checkbox is selected. Depending on the connector server, some parameters are already selected because they are required.
    • If a connector parameter should be visible (especially if the parameter is required) when the connection definition is created, make sure its Visible checkbox is selected.

    For information about all connector parameters, see Defining a New Connector.

  7. Select to save the connector parameters.

Step 2: Define Custom Attributes

A custom attribute must be defined for every connector parameter for which you selected the User Attribute checkbox in Step 1. The only exceptions are the Composer context variables ${User.composerUserName} and ${User.accountId}, which automatically exist and can be used to insert the name or account ID of the user that is currently logged in.

You can define custom attributes in several ways:

Step 3: Define Connections Using User Attributes

To define connections using user attributes:

  1. Log into Composer as an administrator.

  2. Create or edit a connection using the connector you updated in Step 1. See Adding Data Store Connections and Modifying Data Store Connections.

  3. If a connection parameter is identified as a user attribute, up and down arrows appear in the connection parameter box on the Connections page. Use these arrows to select the custom attribute you want to use for the connection.

    When custom attributes are referenced in connection definitions they take the form User.<custom-attribute-name>.

  4. Select to validate the connection. If the connection is valid, it is saved.