iCEDQ Pre Installation Checklist

Server Environment Setup

Below is the list of pre-requisites for installation of iCEDQ software.

Components

Comments

CPU(s)

1 CPU or 8 cores (minimum)
(Highest GHz is recommended)

Disk Space

Installation folder – 20 GB
Log Files – 100 GB
Exception Data Files – 500 GB or above

*** Input Files (Optional) – 100 GB or above

The log files/ exception data files & input files folders can be on the same server or on a shared drive. NAS server is recommended for high data volume deployments.

Operating Systems

The following, 64-bit operating systems are supported:

  • Windows
  • RHEL/CentOS
  • Oracle Linux
  • Ubuntu

Memory

16 GB (minimum)

Java

Java JDK 1.8 64-bit

Service User Account

Install and run the application under a service account. The service account should have local admin privileges on the server.
Note:

  • On Linux, the service account needs SUDO rights to start and stop the service.
  • On Windows, a user with local admin privileges needs to deploy the software.

Firewall Ports

  • 80, 8300, 8301 (Client – Server)
  • 5601 (Between load balanced servers)

Shared Drive
(Load Balancing)

iCEDQ writes the exception data and job run log files on a disk (attached storage). For Highly Available iCEDQ deployments, use a shared drive as attached storage so that all the servers in the cluster write logs in one location.

Note: For better performance, ensure all the servers in the cluster and shared drive is in the same datacenter.

Linux Only Dependencies

For Highly Available iCEDQ deployments, install below utilities on the server for mounting drives and installing the load balancer service.

  • nfs-utils & nfs-utils-lib
  • gcc
  • openssl-devel
  • apr-devel & apr-utildevel

System Email ID

iCEDQ sends alerts and notifications according to user configurations. Use a pre-existing email ID or create a new one for system alerts.

Database Schema Setup - iCEDQ Repository

Below is the list of databases that iCEDQ supports for repository purposes. Clients can use anyone option.

Components

Comments

SQL Server DB

The iCEDQ application stores all its metadata and results in a database repository. As part of installation it creates tables, views, procedures, sequences, and other database objects. Create a SQL Server, or Windows authenticated user with database owner privilege and non-expiring password.

2-5 GB

PostgreSQL DB

Create an PostgreSQL schema with a non-expiring password for creating and maintaining all iCEDQ database objects.

2-5 GB

Oracle Schema

Create an Oracle schema with a non-expiring password for creating and maintaining all iCEDQ database objects.

2-5 GB

Client Environment Setup

Below is the list of software that should be already installed on the user machine.

Components

Comments

Browser

Users access iCEDQ through a web browser. Below are the different browsers we support

  • Chrome (Recommended)
  • Microsoft Edge (Chromium based)