SAP Connector > Part IV: Data Integration using SAP Table > Synchronization tasks with SAP Table > Configuring a synchronization task with a single SAP object as the source
  

Configuring a synchronization task with a single SAP object as the source

    1. To create a synchronization task, click Data Integration > New > Tasks. Select Synchronization Task and click Create.
    2. 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.
    3. Enter a description for the synchronization task.
    The description can have a maximum length of 255 characters.
    4. Select the task operation that you can perform on the target. Select one of the following options: Insert, Update, Upsert, and Delete.
    5. Click Next to enter the source details.
    1. a. Select an SAP Table connection.
    2. b. Select Singleas the source type.
    3. c. Click Select to specify the SAP source object.
    4. 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:
      You can identify CDS views from the label and type.
    5. d. Click Select.
    6. 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.
    6. To display technical names instead of business names, select Display technical field names instead of labels.
    7. 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.
    8. Click Next to specify the target connection and target objects.
    9. Click Next to specify any data filters or sort criteria.
    Note: Specify the row limit in the Advanced Source Properties section in the Schedule page.
    10. Click New to create a data filter. You can choose to create a simple or advanced data filter.
    11. Click New to configure the sort criteria.
    1. a. Select the source object, sort by field, and the sort direction.
    2. b. Click New to configure additional sort criteria or click Deleteto remove a sort criteria.
    12. Click Next to configure the field mappings. Perform any of the following steps based on your requirements.
    1. a. Click Edit Types in the Source column to edit the precision and scale of the SAP object.
    2. b. Click Add Mapplet to select a mapplet and optionally specify a connection for the mapplet.
    3. c. Click Automatch to match source and target fields with similar names.
    4. d. Click Refresh Fields to update the cache and view the latest field attributes.
    5. e. 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.
    6. f. 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.
    7. g. Click the Add or Edit Expression icon to define a field expression to transform data.
    8. h. 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.
    9. i. Click Validate Mapping to validate all the field mappings.
    10. j. Click Clear Mapping to clear all the field mappings.
    13. Click Next to configure a schedule and advanced options. Perform any of the following steps based on your requirements.
    1. a. Click Run this task on schedule and specify the schedule you want to use.
    2. b. Configure the email notification options.
    3. c. Configure advanced options for the task.
    4. d. Configure the advanced source properties and advanced target properties.
    5. e. Specify the execution mode.
    14. Save the synchronization task. You can choose one of the following save options.