Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Data transfer tasks
  5. Data loader tasks

Tasks

Tasks

Step 1. Connect to your source

Step 1. Connect to your source

Configure a source connection to connect to your source. Configure the source connection on the
Connect Source
page. You can create a new connection or select an existing connection.
The following image shows the
Connect Source
page:
The Connect Source page shows the selected source connection and source name prefix. Some source types show other fields such as the path. The page also contains an option to load to existing tables or create new tables every time the task runs.
To create a source connection, click
New Connection
. You can also select an existing connection. After you choose the connection, you might have to configure additional connection settings like
Row Limit
and
Use queryAll
that vary based on the connection type.
For more information about connection properties, see
Connections
.
By default,
Data Integration
adds only the source objects you want to include. You can configure this feature using options in the Source Objects field.
For some connection types,
Data Integration
automatically detects primary key fields and watermark fields. Watermark fields identify the records that were added or changed since the last task run.
Click
Next
to customize the target connection.
You can customize the following source options:
  • Which source objects to read
  • The source format (file sources only)
  • Which source fields to exclude
  • Which records to include
  • Primary key fields
  • Watermark fields
For guidelines about customizing the source, see Guidelines for customizing your source.

0 COMMENTS

We’d like to hear from you!