Introduction

Introduction

Welcome to this SICS version! #

This document describes the steps that must be followed in order to install SICS in your environment.

On a high level, the installation procedure involves three main activities:

  1. SICS Software Installation This involves installing the SICS software (including documentation and various other system files), and Business Objects Reporting Universes after downloading from the SICS software delivery site. The installation of the SICS reporting tool (Business Objects) itself, is covered in a different document.
  2. Database preparation These are the activities your Database Administrator must complete (as a minimum) in order to prepare the target Database Management System for SICS.
  3. Create SICS Database Tables This involves creating the SICS database tables, and loading the tables with required base data.

Installing a combined SICS P&C and SICS Life database
Clients running SICS P&C and Life on a combined database schema must use the Life System Administration Utility to create the database tables. This database can then be used to hold data for both P&C and Life. If the database tables are set up using the P&C System Administration Utility, it will not be possible to later convert this database into a combined P&C and Life database.

Using the “Segregate Data by Access Code” functionality
Please refer to the System Administrator’s Guide - chapter Access Code Usage. If you intend to use this functionality, you must read the chapter carefully and carry out the necessary preparation steps, before allowing users to enter data into the system.

It is highly recommended that you study and familiarize yourself with this document before you attempt to install SICS.

Quick Installation and Configuration Guide #

For each SICS database you will be creating, you will need to work through the following steps. Please refer to the appropriate section for details of each step.

  • Install and configure the DBMS on the server.
  • Create the instance and database skeleton for the SICS database.
  • Install the SICS System Administration Utility on the client.
  • Configure the client to access the database through JDBC.
  • Create the environment table.
  • Input all initial users of the system into file Sysusers.txt
  • Create the owner of the SICS tables and grant select privileges on the environment.
  • Create the SICS tables and views using the System Administration Utility. If you are installing a combined P&C and Life database, you must use the Life System Administration Utility. Please refer elsewhere in this document for more details.
  • Create the SICS database Role or Group.
  • Grant appropriate Access Rights to each user.
  • Install the SICS workstation on required client machines and check the JDBC connection.

Hardware and Software Requirements #

Information about hardware requirements, operating systems, databases and JDBC drivers, can be found in document Hardware and Software Requirements.