Administrator Guide > Connections > Connection Management
  

Connection Management

You can create, copy, import, remove, and validate source and target connections in Test Data Manager.
You can manage connections in the Administrator | Connections view.
You can import connections from the PowerCenter repository and the domain configuration repository.
Select a connection, and click Actions > Test Connection to validate the connection.
You cannot assign an owner to connections that you create in the Administrator tool. When you import connections created in the Administrator tool, the user name that you enter when you create the Test Data Manager Service displays as the connection owner.
If the owner of the connection is not found in TDM or Workflow Manager, the user name that you enter when you create the Test Data Manager Service displays as the connection owner.

Creating a Connection

You can create a source or target connection in Test Data Manager.
Note: If you reuse the name of a connection previously created and deleted in Test Data Manager, a workflow that you use the connection in might fail. The workflow might fail because a connection object with the same name and different properties exists in the domain repository.
    1. In the Administrator | Connections view, select New Connection from the Actions menu.
    A tab opens to display the new connection properties.
    2. Select the connection type and define the connection name, description, and user information.
    The connection name must begin with an alphabetic character. If you enter a connection name that begins with a numeric character, a workflow that you use the connection in might fail.
    3. Optional. Click Change Owner and select a different user as the connection owner.
    4. Click Next.
    5. Enter the connection properties.
    6. Click Test Connection to test the connection.
    7. Click Finish to save the connection.
    The connection is visible in the Administrator | Connections view.
    8. Optional. Select the connection in the Administrator | Connections view, and click Actions > Test Connection to validate the connection.

Copying a Connection

You can create a copy of a connection. You might make a copy of a connection when you need to define a connection that is similar to an existing connection.
    1. In the Administrator | Connections view, select a connection to copy.
    Do not open the connection.
    2. Click Actions > Duplicate.
    The Duplicate dialog box appears.
    3. Change the name and description for the connection.
    4. Click Save.
    The connection appears in the connections list.

Importing a Connection

You can import a source or target connection in Test Data Manager.
    1. In the Administrator | Connections view, select Import Connections from the Actions menu.
    The available source and target connections are imported into Test Data Manager from PowerCenter.
    2. Go to the Administrator | Connections view to see a list of imported connections.

Editing a Connection

You can edit a connection to modify the connection properties.
    1. In the Administrator | Connections view, click the connection that you want to edit.
    The connection opens in another tab.
    2. Click Actions > Edit.
    3. Modify the connection properties.
    4. Click Test Connection.
    5. Click Save.

Editing Connection Permission

Connection permissions determine the tasks that you can perform using the connection. You can edit the connection permission assigned to users and user groups from the Permissions tab of the connection.
    1. In the Administrator | Connections view, click the connection that you want to edit.
    The connection opens in another tab.
    2. Click the Permissions tab.
    A list of the TDM users or user groups with permissions for the connection appears.
    3. Click Edit on the Users or User Groups tab.
    The Edit Connection Permissions dialog box opens.
    4. To edit the permission of a user or user group, select the user or user group from the list and edit the permission as required. You must save the changes for each user or user group.
    5. To delete a user or user group, select the user or user group from the list and click Delete.
    6. To add a user or a user group:
    1. a. Click Add Users or Add User Groups.
    2. b. Select one or more users or user groups.
    3. c. Optional. From the list of permissions, select the required permissions if either of the following statements is true:
    4. d. Click OK. TDM adds the users or user groups to the list.
    5. e. Select each user or user group and assign the required permission levels. You must save the changes for each user or user group. Skip this step if you performed step c.
    7. Click OK.

Deleting a Connection

You can delete a connection in Test Data Manager. When you delete a connection in Test Data Manager, the connection gets deleted from TDM, but the connection object does not get deleted from the domain repository. Consider editing the connection properties instead of deleting the connection.
    1. In the Administrator | Connections view, select the connection that you want to delete.
    2. Click Actions > Delete.
    3. In the Delete Connection dialog box, click Yes to delete the connection.