Главный

InfinityETL – System of data import/export

InfinityETL – System of data import/export

pdf Open PDF document

Purpose

Solving integration problems that require data from heterogeneous sources to be combined for subsequent analysis and reporting.

General Functions

  • Organizing information exchange between different data sources: relational databases, OPC servers and other components.
  • Providing data for process control systems in a user-friendly format.

Features

  • Powerful visual tools for setting up rules for uploading, converting, loading data and processing scenarios.
  • Start import/export processes for requirements, schedules, events.
  • Extensive diagnostics and monitoring of running import-export processes.
  • Support for scripting language, transaction management.

General Information

A component designed to solve integration problems that require data from heterogeneous sources to be combined for subsequent analysis and reporting.

Information Systems Integration

InfinityETL provides information exchange between such levels of enterprise management as technological, production, financial and economic:

  • Support for standard interfaces OPC, OLE DB, ODBC, ADO allows you to organize the exchange of information between databases and technology servers.
  • The use of data conversion procedures ensures the exchange between different information systems characterized by different data structures. The procedures allow you to change the format, aggregate, integrate, process data, etc.
  • Integration of heterogeneous information systems provides an opportunity to implement application tasks that automate end-to-end business processes of an enterprise.
  • Provides an information basis for analyzing performance indicators and generating reports on an enterprise scale.

Managing Import-Export Processes

InfinityETL provides a wide range of capabilities to manage data import/export scenarios:

  • Description of the import/export scenario logic in the form of an activity diagram, where you can define the actions, the order of their execution and the conditions under which the actions are performed.

InfinityETL_Features.png

  • Description of complex rules for converting data using scripts in a special text editor.
  • Flexible mechanisms for managing the rules for automatic start of import-export scenarios include scheduling modes (when certain times occur) and events (when certain conditions occur in the system).

InfinityETL_Managing Import-Export Processes.png

  • Diagnostics and monitoring of the data import-export processes performance: obtaining of operational information about the status of processes, viewing the list of completed actions, etc.
  • Suspension or cancellation of the started information exchange processes if necessary to forced the process to stop.
  • View the process execution history log.
  • The number of import/export scenarios is limited only by disk space.

Reliability and Safety

  • Security of access at the level of functions, objects and data. You can define the information that the user is allowed to access and the actions that the user can perform.

The Convenience of Use

  • A handy graphical editor for developing data overload scenarios. Describes the scripts logic in the form of action diagrams and a set of executable scripts.
  • Visual tools for customizing schedules for running scripts, for setting rights and rules for accessing functions and objects of the data import/export system.