Open topic with navigation

Changing A Target Connection

If you change a target connection to a connection whose data objects match those of the original target connection, all links are preserved. References, such as rejected rows and key cross references, are updated to the new target connection.

Note: If you change a target connection to a connection whose data objects do not match those of the original target connection, all links to the original target connection are removed. You are prompted to change connection references in the DTS, such as rejected rows or the key cross-reference, from the original target connection to the new target connection.

  1. In the Workbench, click Configure Steps. The Configure Steps dialog box appears.
  2. Click the Data Objects tab.
  3. Do one of the following to change a target connection:

    Modify Target ConnectionDescription

    Add an existing connection as a target

    1. Click the Add button. The Add Target Connection dialog box appears.
    2. From the Connection drop-down menu, select a target connection.

    Modify settings of a connection

    1. Select the connection you want to modify.
    2. Click the Edit button. The Connection Settings dialog box appears.
    3. Modify the connection settings as needed. See Modifying Connection Settings.

      Changes you make to the connection options only affect the target connection as it is used in the current DTS.

    Modify the target connection you use

    1. Select the connection you want to modify.
    2. Click the Change button. The Resolve Connection dialog box appears.
    3. Do one of the following:
      • Save the current connection as a new connection:
        1. Select the Create a new connection option.
        2. In Connection Name, enter a unique name for the connection.
      • Select an existing connection:
        1.  Select the Use an existing connection option.
        2. If you want to see all connections, even those whose parameters do not match the parameters of the current connection, clear the Show only connection with matching parameters check box.
        3. Select the existing connection you want to use.
    4. Click OK. The new connection appears in the Data Objects tree.

    Define a new connection

    1. Click the New button. The Add A Connection dialog box appears.
    2. Define one of the following, based on how TIBCO Scribe® Insight is configured at your site:

  4. Select the connection you want to add as a target, and expand each branch to see the available sources.
  5. In Operation, select the operation to use for the selected target.
  6. Click Add Operation Step, where Operation is the operation you selected.
  7. Click Close.

See also

Adding A Connection

Configure Steps tabs

Configuring Target Steps

Connecting To An ODBC Source

Resolving field and table differences in the target

Using The Text Wizard

 

TIBCO Scribe® Insight Help Library