The different systems present within a company as well as the frequent merger and migration activities make the need for data integration really vital to the corporate.

Such a context requires systems that can access virtually all data sources to extract, verify, process and enrich the information making it available for target systems as flexibly as possible.

The main objectives to be achieved through the Irion solution are the following:

• Access to data natively residing on different systems
• Introduce the ability to parametrically select the data
• Enable data filtering and mapping for information homogenization
• Check the input data and detect any abnormalities
• Browsing the data coming from different systems within a single environment
• Enrich the input dataset obtaining new information
• Prepare the information to be exported to other systems through various means (CSV file, fixed-format, database, etc.)

IrionDQ meets the objectives of seamless integration between different systems with the purpose of controlling, enriching and transforming the data to be fed into other systems. The ease of systems coupling  greatly speed up the information retrieval process as IrionDQ adapts to the specific data sources formats.

Using IrionDQ to perfom such activities can be defined as 'in process'.

A classic example of an 'in process' solution is the migration of data for changing procedures. In this case IrionDQ is used as a gateway between the old and the new system and handles all the data migration's logics.

The following specific product features are used for such applications:

• Flexibility in accessing data and adapting IrionDQ's Datalink with ease. Fast data access by using Datalinks for data retrieval from DB2®, Oracle®, Teradata®, Microsoft SQL Server®, Text files, Excel® spreadsheets, host printouts and native files. No predefined data format is required by IrionDQ.
• Introduction of specific control rules over the input data before migration.
• Possibility to derive additional information to enrich the data sets and integrate different data sources.
• Transcoding data by using tables that are locally defined within the IrionDQ package of rules or even loaded from external sources.
• Manual integration of data and modifications log.
• Fields formatting for the preparation of the the output stream in any format (database, excel, txt, csv, multirecord files etc.).
• Production of summary reportings on the integration activities;
• Determination of the set of objects managed by the latest integration execution in order to perform incremental activities.
• Automation of the entire process by scheduling, through the IrionDQ's internal scheduling engine or through the execution of a multisteps as defined by an external procedure.

• Market Abuse Translator
• Data Management for Proprietary Data Warehouse