Web Services Provider Guide

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Step 4. Modify the Database Connection Settings

The SQL and Lookup transformations in the imported workflows must be able to connect to the sample lookup tables that you created in Step 1.

The import process does not import the connection object for the transformations in the sample workflows. You must create a connection object and use it in the session.

To update the connection settings for the transformations, complete the following steps:

In the PowerCenter Workflow Manager, create a connection object to connect to the sample tables.

Edit the s_m_CustomerLookup_SINGLEROW session and update the relational connection information in the lkp_Customer transformation.

Set the relational connection to the name of the new connection object. Save the session with the new settings.

Edit the s_m_CustomerLookup_MULTIPLEROW session and update the relational connection information in the sql_Customer transformation.

Set the relational connection to the name of your connection object. Save the session with the new settings.

Rename Saved Search

Table of Contents

Web Services Provider Guide

Web Services Provider Guide

Step 4. Modify the Database Connection Settings

Step 4. Modify the Database Connection Settings