Author: Robert Pound
Links: Enterprise Solutions, Business Intelligence and Appliance Solutions, Boomi Getting Started
This episode covers mapping an XML file to a comma-separated value (CSV) in Dell Boomi. It builds on information covered in the previous episodes.
The Dell Business Intelligence Project Using USPTO Data project uses Dell Boomi, Dell Quickstart Data Warehouse Appliance and Toad products to analyze publicly available data. For more information about the goal and scope of the project, as well as a breakdown of the episodes, go to: episode 1.
In the last project, we downloaded and extracted a zip file from an HTTP connection. Building on this set of tools, we can test the mapping function in Dell Boomi. Then we use this mapping to extract useful XML data. Lastly, we can save it to a CSV file. The steps for this episode are outlined here:
Many of the required components are similar to the components in the First Project. We start by copying that process.
To copy components:
Figure 1. Copy your previous work in Component Explorer.
Figure 2. Clear the Copy component dependents? check box.
If the process First project ran successfully, then find the file c:\uspto\test.xml. This file is stored on the system where the process was run. This file contains over 4000 patent XML files, but for this episode you only need a single patent.
To separate out the top patent file:
Next, modify the process to reuse the components created in the previous project.
To modify components:
Figure 3. Click Configure when it appears.
Figure 4. Edit the label on parameter to test.csv.
Create the two profiles that Dell Boomi uses to interpret the data: one for XML and one for CSV. Once these files are created, create a map component to link the fields in the XML to the fields in the CSV file.
To create the XML profile:
To create the CSV profile:
Figure 5. Create these elements.
Figure 6. Map shape.
Figure 7. Drag and drop, then save and close.
Once you save and deploy your process, you can find the test.csv file in your local directory. For directions on how to deploy a process, refer to the blog Boomi Getting Started.
Figure 8. Contents of the test.csv file.