Contact Gamma Soft

data'distribution
Capturer, transformer et propager les changements au sein des bases de données.
Accédez à l'article

The data’distribution transactional CDC tool captures changes from transaction logs

The data’distribution transactional CDC technology captures changes from database transaction logs to detect, capture, transform and distribute the changes in the databases.

The operation of data’distribution is non-intrusive, incremental and has no impact on performance.

A transactional CDC that reads the transaction logs

 

data'distribution uses the database logs to detect and distribute events concerning strategic data in real time.

The data’distribution engine retrieves the changes made in the database via an asynchronous agent that reads the transactions log on the source machine.

The data’distribution real-time solution goes beyond classic Change Data Capture (CDC) technologies since it respects the transaction steps. We thus talk of transactional CDC.

 

 

data’distribution operates in real time, in incremental mode

 

Incremental mode enables you to operate in real time (on the fly, with a latency of less than one second) and to considerably reduce the volume of information to be refreshed.

 

data'distribution increases a BI system's performance: the BI system only receives new and updated information, which significantly reduces the volume of data to transfer. In incremental mode, a night-time schedule can be implemented to refresh the data warehouse.

 

data'distribution gives e-business systems a veritable competitive edge by enabling, for example, the real-time update of customer order or stock statuses.

 

data’distribution also allows you to work directly on the source files or tables without the need for support via the transactions log. EXTRACT mode authorizes a full refresh with or without making a selection (on a given date, for example).

 

 

data’distribution supports heterogeneous data sources


data’distribution can be used to load - in real time - a target database whose structure differs radically from that of the source. This makes it possible to configure the merging or splitting of records.

 

data’distribution offers users the unique possibility of identifying data variations and working on these variations. For example, you can determine by how much a price has changed - in value and as a percentage - as soon as the module shows a variation on the source, in particular to:

 

  • select a record when code X changes from value 'A' to value 'B', rather than when code X merely contains value 'B',
  • or send the former price to the target machine along with the new price in order to update an aggregate in parallel (in real time) on the target machine.

data’distribution’s stop and start-up functions can be easily integrated in your applications and your administration tools. In addition, data’distribution alerts   are standardized for easy integration in your alert escalation tools.

 

 

Exchanges reduced to a strictly necessary level


Whatever the data transaction processed by data’distribution, the transformation module offers unlimited possibilities to select and enrich data, using user programs where necessary.

The selection/transformation is performed on the source machine, so that only the necessary data is sent - in the required format - to the target machine, which greatly reduces the volumes exchanged.

 

Information is transmitted in blocks and processed in parallel on the target machine. In other words, while the target machine processes a block, the next block is being prepared on the source machine. As a result, no time is lost and large volumes are seamlessly absorbed. The target machine applies each block received to the target database using complex algorithms. Errors can be managed with the option of automatic repair.

 

 

data’distribution is non-intrusive in the ERP

 

The possibility of calling a user program on the target machine means you can interface with an ERP software by using its APIs rather than writing directly in its database.

 

Logiciel non intrusif dans l'ERP

 

 

In short, data’distribution's operation:

  • is non-intrusive in the transactions: an asynchronous agent captures the changes in the transactions log
  • is incremental: data’distribution operates in real time (on the fly)
  • does not impact the operational system performance
  • considerably reduces the volume of data to refresh
  • ensures scalable, heterogeneous and high-performance integration of data in complete security