Data Integration (ETL, EL-T)

One of the key strengths of Microgen Aptitude is the extensive built-in facilities to integrate legacy systems, major databases, web services, messaging systems, library/DLLs, and other applications.

With Microgen Aptitude teams graphically implement application and data flows

Microgen Aptitude’s data integration capabilities enable businesses to consolidate, aggregate and enrich disparate data sets.

Microgen Aptitude can be used to perform  provides strong ETL (extract, transform, and load data) and EL-T while , utilising in-database processing to implement these procedures rapidly and efficiently.

Microgen Aptitude can synchronise data across operational, transactional and warehouse systems in batch and real-time modes. With its two-phase commit approach to transaction management, continuity of data is significantly increased.

Microgen Aptitude allows the user to take data in any format, whether it be sourced from ERP systems, databases (such as Oracle, Teradata, SQL Server, Sybase), message queues, text or CSV, XML, SWIFT or any fixed-length file format.

Data can then be enriched with reference data and populated through to any number of different target systems. 

This powerful functionality can be designed using a wizard-driven, drag-and-drop interface without any need for coding, and can deliver comprehensive validation, enrichment and transformations.

Microgen Aptitude’s architecture allows users to configure these features thereby creating re-usable elements, which can be used both for receiving (inputs) and sending (outputs) data messages.