Data Integration Hub

Overview

This document outlines the requirements and steps for performing a native installation of the RIA Data Integration Hub (DIH).

DIH consists of a web application with an embedded Tomcat container and a standalone Java runtime server.  Except for the prerequisites listed below, no additional 3rd party downloads or installations should be required.

A single sign-on provider is also included in the tools/sso subdirectory. This provider can be configured and started if integration with a 3rd party identity provider is required.

System Requirements

Before installing DIH, you must have the following:

Linux

DIH is a Java application and can run on any version of Linux where Java 8 or higher is supported. Shell scripts are provided for Linux.

  • Webserver 512M Java heap
  • SSO server 512 Java heap (optional)
  • Runtime server 1024MB Java heap
  • Hardware requirements
    • Disk 80MB
    • 8 CPUs
    • 64GB memory storage
    • 20GB disk space

Java

Java 8 or higher is required.

Oracle database

The tool requires Oracle and needs a database schema for its database objects.

For an OUAF application conversion, such as ORMB, the staging schema, typically called STGADM, should already exist and can also be used as the DIH schema. The STGADM schema serves as a repository for conversions, facilitating staged conversions.

For any other scenario, such as integration, reconciliation, archiving, or ORMB upgrades, a new schema is typically created. The suggested name for this schema is DIHADM, but it can be named anything.

DIH tables, views, and packages are created in this schema.

Package files

The ria-dih-<version>.zip file contains all the software and scripts for the installation and setup. A few important files are described below.

sql/create-dih-tables.sql

This SQL script creates the tables, views, and DBMS Scheduler objects required by DIH.  The DIH’s table and view names are prefixed by UA_.  The DBMS Scheduler Program, which is used to submit tasks, is also created by this script.

sql/RIA_DIH.sql

This is the script to create the PL/SQL package required by the tool.

tools/dl

A utility called DataLoader is included to facilitate the installation of initial configuration data.  For details on DataLoader, refer to the readme.txt file in this directory, as well as the help documentation in the’ help’ subdirectory.  Open the index.html file from a browser to view the help.

If the DIH Archive Console is to be installed or activated, its configuration is also loaded using DataLoader.

Install DIH

You can install DIH in two ways:

  1. By using the DIH installer script.
  2. Through manual installation.