Data Care Manager

Automatic data maintenance with considerable benefits

Data Care Manager maintains your data automatically and efficiently while enhancing its quality and making it more up to date. All you need to do is to define the sources of information, the rules and the data you want to get. Our software does the rest. It obtains, completes, verifies and distributes your data automatically following the rules you lay down.

Download product presentation

Your benefits:

  • Your data will be of a higher quality.
  • Your data will always be up to date.
  • You will have available capacity for high volumes of data within a shorter time.
  • It relieves you of a thankless and time-consuming task.
  • It separates business expertise from IT implementation.

Product Information

Concept

The data or data fragments arrive on different ways from various sources into the system or can be actively requested / fetched from remote sites. The data must be readable but may be incomplete. An automatic, rule-driven processing chain forms these fragments to data. All data kept in the system is periodically validated. Valid data is then disseminated to multiple targets (push) or can be retrieved by remote systems (pull). Input and output data can have different structure and format. The user interaction is reduced to supervision and monitoring of the transformation process with occasional manual corrections. The degree of automation depends on the particular application and reaches up to 100%.

In opposite to other systems, this product handles partial, incomplete or invalid objects and keeps track of their state. Item, which is incomplete now, becomes complete after enrichment or in combination with other data and may finalize the overall picture like a last puzzle stone.


Processing Steps

This product handles also partial, incomplete or invalid objects and keeps track of their state. Item, which is incomplete now, becomes complete after enrichment or in combination with other data fragment and may finalize the overall picture like a last puzzle stone.

The input data is passed through multiple processing steps:

  • Importing - separation of readable and unreadable parts
  • Merging - combination of input data fragments pieces and merging with existing business objects
  • Completion - checking of required and optional attributes
  • Enrichment - active collection of missing information from remote sources e.g. Web-Extraction
  • Validation - validation of completed objects by applying business rules to them
  • Release - checking the conditions for data extraction
  • Extraction - extraction of data and their transformation into target structures
  • Dissemination - export and delivery of data to the target systems
Rule Editor

The product has an embedded rule engine (ACTICO Rules). The particular processing steps do invoke rules which in turn make decisions and perform action. Rules work on objects which are passed to them and do control merging, enrichment, completion, validation and release process. A rule action can be anything from a fine granular assignment statement up to the invocation of a high level business function. The rules are defined in graphical manner by the business users themselves and are deployed at into the system at run time.

The rules are edited and maintained with the ACTICO Rules editor by the business users. Finally, the editor generates a java library containing all rules. This library is deployed into the server at run-time without interruption i.e. hot deployment.

The rule editor has large number of built-in functions and actions. Project specific functions and action have been added in order to simplify the rule definition by the business users. The product is open for implementation of high level functions handling the business objects which can be made available within the rules (e.g. event creation). The organization of the rules is fully free.

Scheduler

The processing steps are grouped into jobs. They run in the background and do not interact with the user! Job execution is triggered by events or at defined time schedule. The processing progress is continuously recorded in an event log. The user evaluates the log and performs only actions not covered by the rules. The complete full validation is performed only once after an initial data load. The system keeps track of each object and performs only incremental processing on new or modified objects. For emergency cases when the external data is not available, data can be entered or modified manually. However the completion and validation rules can never be bypassed.

Data-Sets

In order to apply different sets of rules to the same data (what-if scenarios) all business objects within the system are under internal version control. Objects (files, persistent data in the Caché database or mix of both) are grouped in so called "Data-Sets" and saved as a Version. Version contains the snapshot of the data. Multiple versions can be created. Versions can be restored later, i.e. the data is restored into its original location. This allows the business users to develop and tune the business rules. It is also used for archiving of processed data.

Access Control

The product has a Web-GUI for daily business, administration, control and monitoring. It uses simple role-based access control for user authentication and authorization. User authorization via LDAP server is optional.

ControlC

The product is controlled and monitored with a Web-GUI. Web Service interface is provided for control and monitoring of the scheduler.

An automatic housekeeping function performs cleanup of unusable data and old events.


Input

The product supports data input as:

  • File in XML, plain ASCII, delimited (CSV) or Microsoft Excel sheet (XLS) format.
  • Mail with attachment in the file format defined above.
  • Web Service interface for direct insertion of data into the system by a remote system (push).
  • Extraction of data directly from the Web.
    (The script driven Web-Extractor sends requests to Web sites and extracts and parses received HTML data.)
  • Data can also be directly retrieved from remote sources accessed via ODBC and Caché Relational Gateway.
Output

Output data is provided in various formats and ways. The product supports output as:

  • File in XML, plain ASCII, delimited (CSV).
  • Mail with attachment in the file format defined above.
  • Web Service interface for direct retrieval of the final data by a remote system (pull).
  • Final data can also be directly written into remote targets accessed via ODBC and Caché Relational Gateway.

Required Components:

The product is composite software solution utilizing a rule driven architecture. It uses the following embedded products:

Platforms

The product is available on Microsoft Windows, Unix and Linux platforms supported by InterSystems Caché and Tomcat.

The ACTICO Rules editor (eclipse based standalone application) is available only on Microsoft Windows. The run-time component of ACTICO Rules runs on any platform supporting Java 1.5.

Multiple installations of the product on the same node are possible. Each installation has its own namespace and environment and can be operated independently.

Product Availability

STABILIT is the legal owner of the product and offers this software plus related services to customers in form of individual projects. All product license are included in the project package. Please contact us for further information.