An integration project is required for integrating data from a source datastore to a target datastore. Next we shall create an integration project, add an integration interface, and run the integration interface.
- Select Designer ➤ Projects and select New Project to create a new project as shown in Figure 12-56.
- In the Project Definition specify a Name and click on Save as shown in Figure 12-57.
An integration project gets added to Projects as shown in Figure 12-58.
We shall be using the File-Hive to Oracle integration knowledge module for integrating the Hive table data to Oracle Database. We need to add the IKM File-Hive to Oracle knowledge module to the project.
3. Right-click on Knowledge Modules ➤ Integration and select Import Knowledge Modules as shown in Figure 12-59.
4. Select the IKM File-Hive to Oracle knowledge module in Import Knowledge Modules as shown in Figure 12-60. With IKM File-Hive to Oracle knowledge, module source could be a file or Hive and its target is Oracle Database. Click on OK.
5. Click on Close in the Import Report. The IKM File-Hive to Oracle knowledge module gets added to the Integration Knowledge Modules as shown in Figure 12-61.
Source: Vohra Deepak (2015), Pro MongoDB™ Development, Apress; 1st ed. edition.