Using the Generate Data Mapper Process Component Wizard

With Aptify, many application process flows require mapping data from queries to objects, queries to property collections or property collections to objects. To map data from one area of the system to another without having to get values individually, Aptify includes the Generate Data Mapper Process Component Wizard that a developer can use to create process components that map data from a source to a destination reducing the amount of code a developer needs to write. Follow the steps below to use the Generate Data Mapper Process Component Wizard to generate process components that map data within Aptify.

1. Go to the Process Components service.
2. Launch the Aptify Generate Data Mapper Process Component Wizard from the Process Components entity browser toolbar or the toolbar of a view run from the service.
3. Select one of the following options:
   • New: Generates a new Data Mapper process component.
   • Update: Updates an existing Data Mapper process component.
   • Clone: If you want to copy an existing Data Mapper process component and then modified as needed, select the Clone option.
     
     
4. If you select the Update or Clone options, select the Data Mapper process component you want to update or clone from the Select Process Component drop-down menu.
   • The name of the selected process component is automatically populated in the Name field
     
     
     
     
5. If you selected the New option, enter a Name for the new Data Mapper process component.
6. If you selected the Update or Clone option, you can modify the name as desired.

Generate Data Mapper Process Component Wizard New Option

1. Select Next.
2. Select the New Map button on the Object Map tab to define the object that will be used in the data mapping.
3. Enter the Name for the source/destination object to be mapped.
4. Select a Source Type, the available source types are:

• NEW GE OBJECT: Indicates that a new GE Object will be loaded. In this instance, Source Details will include the entity name, and optionally, in parenthesis, the ID of the record to load. If the record ID is not provided, a new record is created.
• PROPERTY(GE): Indicates that the source of the object is a generic entity object (normally from a process flow or event handler).
• PROPERTIES: Indicates that the source of the object is the properties/context object from the process flow other than a generic entity object. If the source is a generic entity object, use the Property (GE) source type.
• SQL STATEMENT: Indicates the object will be a Data Table object that contains the results of the SQL query specified and the fields available from this object will be the set of fields from the SQL query.

1. Enter Source Details. The information that goes in this field is determined by the value chosen in the Source Type field.

• Source Type = New GE Object: Enter the name of the entity from which you want to map, and optionally, in parenthesis, the ID of the record to load. If the record ID is not provided, a new record is created.
• Source Type = Property(GE): Enter the name of the existing generic entity object (from a process flow or event handler) which you want to map.
• Source Type = Properties: Enter the name of the input property that you want to provide as an input to the process component or the name of context object if you want to use the property as an output for the process component.
• Source Type = SQL Statement: Enter the SQL statement that extracts the required information (set of fields) to use in the data mapping. Note that only the first row of the SQL query will be considered. Use a SELECT query that returns only one row.

1. Enter any Comments for the Object Map.

Object Map Tab

1. Add additional object maps as necessary.
2. Select the Data Map tab and select the New Map button to define the data mapping steps that correspond to the objects defined on the Object Map tab. Note that the steps are executed in the order in which they appear on the tab.
3. Enter the Source Object (name of object from Object Map tab).
4. Enter the Source Attribute. The information that goes in this field is determined by the Source Type of the object chosen in the Source Object field.

• Source Type = New GE Object of Property(GE): A drop-down list is made available with all fields from the GE Object. Select an appropriate field for the desired results of the mapping.
• Source Type = Properties: Enter the name of the object from the Object Map tab.
• Source Type = SQL Statement: Enter the name of the field that is returned from the SQL query.

1. Enter the Destination Object.
2. Enter the Destination Attribute.
3. Enter any Comments for the Data Map.

Data Map Tab
You can view the generated process component by selecting the newly created record from the Process Components service.
Process Component Generated From the Wizard