Connection Management

Configure connection pooling.

Configure connection pooling to optimize processing for the Data Integration Service. Connection pooling is a framework to cache connections.

View connection properties.

View the connection properties through the Connections view on the Manage tab.

Edit the connection.

You can change the connection name and the description. You can also edit connection details such as the user name, password, and connection strings. When you update a database connection that has connection pooling disabled, all updates take effect immediately.

The Data Integration Service identifies connections by the connection ID instead of the connection name. When you rename a connection, the Developer tool and the Analyst tool update the jobs that use the connection.

Deployed applications and parameter files identify a connection by name, not by connection ID. Therefore, when you rename a connection, you must redeploy all applications that use the connection. You must also update all parameter files that use the connection parameter.

Delete the connection.

When you delete a connection, objects that use the connection are no longer valid. If you accidentally delete a connection, you can re-create it by creating another connection with the same connection ID as the deleted connection.

Refresh the connections list.

You can refresh the connections list to see the latest list of connections for the domain. Refresh the connections list after a user adds, deletes, or renames a connection in the Developer tool or the Analyst tool.

Creating a Connection

1. In the Administrator tool, click the Manage tab.
2. Click the Connections view.
3. In the Navigator, select the domain.
4. In the Navigator, click Actions > New > Connection.
The New Connection dialog box appears.
5. In the New Connection dialog box, select the connection type, and then click OK.
The New Connection wizard appears.
6. Enter the connection properties.
The connection properties that you enter depend on the connection type. Click Next to go to the next page of the New Connection wizard.
7. When you finish entering connection properties, you can click Test Connection to test the connection.
8. Click Finish.

Refreshing the Connections List

1. In the Administrator tool, click the Manage tab.
2. Click the Connections view.
The Navigator shows all connections in the domain.
3. In the Navigator, select the domain.
4. Click Actions > Refresh.

Viewing a Connection

1. In the Administrator tool, click the Manage tab.
2. Click the Connections view.
The Navigator shows all connections in the domain.
3. In the Navigator, select the domain.
The contents panel shows all connections for the domain.
4. To filter the connections that appear in the contents panel, enter filter criteria and click the Filter button.
The contents panel shows the connections that meet the filter criteria.
5. To remove the filter criteria, click the Reset Filters button.
The contents panel shows all connections in the domain.
6. To sort the connections, click in the header for the column by which you want to sort the connections.
By default, connections are sorted by name.
7. To add or remove columns from the contents panel, right-click a column header.
If you have Read permission on the connection, you can view the data in the Created By column. Otherwise, this column is empty.
8. To view the connection details, select a connection in the Navigator.
The contents panel shows the connection details.

Configuring Pooling for a Connection

1. In the Administrator tool, click the Manage tab.
2. Click the Connections view.
3. In the Domain Navigator, select a connection.
The contents panel shows the connection properties.
4. In the contents panel, click the Pooling view.
5. In the Pooling Properties area, click Edit.
The Edit Pooling Properties dialog box appears.
6. Edit the pooling properties and click OK.

Editing and Testing a Connection

1. In the Administrator tool, click the Manage tab.
2. Click the Connections view.
The Navigator shows all connections in the domain.
3. In the Navigator, select a connection.
The contents panel shows properties for the connection.
4. In the contents panel, select the Properties view or the Pooling view.
5. To edit properties in a section, click Edit.
Edit the properties and click OK.
Note: If you change a connection name, you must redeploy all applications that use the connection. You must also update all parameter files that use the connection parameter.
6. To test a database connection, select the connection in the Navigator.
Click Actions > Test Connection on the Manage tab.
Note: The Test Connection button tests the connection string of the metadata access properties and not the data access properties.
A message box displays the result of the test.

Deleting a Connection

1. In the Administrator tool, click the Manage tab.
2. Click the Connections view.
The Navigator shows all connections in the domain.
3. In the Navigator, select a connection.
4. In the Navigator, click Actions > Delete.