SICS 21.2
SE-1277 # SICS now offically supports MySQL compatible databases. SE-6251 # IBM DB2 was removed as a supported platform. All DB2 related libraries & JDBC drivers were also removed from the delivered software.
v21.2
Introduction
This document describes how to install and configure SICS API Server. SICS API Server can run on 64-bit versions of Windows and Linux. The instructions are based on installation on machines running Microsoft Windows 64 bit. There is also a section on installing SICS API Server on Linux. Main steps Install SICS software products Set up database Test database using GUI-based SICS Configure SICS Install a Java Servlet Container Deploy SICS API Server to the Java Servlet Container Configure the SICS API Server environment Verify correct startup of SICS API Server Steps 1 to 4 are not described in this document and may vary if you are using P&C or Life. ...
Database Preparation for Microsoft SQL Server
This section describes the necessary database preparation that must be completed before any of the SICS software can be executed. Your DBA will be responsible for correctly configuring and creating the SICS database. Database setup # Before any of the SICS tables can be created, you will need to create the files necessary for the storage of the database using the DBMS tools. This will generally involve creating the instance, specifying where the tablespace files will be stored, creating and configuring the database for your specific requirements. ...
Installation
Installation of SICS DOCS # Installation on a static web-server # Examples of compatible static web-servers: Apache HTTPD server (open-source) Nginx (open-source) Microsoft IIS Example: The web-server publishing root folder is pre-configured as /var/www/html (hereafter referred to as <publishing_root>). (For further instructions, please refer to the official documentation from your web-server vendor.) Step 1. Unzip # Unzip the ZIP version of the SICS DOCS archives you want to install into a sub-folder of your own choice, under the publishing root folder of your web-server. ...
SICS Database Maintenance Launcher
Introduction # SICS SysAdmin Utility is shipped with a command-line utility for maintenance work on SICS databases. Being a command-line utility means it is a headless application, well suited for automation. The command-line utility is implemented as a Java program which is launched from a class named com.csc.sics.launcher.DatabaseMaintenanceLauncherMain. The SICS Database Maintenance Launcher has the following capabilites: Create a new SICS database Update an existing SICS database to a higher version Create SICS reporting tables and views Create SICS reporting stored procedures and functions Usage # Bootstrapping # In order to execute the SICS Database Maintenance Launcher, a few JAR’s from the lib folder of the SICS SysAdmin Utility must be added to the Java class-path. ...
Accounting Order Monitor
Accounting Order Monitor # To make it easier to manage a high number of accounting orders in the monthly closing process, there is an option to create templates. The template holds general information which makes the regular recurring creation of the scheduled jobs easier. Accounting orders must first be flagged as ‘Batch Templates’ to activate the possibility to use them as templates for scheduled jobs. The Job Template is created by selecting ‘Request Scheduled Job Templates’ from the pop-up menu. ...