Integrating MongoDB with Oracle Database: Creating the Logical Architecture

A logical schema represents the ODI’s interface to the physical schema. In this section we shall create logical schemas for the Oracle technology data server and the Hive technology data server.

  1. Select Topology ➤ Logical Architecture ➤ Technologies ➤ Hive as shown in Figure 12-27.

  1. Right-click on Hive and select New Logical Schema as shown in Figure 12-28.

  1. In Logical Schema Definition specify a Name, MongoDB. In Context the Global context is listed. In Physical Schemas for the Global context select the physical schema for the Hive technology, MongoDB.default, configured earlier as shown in Figure 12-29. Click on Save.

A Hive technology logical schema gets added as shown in Figure 12-30.

  1. Similarly, go to Topology ➤ Logical Architecture ➤ Technologies ➤ Oracle, right-click Oracle, and select New Logical Schema as shown in Figure 12-31.

  1. In the Logical Schema Definition specify a Name, OracleDB. In Context the Global context is listed. Select the physical schema OracleDB.OE configured for the Oracle technology as shown in Figure 12-32.

A logical schema for Oracle technology gets added as shown in Figure 12-33.

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 *