MRI Software Connector > Mappings and mapping tasks with MRI Software Connector > MRI Software mapping example
  

MRI Software mapping example

You want to read data from MRI Software and write data to a flat file.
Perform the following steps to create a mapping:
  1. 1. Select Data Integration from the menu.
  2. The Data Integration Home page appears.
  3. 2. To create a mapping, click New and then in the New Asset dialog box, click Mapping.
  4. 3. Click Create.
  5. The Mapping Designer appears with a new mapping displayed in the mapping canvas.
  6. 4. In the Properties panel, enter the mapping name and select the location you want the mapping to reside in, or use the default location.
  7. 5. On the mapping canvas, click the Source transformation.
    1. a. In the Properties panel, click General and enter a name for the Source transformation.
    2. b. Click Source and select an MRI Software connection to read MRI Software objects.
    3. c. Select Single Object as the Source Type.
    4. d. Select the MRI Software object for which you want to read the data.
    5. e. Under Query Options, configure the filter fields for the MRI Software objects.
    6. Note: The filter is mandatory for certain MRI Software objects. For more information, see Filtering records from MRI Software sources.
    7. f. To save the mapping and continue, click Save.
  8. 6. On the mapping canvas, click the Target transformation.
    1. a. In the Properties panel, click General and enter a name for the Source transformation.
    2. b. Click Target and select a flat file connection to write data to a flat file.
    3. c. Select Single Object as the Target Type.
    4. d. Select the flat file as the target object.
    5. e. Select Insert as the Operation.
    6. Note: You can perform only the insert operation
    7. f. In the Field Mapping tab, map the incoming fields to the target fields. You can manually map an incoming field to a target field or automatically map fields based on the field names.
  9. 7. Save and run the mapping.
  10. After you validate the mapping, you can use the mapping to create a mapping task.