For successful installation of OpsHub Integration Manager, you must fulfil certain prerequisites related to software, hardware or Virtual Machine (VM), and database on which OpsHub Integration Manager will be installed.

Software Prerequisites

Supported Operating System
Supported Operating System
Windows
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows Server 2012
  • Windows Server 2008 R2 (64 bit)
Supported Operating System
Linux
  • RHEL 5.2 + (64 bit)

RHEL includes Cent OS and Fedora


Hardware Prerequisites

These hardware pre-requisites are exclusively for OpsHub Integration Manager.

  • OpsHub Integration Manager RAM – 8 GB & above
  • OpsHub Integration Manager Disk space – 50 GB
  • OpsHub Integration Manager Database Disk Space – 15 GB
  • Cores – Quadcore (Recommended)

Database Prerequisites

OpsHub Integration Manager can be deployed with an in-built database; however, for production deployment or anything other than functional testing, our experts highly recommend using an external database. OpsHub Integration Manager supports the following database.

It is an in-built Java database. Port 9011 needs to be opened for this database.

  • Supported versions: 5.1.47 to 5.7.20
  • Wait time for connection pool should be set to 8 hours
  • User permission pre-requisites list:

    Privileges Context Installation Up-gradation Running
    Alter Tables Yes Yes
    Alter Routine Stored routines Yes Yes
    Create Databases, tables, or indexes Yes Yes
    Create routine Stored routines Yes Yes
    Create tablespace Server administration Yes Yes
    Create temporary tables Tables Yes Yes
    Create view Views Yes Yes
    Delete Tables Yes Yes Yes
    Drop Databases, tables, or views Yes Yes
    Execute Stored routines Yes Yes Yes
    File File access on server host Yes Yes
    Grant option Databases, tables, or stored routines Yes Yes
    Index Tables Yes Yes
    Insert Tables or columns Yes Yes Yes
    Lock tables Databases Yes Yes Yes
    References Databases or tables Yes Yes
    Select Tables or columns Yes Yes Yes
    Show view Views Yes Yes Yes
    Update Tables or columns Yes Yes Yes
    Note: Once the installation/up-gradation is complete for normal running of OpsHub Integration Manager, rest of the permissions mentioned in the table above can be revoked.

  • Supported versions: 11g (Release 2) and 12c
  • User permission pre-requisites list:

1. System Privileges

Privilege Installation Up-gradation Running OpsHub Integration Manager
CREATE SESSION Yes Yes Yes
CREATE ANY PROCEDURE or CREATE PROCEDURE Yes Yes
CREATE ANY VIEW or CREATE VIEW Yes Yes
QUERY REWRITE Yes Yes Yes
GLOBAL QUERY REWRITE Yes Yes Yes
ALTER ANY TABLE Yes Yes
DROP ANY TABLE Yes Yes
DROP ANY VIEW Yes Yes
ALTER ANY PROCEDURE Yes Yes
DROP ANY PROCEDURE Yes Yes
CREATE ANY DIRECTORY Yes Yes

2. Object Privileges

Privileges Context Installation Up-gradation Running
ALTER Table Yes Yes
DELETE Table and View Yes Yes Yes
INDEX Table and View Yes Yes
INSERT Table and View Yes Yes Yes
REFERENCES Table and View Yes Yes
SELECT Table and view Yes Yes Yes
UPDATE Table and View Yes Yes Yes
Execute Procedure Yes Yes Yes

Note: Once the installation/up-gradation is complete for normal running of OpsHub Integration Manager, rest of the permissions mentioned in the table above can be revoked.

  • Supported versions: 2005 or above
  • Enable Client protocols TCP/IP and Named pipes on MSSQLSERVER instance.
  • User permission pre-requisites:

Db Operation Privilege Installation Up-gradation Running OpsHub Integration Manager
Create Database/Schema Create Database, Create Schema Yes
Update Database/Schema Alter Database, Alter Schema or Alter Yes Yes Yes
Create Table CREATE TABLE Yes Yes
Select in Table SELECT Yes Yes Yes
Insert in Table INSERT Yes Yes Yes
Update Table Data UPDATE Yes Yes Yes
Delete Table Data DELETE Yes Yes Yes
Alter Table ALTER Yes Yes Yes
Drop Table ALTER Yes Yes
Create View CREATE VIEW Yes Yes
Read View SELECT Yes Yes Yes
Alter View ALTER Yes Yes
Drop View ALTER Yes Yes
Create References REFERENCES Yes Yes
Update References REFERENCES Yes Yes
Drop References REFERENCES Yes Yes
Create Procedure CREATE PROCEDURE Yes Yes
Update/Alter Procedure ALTER Yes Yes
Execute Procedure EXECUTE Yes Yes Yes
Drop Procedure ALTER Yes Yes
Note: Once the installation/up-gradation is complete for normal running of OpsHub Integration Manager, rest of the permissions mentioned in the table above can be revoked.

Important Point: If the default connection timeout parameter is changed for any database server, then it must be confirmed that sufficient connection timeout has been set. For example, for MySQL, the default server-side connection timeout is 8 hours. If it is changed and set to another time duration, then the default server-side connection time out also needs to change accordingly.

OpsHub Integration Manager maintains connection pools that keep the connection alive for 8 hours. Based on the need, this parameter can be tuned at the application and database-server level. The recommended timeout is between 6-8 hours.

Host Name for OpsHub Integration Manager

If machine\instance where OpsHub Integration Manager deployed is binded with any host name (Net, Host, Gateway, or Domain name) then please make sure the host name (Net, Host, Gateway, or Domain name) is a text string up to 24 characters drawn from the alphabet (A-Z), digits (0-9), minus sign (-), and period (.). Note that periods are only allowed when they serve to delimit components of “domain style names”. For more details, read the memo RFC-921 and RFC-952.

Port Prerequisites

Available Ports

Port 8989 should be available for HTTP access and Port 8443 should be available for HTTPS access.

For successful installation/up-gradation of OpsHub Integration Manager, following ports must be available as per the chosen configuration and database.

  • HTTP Port 8989: If you are installing OpsHub Integration Manager with HTTP.
  • HTTP Port 8443: If you are installing OpsHub Integration Manager with HTTPS.
  • Database Port 9001: If you are installing OpsHub Integration Manager with HSQL database.
Note: Apart from the above ports, some systems require certain ports to be available. Please refer to the specific systems section to know about the requisite ports.