General concept # This section describes the concept of ‘Revisable Entity’. This concept can be applied to various SICS domain objects, see following sections.
A revisable entity can have multiple revisions (versions). Revisions are identified, and ordered, by a sequentially assigned revision number. A revision is ‘current’ if and only if it is the newest revision.
Each revision has attributes for ‘comment’ and ‘is current’. There is also typically an audit object attached, with attributes for ‘created by user’, ‘created timestamp’, ’edited by user’, ’edited timestamp’.
...
Logging of SQL Statements # SICS reads and modifies database information using SQL statements via the JDBC standard interface.
For debugging and performance measurement purposes, it may be of interest to review all SQL statements issued by SICS against the database. To do so, one must activate SQL logging.
There are two options available:
Global activation. This is done in the configuration file log4j2.xml (see Log Configuration above) and will affect all users running SICS from this installation location.
...
General concept # Manual/visual comparison of graphical ADH mappings is cumbersome.
The ‘mapping comparison’ feature will list differences between two mappings (two different mappings, or two revisions of the same mapping) for these items:
Output Pattern fields and groups Transformation blocks and their properties Connections Input Pattern fields and groups Output Pattern XSL (XML mappings only) Mapping Detail properties Automatic Corrections Double-clicking any difference belonging to the first 4 categories will highlight that difference in the ‘source’ and ’target’ mapping graphical editor.
...
Configuration # Certain aspects of the SICS Live Desktop part of SICS workstation can be configured in the file /runtime/conf/sics.global.resource.registry.properties, as follows:
# Base URL of the SICS Naming Service, with which this Workstation should register.
# This is one of several requirements for activating SICS Live Desktop. # The format is
# http[s]://<hostname>:<port>/<contextroot>
# The SNS WSDL file will then be available at
# <SicsNamingService>/webservice?wsdl
# and the SNS web service methods (operations) will be available at
# <SicsNamingService>/webservice
#SicsNamingService=http://cscsvrosl023v.
...
Please note that the instructions in this document are based on installing Java and Tomcat in Windows. For installation on Linux distributions please refer to documentation from Sun and Apache, alternatively the package distribution system of the platform.
Nevertheless the instructions given in this document also apply for Linux with the following exceptions/notes.
Make sure to substitute backslashes in paths \ with forward slashes /.
Furthermore it is vital that Tomcat is started up with the Java VM arguments given in section 5.
...
SICS API Server runs as a web application inside a Java Servlet Container (Tomcat, Websphere etc). How to scale SICS API Server capacity depends on the Java Servlet Container and other infrastructure constraints/possibilities. For different alternatives and guidelines on how to set this up, please refer to the Java Servlet Container provider documentation.
For testing purposes, DXC has defined a setup using Tomcat and Apache. The description of this setup is provided below for information purposes, as an example of how Load Balancing can be achieved.
...
Application managed database connection # Complete the following steps to set up application managed connections to the database.
Define and test a database connection in the file sics-database-sources.xml used by SICS workstation. On success, copy the connection entry to file %CATALINA_HOME%/webapps/SicsServer/WEB-INF/classes/sics-database-sources.xml Copy the required JDBC jar(s) into %CATALINA_HOME%/webapps/SicsServer/WEB-INF/lib (similar to the same step for 3.1 “Configure database connection”) Uncomment and specify the following servlet init-parameters in %CATALINA_HOME%/webapps/SicsServer/WEB-INF/web.xml: Parameter Description Required DATABASE The name attribute of the connection specified in %CATALINA_HOME%/webapps/SicsServer/WEB-INF/classes/sics-database-sources.
...
Password Handling in Oracle # When using SICS with an Oracle database the user can change his or her password when logging into SICS, assuming the password is not already expired. This feature can be used in combination with user account settings in Oracle such as password lifetime and password validation. Any error message issued by Oracle during login will be presented to the SICS user. The relevant Oracle error messages are:
...