Page 148 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes As can be seen in Figure 1, in the as-is scenario, these legacy systems are acting as
independent data silos with absolutely no kind of data-sharing happening between them.
If the German SAP system wants to procure something from any of its vendors, it does
so by using some kind of manual process at its end. The same scenario is replicated for
all the other systems, too. And, this is leading to a lot of data duplication taking place.
For example, if two different systems are using the same vendor (say, Vendor A) for
procuring white board markers, this vendor (Vendor A) information is getting stored at
both the legacy systems. Also, this kind of scenario makes it impossible to leverage existing
information across multiple systems.
Royal Wallace understands that, to survive the competition in today’s fast paced economy
and to reduce its time-to-market, it needs to put an integration solution in place as soon as
possible. The integration model should integrate all the existing legacy systems irrespective of
the platforms and operating systems that these systems are based upon. The model should take
care of the various data formats that would pass through this integration scenario and apply
the necessary transformation, translation, and data validation rules upon them. And last, but
definitely not the least, this integration solution should be scalable enough such that any new
system could be easily plugged into this solution in the future with minimal changes.

The integration model should provide:
1. Integration between the various legacy systems
2. Automated process for procurement of goods
3. Data transformation and translation logic according to the prescribed rules
4. Persistent storage mechanism for the data
5. Validation of business data to a certain extent

6. Connectivity to various drop zones and databases

project Life cycle

Design and Architecture

As seen in Figure 2, the EAI solution proposed would make use of the integration
capabilities of the Seebeyond eGate software to seamlessly integrate the various individual
legacy systems of the Royal Wallace company with the SAP-based purchasing order (PO)
system.
SeeBeyond eGate Integrator is a fully J2EE certified and Web services-based distributed
integration platform. It provides the core integration platform, comprehensive systems
connectivity, guaranteed messaging, and robust transformation capabilities.

figure 2: to-Be scenario

Contd...
142 LoveLy professionaL university