Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Step 2. Configure the source

Step 2. Configure the source

To configure a source, select a connection on the
Source
page. You can edit a connection that you select. Alternatively, you can create another connection.
  1. On the
    Source
    page, select a connection from the list of connections.
    The source must have a primary key.
  2. Optional. Choose to edit the connection or create another connection.
    • To edit a connection, select the connection and click
      View
      . In the
      View Connection
      dialog box, click
      Edit
      and edit the connection details in the
      Edit Connection
      dialog box. Test the connection to verify that the connection is valid.
    • To create another connection, click
      New
      . In the
      New Connection
      dialog box, enter the connection information. Test the connection to verify that the connection is valid.
  3. Choose a single source object or multiple source objects.
    • To select a single object from the list, click
      Single
      . Select a single source object from the list. You can preview the source object details in the
      Data Preview
      section.
    • To select many objects, click
      Multiple
      .
    A list of source objects appears.
    Objects that you cannot update do not appear in the list of source objects. For example, you cannot update objects of type
    isSfIdLookup()
    ,
    isCreateable()
    ,
    isupdateable()
    , or
    isreferenced()
    . You cannot update objects with cyclic relationships. For example, you cannot update the User, Profile, Community, and Idea objects.
  4. If you choose multiple source objects, perform the following steps:
    1. Click
      Add
      .
      The
      Select Source Object
      dialog box appears with a list of objects.
    2. Select a source object and click
      Select
      .
    3. Select the added object and click
      Add
      .
      The
      Select Related Objects
      dialog box appears.
    4. Select the related child, parent, or self-reference objects that you want to include in the source objects. The objects move to the list of selected objects.
    5. To add the related objects, click
      Select
      .
      You can view and download the schema graph in the DOT format to view the relationships between the related objects.
  5. Click
    Next
    .
    The
    Target
    page opens.

0 COMMENTS

We’d like to hear from you!