Page 127 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 6: Source Integration

6.13.2 eai tools/products notes

There are many types of products that have one or more functionalities of EAI. These are MOM
(message-oriented middleware) systems; publish/subscribe systems, Transaction Processing
monitors, application servers, data warehouse and data mart systems and logical integration
systems. On the basis of the level of integration the tools perform the EAI solutions can be broadly
categorized into Data level products and Business Model level products.

Data Level products

The various products, which support the movement of data between applications, are:
1. File transfer tools
2. Copy management

3. Data propagation
4. Schema-specific data synchronization
5. Database replication
6. Extraction/Transformation

Only extraction/transformation products are capable of getting data directly into and/or out of
an application’s data store and can also change the format of the source data so as to fit the target
product group of EAI solutions.

Extraction/transformation products are of three types:
1. Code Generators
2. Transformation Engines
3. Data Warehouse and Data mart Loaders

Code Generator

The code generator assists in the manual coding of programs by extracting data from an
application and transforming it for loading into another application. This is useful for simple
application network.
Disadvantages

1. The resulting program is not independent of the source or target system, so for integrating
with more than one system extra programming / processing is required.
2. The desired level of data movement cannot be achieved, so modifications have to be done
to the generated code
3. Language used for the generated program may differ from system to system
4. Scalability is a major concern as the integration is point-to-point
5. Modifying an application can require major regenerations and modifications to existing
interfaces.

Transformation Engines/ Hubs

They use application metadata to create export-transform-load programs like code generators.
But the difference is that all code is executed at a central location independent of the source

LoveLy professionaL university 121