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.
- Select Topology ➤ Logical Architecture ➤ Technologies ➤ Hive as shown in Figure 12-27.
- Right-click on Hive and select New Logical Schema as shown in Figure 12-28.
- 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.
- Similarly, go to Topology ➤ Logical Architecture ➤ Technologies ➤ Oracle, right-click Oracle, and select New Logical Schema as shown in Figure 12-31.
- 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.