Author: Robert Pound
Links: Enterprise Solutions, Business Intelligence and Appliance Solutions, Boomi Getting Started
This article covers the steps for using Dell Boomi to retrieve US Patent Office data from their Google bulk storage site and storing to a local disk.
This 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
First, set up a Dell Boomi account to start working on this project. You can view a short video that highlights the process of creating a trial account and getting your Dell Boomi environment up and running here Boomi Getting Started: Video1.
Figure 1. Using Dell Boomi as the foundation for this project
A simple process is in place to help you familiarize yourself with Dell Boomi. The project is broken into several small steps. The first step is to download a zip file from the USPTO bulk data site and unzip it before saving to disk. The tasks for the first process are listed below.
There are several methods in Dell Boomi for creating components. Creating the process is the main unit for a Dell Boomi project.
To create a component process:
Figure 2. Creating a process in Dell Boomi.
The Configuration window for the Start connector opens automatically once the process is created. For this first project, the start connecter is an HTTP connector. If you click Cancel, a blank process page appears with the icon below.
Figure 3. Clicking Cancel presents a blank page with this icon.
There are two sub-components when creating HTTP connectors: connections and operations.
Figure 4. Selecting HTTP Client and Get.
Refer to Figure 4 for this procedure.
To create an HTTP connection:
Use Figure 4 for this procedure.
To create an HTTP operation:
To create a disk connector:
Figure 5. Creating a disk connector.
Use Figure 5 for this procedure.
To create a disk connection:
To create a new operation:
Figure 6. The Data Process shape.
Figure 7. Set Properties shape.
To set properties:
You now have all the components, but before you can start running, you need to put it all together.
To complete the process:
Figure 8. Stop shape completes the process.
Figure 9. The process flow is now complete.
Figure 10. The fully expanded project.
To deploy and run the process, view the video Boomi Getting Started: Video2. The service that is actually running the tests is the Atom mentioned in the video Boomi Getting Started: Video1. This means, that for this specific process, if the folder c:\uspto does not exist on the system where the Aton is running, the process fails.