The project template is pre-tuned for SAP best practices. However, some processes require further configuration before you can run the project. These processes are:
Initial Transformer (optional)
Global Data Router
Country-specific Transformers
Country-specific Window Key Generator (for Fuzzy Search projects only)
Country-specific Transformer Data Reconstruction (optional)
To review or modify the parser input settings
Double-click the Initial Transformer process.
Select the Parser Inputs tab.
Review the input settings and make any desired modifications.
Click Finish.
To tune the Global Data Router
Double-click the Global Data Router process. The Global Data Router editor opens.
-
Click Options. The Define Global Data Router Inputs window opens.
Figure 1. Define Global Data Router Inputs Window
Select the Country attribute from the Input Attributes list and click > to add it to the Global Data Router Inputs list.
-
Click Advanced on the right side of the window. The Advanced Settings window opens.
Figure 2. Global Data Router Advanced Settings Window
If a country code attribute exists in the input, select the name of the attribute from the Country Code Attribute list box.
If a postcode attribute exists in the input, select the name of the attribute from the Postcode Attribute list box. Specifying the postcode attribute helps the Global Data Router identify the country of origin.
When the input has been defined, click Back, and then click Finish.
In the Project View, right-click sap Initial Transformer, and select Apply Schema Changes to update any schema changes.
The Server Action window opens.
Click OK to apply outstanding schema changes.
To tune the country-specific Transformer
Right-click the country-specific Transformer process for the first country in the project.
Select Edit process from the menu.
-
Click Parser Inputs.
The Define Parser Input Address Lines window opens.
Figure 3. Define Parser Input Address Lines Window
Make any country-specific modifications to the address lines window.
For example, the U.S. street address format is house number + street name + street type; it is defined as:
Line 4: Houseno, Streetaddress, AptNo
For Germany, the street address line format is street name + street type + house number; it is defined as:
Line 4: Streetaddress, Houseno, Aptno
Click Finish.
Repeat the procedure for any other country-specific transformers that have unique address line formats.
To tune the country-specific Transformer Data Reconstruction
Right-click the Transformer Address Reconstruction process for the country you are tuning.
Select Edit process from the menu.
Click Output Conditionals.
To tune the country-specific Window Key Generator
Right-click the Window Key Generator process.
Select Edit process from the menu.
Click Advanced.
The Advanced Rules window opens.
Check Fuzzy matching.
When the Fuzzy matching option is enabled, the Window Key Generator behaves as follows:
If any input attribute(s) used to generate a window key is blank, blank out the window key.
If the resulting string of any input attribute(s) is blank, blank out the window key. For example, if street_name is "A" and the window key rule says to build using first three consonants of street_name, then the window key will be blank.
-
Click Finish.
Figure 4. Window Key Generator Edit Process
To run the project
Right-click sap Initial Transformer and select Run.
A prompt alerting you to apply the schema changes appears.
-
Click Yes.
The Execute Process window opens.
Figure 5. Execute Process Window
(Optional) Check the Include dependent processes box if you want to include its dependent processes.
Leave the Use pipes box unchecked.
Click Run.
After the processes have successfully completed, view the results at end of each process.