Looking up values in a database

Create a map and use a DatabaseLookup function to get values from a database.

1. In the Hierarchical Mapper, right-click Maps and click New > Map.
2. Select Standard Map and click Next.
3. Select a folder and enter a name for your map, then click Finish.
4. Drag your input and output structures in the map.
5. Map your elements.

   Example

   In this example, you can drag the input order root on the output order to automatically map all the elements present in both structures.

   

6. In the Functions tab, select General > DatabaseLookup and drag it to the Value tab of the country_code element.
7. In the window that opens, select the database column from which you want to retrieve a value, then click OK.

   Example

   

8. Add a condition. If you want to get the country code that matches the country in the input structure, for example, configure it as follows:
   1. Drag an Equal function on the Condition.
   2. Drag the input country element on the First Value.
   3. Drag a DatabaseColumn function on the Second Value.
   4. Select the database column containing the name of the country, NICENAME in this example.

   Example

   

Results

Your map is now configured and you can test it with a sample document using the Test Run option. In this example, the result looks like this: