Tasks

Back Next

Configuring a single object or saved query as the source

You can configure a single object or saved query as the source of a

synchronization

task.

On the

Source

page, select a connection.

To create a connection, click

New

. To edit a connection, click

View

, and in the

View Connection

dialog box, click

Edit

To use a single source, select

Single

To use a saved query, select

Saved Query

You can use a saved query when you use a database connection.

If the connection includes less than 200 objects, select a source object or click

Select

If the connection includes more than 200 objects, click

Select

The

Select Source Object

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

Select an object and click

Select

To display technical names instead of business names, select

Display technical field names instead of labels

This option is not available for all connection types.

To display source fields in alphabetical order, click

Display source fields in alphabetical order

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

For a flat file or FTP/SFTP single source, click

Formatting Options

. Select a delimiter and text qualifier. Optionally, select an escape character.

If you choose Other for the delimiter, the delimiter cannot be an alphanumeric character or a double quotation mark.

If you choose a delimiter for an FTP/SFTP flat file,

Data Integration

applies the delimiter to the local file, not the remote file, when previewing and reading data. If the remote and local files are not synchronized, you might see unexpected results.

If preview data does not display automatically, click

Show Data Preview

to preview data.

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

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