Integrating MongoDB with Oracle Database: Running the Interface

In this section we shall run the integration interface to integrate the data from MongoDB to Oracle Database.

  1. Right-click on the integration interface node and select Execute as shown in Figure 12-74.

  1. In Execution select OK as shown in Figure 12-75.

3. A Session started dialog gets displayed. Click on OK as shown in Figure 12-76.

Three MapReduce jobs run to integrate Hive table data into Oracle Database as shown in Figure 12-77.

4. Select the Operator tab. Select the session from the Session List. The different phases of the integration are listed, including creating staging tables and launching Oracle Loader for Hadoop as shown in Figure 12-78

After data has been integrated staging tables, Oracle Directory, ext tab dir, local data files, local temp files, and HDFS data files get deleted as shown in Figure 12-79.

One of the advantages of using Oracle Data Integrator over using Oracle Loader for Hadoop on the command line is that the integration gets suspended, without getting terminated, if some configured parameter is not found. For example, if the target database table OE.WLSLOG is not found the integration gets suspended, as in the Create Hive staging table phase as shown in Figure 12-80.

5. The session is still running and gets completed if the configuration parameter is fixed, for example, add a missing schema for a database table. Alternatively the integration session may be stopped. Right-click on the session and select one of the Stop options to terminate the session as shown in Figure 12-81.

Source: Vohra Deepak (2015), Pro MongoDB™ Development, Apress; 1st ed. edition.

Leave a Reply

Your email address will not be published. Required fields are marked *