Tasks

Back Next

Configuring multiple database tables as the source

You can configure multiple database tables as the source of a

synchronization

task.

On the

Source

page, select a database connection.

To create a connection, click

New

. To edit a connection, click

View

and then click

Edit

Select

Multiple

The Source Objects table displays.

Click

Add

In the

Select Source Objects

dialog box, select the objects you want to use.

The dialog box displays up to 200 objects. If the objects that you want to use do not display, enter a search string to reduce the number of objects that display.

When you select an object, it appears in the Selected Objects list. To remove an object from the Selected Objects list, press

Delete

Click

Select

The selected sources display in the

Source Objects

table. To remove a source, in the

Actions

column, click

Remove

To display source fields in alphabetical order, select

Display source fields in alphabetical order

By default, source fields appear in the order returned by the source system.

Create source relationships or create a user-defined join, and click

To create a relationship, perform the following steps:

Select a database table and click

Create Relationship

Select the source key for the table and then select the related source object and matching object key.

Click

Match the primary key of the source table to the corresponding foreign key of the related database table.

Create relationships as necessary to include all sources in the task.

To create a user-defined join to join all database tables, perform the following steps:

Select

User Defined Join

and define the join.

Any existing relationships are added to the join condition. To ensure that you enter field names correctly, use the

Object

list and

Fields

list to add field names to the join statement.

To save the user-defined join, click

To preview source data, select the source in the Source Objects table. If preview data does not appear automatically, click

Show Data Preview

The Data Preview area shows the first ten rows of the first five columns in the source. It also displays the total number of columns in the source.

The Data Preview area does not display certain Unicode characters as expected. If the data contains binary data, the Data Preview area shows the following text: