2.6 Using the Resources Navigator

The resources navigator, or the global resource library lists all the available resources such as:

Big Data System: All the available Big Data Systems.
Database: All the available databases.
Global Mapping Group: Global mapping groups can be assigned to any replication path of any solution across all projects. Mapping groups created for a solution in the Projects Navigator can be copied to the global mapping groups or created directly from the Resources Navigator.
Oracle GoldenGate Instance: The available Oracle GoldenGate instances.

The Resources Navigator looks like:

Figure 2-3 Resources Navigator

There are three ways to add a new global resource. If any type of resource is not added then you can add it by selecting the New button in the Resources Navigator toolbar, select the New button in the Oracle GoldenGate Studio toolbar, or select New under File menu, and then select the resource type you want to add. If a resource type has already been added, you right-click the resource category and select New Resource Type. You can also add a Global Mapping Group by right-clicking a mapping group in the Projects Navigator and selecting Copy to Global Resource Library.

Figure 2-4 Adding New Resources through Resources Navigator

You can change the properties of existing resources by using the Properties context menu. You can also use the keyboard shortcut Ctrl+Tab to navigate to Resources Navigator, use the Tab and arrow keys to select the particular resource, and use Shift + F10 to view the context menu.

2.6.1 Add a New Database Connection

New database connections are used only for table metadata to facilitate table mapping and are not used to define connections used by capture and apply processes. Capture and apply connections are defined in the Properties Inspector in the Deployment Profile.

A new database connection wizard looks as follows:

Figure 2-5 New Database Connection

Select the Database resource type in the Resources Navigator window and right-click to select New Database Connection.
In the New Data Server Connection window, add the following:
1. Connection Name: The name of the new connection. The resource is listed in the Resources Navigator with the name mentioned here.
2. Connection Type: Connection types are Oracle (JDBC), Generic JDBC, MySQL, SQLServer, DB2 UDB, and Teradata. Changing of database type is not supported after connection is created.
3. The User name and Password to connect to the database. If you uncheck Save Password check box during connection creation and if you want to expand the Database node after re-connecting to repository, Database node expansion will ask you to enter the password to show all the nodes under database connection.
4. The role as SYSDBA or SYSOPER. This can be left blank when the user is not SYS. Else, you have to select the role.
5. The JDBC settings.
  
  By default, Oracle GoldenGate Studio provides drivers for Oracle, MySql, SQLServer, Informix, Sybase and DB2 UDB. Additional database drivers that are not provided with the product can be configured by using Tools menu, then Preferences , Database, and JDBC Driver Options. Once a data server connection is created, you can browse objects under the database in the Resources Navigator and the information from the database navigator can be used for viewing the metadata and mapping.
  
  To add the Teradata connection, you have to load the Teradata drivers as follows:
  1. In the New Data Server Connection window, select Teradata as the connection type.
  2. Click the select Library button.
  3. In the Select Library window, click the New... button.
  4. In the Create Library window that opens, click on Add Entry... button.
  5. In the Select Path Entry window that opens, browse to the location where the Teradata drivers are stored and select the drivers. Click the Open button.
  6. Click OK if the drivers are correctly added under Class path.
  7. In the Select Library window, you can see the newly added Teradata drivers. Click OK.
  8. Provide a valid Username and Password and click Test Connection to perform a connection test or OK to proceed with the connection.
  Figure 2-6 The Select Library Dialog
Click OK to create a new Database resource.

You can also test the connection using Test Connection button before creating the new resource.

Note:

Teradata is supported as a target only database but you can drag-and-drop Teradata tables as a source database in the mapping editor. This is possible as mapping is a logical concept and no check is performed by Oracle GoldenGate Studio.

Note:

The generate to function for Teradata and DB2 UDB tables depend on JDeveloper functionality. DB2 UDB to DB2 UDB and Teradata to Teradata are not supported.

2.6.2 Add a New Big Data System Connection

A new Big Data system can only be used as a target. Properties for the connection can be defined in the Properties Inspector in the Deployment Profile.

A new Big Data system connection wizard looks as follows:

Figure 2-7 New Big Data System Connection

Select the Big Data System resource type in the Resources Navigator window and right-click to select New Big Data System Connection.
In the New Data Server Connection window, add the following:
1. Name: The name of the new connection. The resource is listed in the Resources Navigator with the name mentioned here.
2. Description: A short description about the new Big Data System.
Click OK to create a new Big Data System resource.

2.6.3 Add a New Global Mapping Group

The New Global Mapping Group wizard defines a container for table mappings but does not guide you through the table mapping process. To learn more about defining table mapping see Understanding Mapping Groups

A new Global Mapping Group wizard looks as follows:

Figure 2-8 New Global Mapping Group

To add a new Global Mapping Group:

Click the New button on the Resources Navigator window or right click on the database icon and select New Global Mapping Group Connection.
Enter the name of the new connection.
Enter a short description to identify the resource.
Click OK.

2.6.4 Add a New Oracle GoldenGate Instance

The Add a New Oracle GoldenGate Instance dialog defines a connection to an existing GoldenGate installation. That installation must already have the GoldenGate manager and jAgent processes running

A new Oracle GoldenGate Instance dialog looks as follows:

Figure 2-9 New Oracle GoldenGate Instance Connection

To add a new Oracle GoldenGate Connection:

Click the New button on the Resources Navigator window or right click on the database icon and select New Oracle GoldenGate Instance Connection.
Under General section enter the name and description for the new connection.
Under Host Information enter Host Name. It is the DNS name of the server where Oracle GoldenGate is installed.
Under Oracle GoldenGate Information enter the following:
- GoldenGate Version: You can also select the version from the drop down list while working offline. If there is an active connection and incorrect version is entered, the correct information is updated to overwrite the incorrect version when the Test Connection to GoldenGate button is placed.
- GoldenGate Database Type: The database type for which the connection is created. It gets automatically updated when Test Connection to GoldenGate is clicked. You can also select the version from the drop down list while working offline.
- GoldenGate Port: The port number for the Oracle GoldenGate manager process.
- Agent Username: The JAgent name as specified by the jAgent.username property in the config.properties file of the jAgent at the time of installation.
- Agent Password: The password for the corresponding username.
- Agent Port: The jAgent port as specified by the jagent.jmx.port property in the config.properties file of the jAgent. If the agent mode is OEM, then you have to use jagent.rmi.port, if the agent mode is OGGMON then you have to use jagent.jmx.port.
Click Test Connection to GoldenGate to verify if the connection is working. The version and database type is automatically updated on successful connection.