Configuring a synchronization task with a single SAP object as the source
Configuring a synchronization task with a single SAP object as the source
To create a synchronization task, click
Data Integration
New
Tasks
. Select
Synchronization Task
and click
Create
.
Enter a name for the
synchronization
task.
The names of
synchronization
tasks must be unique within the organization.
Synchronization
task names can contain alphanumeric characters, spaces, and the following special characters:_ . + -
Synchronization
task names are not case sensitive.
Enter a description for the
synchronization
task.
The description can have a maximum length of 255 characters.
Select the task operation that you can perform on the target. Select one of the following options: Insert, Update, Upsert, and Delete.
Click
Next
to enter the source details.
Select an SAP Table connection.
Select
Single
as the source type.
Click
Select
to specify the SAP source object.
The
Select Source Object
dialog box appears. The dialog box displays up to 200 objects. If the objects you want to use do not appear, enter a search string to search based on name and description.
The following image displays the CDS views that you can select:
Click
Select
.
The Data Preview area displays the first 10 rows of the first five columns in the SAP object and the total number of columns in the object. To preview all source columns in a file, click
Preview All Columns
.
To display technical names instead of business names, select
Display technical field names instead of labels
.
To display source fields in alphabetic order, click
Display source fields in alphabetical order
.
By default, fields appear in the order returned by the source system.
Click
Next
to specify the target connection and target objects.
Click
Next
to specify any data filters or sort criteria.
Specify the row limit in the
Advanced Source Properties
section in the
Schedule
page.
Click
New
to create a data filter. You can choose to create a simple or advanced data filter.
To create a simple data filter, select a source object, source field, and operator. Enter the value you want to use and click
OK
.
To create an advanced data filter, click
Advanced
. Select a source object and enter the field expression you want to use and click
OK
.
You can use parameters defined in a parameter file in the data filters. When you use a parameter in a data filter, start the data filter with the parameter.
Click
New
to configure the sort criteria.
Select the source object, sort by field, and the sort direction.
Click
New
to configure additional sort criteria or click
Delete
to remove a sort criteria.
Click
Next
to configure the field mappings. Perform any of the following steps based on your requirements.
Click
Edit Types
in the Source column to edit the precision and scale of the SAP object.
Click
Add Mapplet
to select a mapplet and optionally specify a connection for the mapplet.
Click
Automatch
to match source and target fields with similar names.
Click
Refresh Fields
to update the cache and view the latest field attributes.
Click
Edit Types
in the Target column to edit the data type, precision, and scale of the target object. Note that this option is not available for all target types.
Select a source field and drag it to the target field to map the source and target fields. Repeat for all the fields that you want to map.
Click the
Add or Edit Expression
icon to define a field expression to transform data.
Click the
Add or Edit Lookup
icon to create a lookup. Specify the lookup connection, object, source and lookup fields, output field, multiplicity, and lookup expression.
Click
Validate Mapping
to validate all the field mappings.
Click
Clear Mapping
to clear all the field mappings.
Click
Next
to configure a schedule and advanced options. Perform any of the following steps based on your requirements.
Click
Run this task on schedule
and specify the schedule you want to use.
Configure the email notification options.
Configure advanced options for the task.
Configure the advanced source properties and advanced target properties.
Specify the execution mode.
Save the
synchronization
task. You can choose one of the following save options.
Click
Save and Close
to save the task and close the
synchronization
task.
Click
Save and Continue
to save the task and continue with configuring the
ASK INFAPreview
