Slik Software Ltd - The data integrators. Specialising in enterprise data integration products and development.

One World Integration

Links

Product Overview

The SLIK Server is a multi-threaded Windows NT application that processes user-defined batches (or interfaces) that consist of one or more jobs.

Scheduling

Each batch has an optional schedule that determines how frequently it runs. The schedule supports recurring daily, weekly, monthly at one time or multiple periods per day.
Batch Administrators

Associated with each batch is an administrator that contains a list of people responsible for managing the interface. In the event of a processing error the SLIK Server sends a detailed email (or pager) message to the batch administrator(s).
Job Operations

Each job is 1 of 24 different supported operation types. These range from a simple email alert to calling another SLIK batch. See below for a full list of currently supported operation types.
Job Processing Logic

When a batch falls due the SLIK Server runs each job in sequence. By default, if a job returns an error condition then any remaining jobs in the batch are not processed. This prevents further processing of incomplete data and on resolving the error allows for a restart of the batch from the point of failure. This behaviour of aborting the batch on a job error can be overridden using job level processing options.
Database Transactions

All database operations are automatically performed within a database transaction. This provides a mechanism to rollback any partial transfers in the event of an error.
Processing History Logs

As SLIK processes each batch / job it writes a detailed set of log records showing the time started, elapsed time and processing status.

While the primary purpose of SLIK is to perform real-time data integration it also supports many other useful operation types. These include such things as executing an external program, sending simple reports based on SQL statements and alerts via email.

Operation	Description
Alert Operator	Send an e-mail message (and optionally a pager message) to one or more recipients.
Table Mapping	Transfer data between source (one or more) and destination database tables with identical structure.
Column Mapping	Transfer data between source (one or more) and destination database tables of different structure.
SQL Statement	Perform an update / delete / select (report) SQL statement. Calls to database procedures are also supported.
Polled Statement	Test for the non-existence of data in a database table(s). Provides a mechanism to perform conditional processing based on availability of data.
Execute Command	Execute an external program. Input and output to/from the process can be read/written from/to a file.
Filtered Command	Identical to execute command but has specific semantics to determine the exit status of the process based on special keywords being seen in the output. This is mainly useful when working with rsh (remote shell) command.
SLIK Batch	Call another SLIK batch. The batch can run either synchronously or asynchronously.
EDI Export	Export data from database to flat files for EDI (Electronic Document Interchange) processing.
EDI Import	Import flat files that match a particular file specification (ie, pattern) from a folder into a database table.
File Operation	Perform copy/move/rename/concatenation of files based on file pattern.
File Test	Test for the existence of files and or hosts based on file time and/or size.
FTP Transfer	Perform Get/Put/Rename/Remove of remote files between FTP servers.
Iterate Collection	Perform an operation multiple times based on a row-set result (ie, SQL select statement).
Map Drive	Map a remote drive (or printer) resource.
OneWorld Report	Launch a J.D. Edwards OneWorld report (UBE). SLIK polls the servers print queue waiting for the report to complete. It can also perform conditional custom print redirection of the Adobe PDF report output on completion.
OneWorld Subsystem	Similar to launching a OneWorld report but adds an entry into the OneWorld subsystem table. It also allows you to pass user defined parameters (i.e., report interconnects).
Group Variables	SLIK provides a collection of user defined variables. This operation lets you load a different set of group variables within a batch.
Go to Job	Branch from the current job to another job in the batch.
Halt Batch	Halt processing of jobs in a batch.

See also SLIK Architecture Whitepaper »

home | company | solutions | employment | contact us