The SNS, SNS Administration webpage and SUS is packaged as a single JEE application. The SNS is based on JAX-WS, the METRO web services stack, and JPA for persistency. The SNS Administration webpage and the SUS is based on JSP, Servlets and Javascript. The SNS, SNS Admin webpage and SUS is delivered as a war file to be installed in your JEE application server. 4 war files are delivered: War file Description sns. ...
Figure 44 Reference items - Translation tables Translate blocks are used to convert message values in to SICS values - and require mapping tables to hold both sides of the mapping. These mapping tables are maintained using the translation table function in Reference items. There are two parts to the transformation table - the table definition, and the table contents. First, we consider the definition of the table. Define new table # Figure 45 Translation tables - Define new table ...
Command Line Parameters # SICS Command Line Parameters # NOTE: This information does not apply to SICS API Server. Please see separate installation documentation for SICS API Server. This appendix describes the command line parameters that can be specified in the shortcut that starts the SICS system. SICS command lines follow this template with 6 elements: <Path to JRE><JRE arguments><Main class><Target type><Product><SICS application command line arguments> Element Description <Path to JRE> Path to the Java runtime. ...
Registration # Upon startup (after login), the SICS Workstation will find an available TCP/IP port and start listening for incoming Web Service calls on this port. Then, it will register itself with SNS, providing the user’s login name (first level user in case of two-level login), database name, database schema and the user’s OS name. SNS will assign and reply a token, which SICS will remember. Note: If the user is logged in as the table owner (empty schema), then the registration will be done using an empty string for database schema, not Java null / database NULL. ...
The two data values "" (empty string) and null (data missing / not present) are considered different, not equal. The source and target systems should be of the same SICS product type. Comparison of a pure P&C system with a Life or combined system may cause the Configuration Manager to report differences that, although the CM will allow it, should NOT be copied from one system to the other. Generating SQL for category 4 means creating DELETE statements. ...
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. ...