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: ...
Significant changes to SICS Docs # 25.1 # Added XSD browsing to SOAP API catalog Refined source code metrics 24.4 # Moved SOAP API catalog out of the release notes to its own section. Added API examples. 23.3 # Added details comments to SOAP API catalog 23.2 # Added basic SOAP API catalog 21.2 # Added Auto Test Code Coverage, Source Code metrics 21.1 # Added Release notes, What’s New, API auto-test results, CVE scan reports ...
Tabular input data format # ADH can support the generation of a suitable Input Pattern for handling tabular data in an XML input file/document, but only if the input format is as described here. Assume the original document contains a table like this: Q1 Q2 Q3 Q4 Premium 100 100 110 120 Commission 20 25 To be processed as a table in ADH, it must be represented in the XML input file as a <table> element with “number”, “numRows” and “numCols” attributes, and having the following three groups of child elements: ...
Public Web Services # These are the Web Service Endpoints published by SICS Workstation. These services are intended to be called by an external application. All parameters are mandatory unless otherwise indicated. All services will return immediately after processing the request (opening the requested screen). Response: The response data structure consists of 1 field: a textual message. If the request is valid (the correct token is provided, see security below), then the response will consist of an empty message. ...
Password Encryption # The database connection password may be encrypted. In the SICS installation folder, there is a file named encrypt.bat. This bat file takes a plain-text string (the password) as input, calls a SICS utility program and outputs an encrypted version of the string. This encrypted value will always be prefixed with % so as to later recognize it as an encrypted value. The encrypted password can be provided in the command line password field and/or the ini file settings password field, see above. ...
To reuse transformation blocks in various mapping(s), you can use the Export/Import blocks actions located in the the context/popup menu in ADH Edit/View Mapping Window. Export Blocks # This action helps in extracting the selected blocks and connection details to a XML file from source mapping. In the Edit/View Mapping Window, for Validation and Transformation rule. After selecting the required blocks, on opening the context menu, we can see the Export Blocks Action ...
An external application that wants to utilize SICS Live Desktop (SLD) functionality, must be able to communicate with SICS Naming Service and SICS Workstation via Web Service requests according to the WSDL files published by the SICS Naming Service and SICS Workstation. The typical usage pattern is for the external application to use “client stubs” that are generated from the WSDL files. The SICS desktop runtime installation provides Java client stubs for SNS as well as SLD. ...
Running SICS Scheduler as a Windows Service # SICS Scheduler may be run as a Windows service using the wrapper functionality provided by Apache commons daemon. This applies only when starting the scheduler in unattended mode (using one of the -b options, see Appendix C - Command line parameters). Initial Installation # The SICS System Administration Utility must be installed in a local drive on the computer. The System Administration Utility must be configured to use only resources on local drives on the computer. ...
Splash Screen Branding # The SICS splash screen is graphic shown while SICS loads. This graphic contains a background image and the DXC logo. During the loading process, the SICS version and build information is painted on this graphic to inform the user which version of SICS is loading. The background graphic image changes annually and as part of creating the new graphic, the position of the DXC logo and the SICS version information may change. ...
Setting Additional Database Connection Properties # JDBC Connection parameters can be added to configure different aspects of the connection to the database. Configuration properties are platform specific and not common across DB platforms. For some DB platforms, JDBC connection properties can be provided as part of the connection URL (configured with the <dataSource> tag in sics-database-sources.xml). It is also possible - for all DB platforms - to configure JDBC connection properties on the command line and/or with the <additionalJdbcConnectionProperties> tag in sics-database-sources. ...