Part 1 Set Up External System for Exports

In part 1, you will configure the external system for the OBI export and upload the exports to the Cloud. To accomplish this, the OXI-HUB Servlet and Datamart interface will need to be updated. These items must be set up for the exports to be successfully uploaded. In addition, the OXI Datamart processor must be installed.

Part 1 of implementing OBI Cloud functionality involves 3 steps:

  1. Updating the OXI-HUB Servlet (Cloud side)
  2. Installing the OXI Datamart Processor
  3. Setting Up the Datamart Interface

Updating the OXI-HUB Servlet

On the Cloud side, the OXI-HUB servlet must be configured to accept the OBI exports. Based on the OPERA Application Server configuration in the Central OBI System, the OXI-HUB servlet (named "Export Receiver") will receive the OBI exports and place the data into a temp table.

Note: The OXI-HUB Servlet update is done on the Cloud side. This update should only be completed if the Cloud is not set up.

  1. Open the OPERA App-Server Configuration screen and select the OXI Servlet Configuration tab.


  2. Under "OXI Servlets," highlight ExportReceiver by clicking on it.
  3. In the "Datasource (Connection)" field, select the down arrow and choose your application server and database from the list of available servers.
  4. Select the Update OXIServlet button.

Installing the OXI Datamart Processor

Note: If not already installed, install the OXI Datamart processor. The Datamart processor will be used to upload the OBI exports.

  1. Open the "OXI_PROCESSOR_SHELL.EXE" executable from your local drive or from a network drive. Select Next.


  2. Choose a destination folder for the processor by selecting the Browse button. Select Next.


  3. Enter a Username and Password for your schema. Select Next.


  4. Choose the "DATAMART" interface from the list of available interfaces. Select Finish.

    Note: Be sure the Run the interface initialization scripts check box option is NOT selected. If this option is selected, the processor will be installed for all properties in the schema.


  5. Select the ellipsis button next to the "Log Directory" field and choose a directory in which to store the processor logs. Select OK.


  6. Select Start to begin the installation.


  7. A dialog will open when the installation is complete. Select OK.


  8. Select Finish to exit.


Setting Up the Datamart Interface

On the client side in OXI, you will set up the Datamart interface to export files from OPERA to external systems.

  1. Go to Setup>System Configuration>Setup>License Codes>OXI and activate the OPERA Xchange Interface for DATAMART license. The license name is OPX_DMART.
  2. In OXI, select the DATAMART interface when you log in.


  3. Select Interface Configuration>Edit Interface to open the Edit Interface Setup screen.


  4. On the Edit Interface Setup screen, select the Export File OPERA->External System check box.
  5. Select Save.

The OXI processor will now pick up the OBI exports and post them to the Cloud.

In PMS, the OBI exports will be sent in the Night Audit Exports process. In ORS, you will need to use OPERA Scheduler to schedule the BI Client - Export Daily Data to BI Cloud job for the export.

Show Me

OBI Cloud Setup Part 1