Integrating MongoDB with Oracle Database: Creating the Physical Architecture

The physical architecture consists of the data servers and the physical schemas. In this section we shall add data servers and physical schemas for MongoDB and Oracle Database. The physical and logical architecture for MongoDB is based on the Hive technology.

  1. Select Topology ➤ Physical Architecture ➤ Technologies ➤ Hive in ODI Studio as shown in Figure 12-3.

2. To create a new data server for MongoDB via the Hive table right-click on Hive and select New Data Server as shown in Figure 12-4.

  1. In Data Server Definition specify a Name (MongoDB) as shown in Figure 12-5. The Technology is preselected as Hive.


4. Select the Flexfields tab as shown in Figure 12-6. Deselect the Default checkbox and specify the Value for the Hive Metastore URIs as thrift://localhost:10000.

5. Select the JDBC tab and select the JDBC Driver as the HiveDriver and specify the JDBC Url as jdbc:hive://localhost:10000/default. Click on Test Connection to test the JDBC connection as shown in Figure 12-7.

6. A Confirmation dialog indicates “Your data will be saved before testing connection. Do you want to continue?” as shown in Figure 12-8. Click on OK.

7. An Information dialog prompts to register at least one physical schema for the Data Server as shown in Figure 12-9. Click on OK.

 

  1. In Test Connection click on Test as shown in Figure 12-10.

  1. A “Successful connection” message indicates that a connection gets established as shown in Figure 12-11. Click on OK.

10. Click on Save. A data server for MongoDB based on the Hive technology gets added as shown in Figure 12-12.

  1. Next, add a Physical Schema to the data server. Right-click on the MongoDB data server node and select New Physical Schema as shown in Figure 12-13.

  1. In the Physical Schema Definition the Name is prespecified as MongoDB.default. Specify Schema (Schema) and Schema (Work Schema) as default as shown in Figure 12-14. Click on Save.

A Physical Schema gets added to the data server as shown in Figure 12-15.

  1. The target datastore is an Oracle Database table. To create a data server for Oracle Database, right-click on Topology ➤ Physical Architecture ➤ Technologies ➤ Oracle and select New Data Server as shown in Figure 12-16.

  1. In Data Server Definition specify a data server Name. The Technology is preselected as Oracle. Specify Instance as ORCL as shown in Figure 12-17. Specify User and Password.

  1. Select the JDBC tab. Select the JDBC Driver as oracle.jdbc.OracleDriver and specify JDBC Url as jdbc:oracle:thin:@127.0.0.1:1521:ORCL. Click on Test Connection to test the JDBC connection as shown in Figure 12-18.

  1. An Information dialog prompts to register at least one physical schema for the data server as shown in Figure 12-19. Click on OK.

  1. In Test Connection click on Test as shown in Figure 12-20.

18. A Successful Connection message indicates that a connection has been established as shown in Figure 12-21. Click on OK.

An Oracle technology data server gets added as shown in Figure 12-22.

  1. To register a physical schema with the data server, right-click on the data server node and select New Physical Schema as shown in Figure 12-23.

  1. In Physical Schema Definition the Name is prespecified. Specify Schema (Schema) and Schema (Work Schema) as the User used to connect to Oracle Database, which is OE for the data server OracleDB configured earlier as shown in Figure 12-24. Click on Save.

21. An Information dialog prompts to specify a context for the schema as shown in Figure 12-25. Click on OK.

A physical schema gets added to the data server as shown in Figure 12-26.

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 *