Configuring a Data Synchronization Task with a Single SAP BW Object as the Source

1. Click Task Wizards > Data Synchronization.
The Data Synchronization Tasks page appears.
2. Click New.
The Data Synchronization Task Wizard appears.
3. Enter a name for the Data Synchronization task.
The names of Data Synchronization tasks must be unique within the organization. Data Synchronization task names are not case sensitive. Data Synchronization task names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
4. Enter a description for the Data Synchronization task.
The description can have a maximum length of 255 characters.
5. Select the task operation that you can perform on the target.
You can select one of the following options:
• - Insert
• - Update
• - Upsert
• - Delete
6. Click Next to enter the source details.
1. a. Select an SAP BW Reader connection from the list or click New to create a new SAP BW Reader connection.
2. b. Select an SAP BW source object from the list or click Select to search for an SAP BW source object.
The Select Source Object dialog box appears. The dialog box displays up to 200 objects. If the objects that you want to use do not appear, enter a search string to search for the object based on its name, label, description, or type, and then click Search.
3. c. Select the SAP BW source object from which you want to read data, and then click Select.
The Data Preview area displays the first 10 rows of the first five columns in the SAP BW object, and the total number of columns in the object. To preview all source columns in a file, click Preview All Columns.
4. d. To display technical names instead of business names, select the Display technical field names instead of labels option.
5. e. To display source fields in alphabetic order, select the Display source fields in alphabetical order option.
By default, fields appear in the order returned by the source system.
7. Click Next to specify the target connection and target objects.
8. Click Next to specify the data filter criteria.
1. a. Click New to create a data filter. You can specify a simple data filter based on key characteristics.
Note: You cannot create an advanced data filter. You cannot specify a simple data filter based on key figures.
2. b. Select the source object, key characteristic source field, and operator.
You can select one of the following operators for the filter condition:
• ▪ Equals
• ▪ Not Equals
• ▪ Less Than
• ▪ Less Than or Equals
• ▪ Greater Than
• ▪ Greater Than or Equals
3. c. Enter the value based on which you want to filter the data and click OK.
9. 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 BW object.
2. b. Click Automatch to match source and target fields with similar names.
3. c. Click Refresh Fields to update the cache and view the latest field attributes.
4. d. 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.
5. e. 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.
6. f. Click the Add or Edit Expression icon to define a field expression to transform data.
7. g. Click Validate Mapping to validate all the field mappings.
8. h. Click Clear Mapping to clear all the field mappings.
10. 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 that you want to use. Alternatively, you can click Do not run this task on a schedule to run the task manually.
2. b. Configure the email notification options.
3. c. Configure a parameter file, if needed.
4. d. Configure the advanced source properties.
5. e. Specify the execution mode.
11. Save the Data Synchronization task. You can choose one of the following save options:
• - Click Save and Close to save and close the task.
• - Click Save and Continue to save the task and continue with configuring the task.
• - Click Save and Run to save and run the task immediately.