Scenarios for data integration

The following scenarios show how different organizations used InfoSphere® Federation Server to solve their data integration needs.

Financial services: Risk management

A major European bank wanted to improve risk management across its member institutions and meet deadlines for Basel II compliance. The bank had different methods of measuring risk among its members. Without a consolidated view of risk management, the bank had to generated individual reports for each vendor.

The bank used InfoSphere Federation Server as part of their solution to enable compliance with Basel II by implementing a single mechanism to measure risk. A database management system stores a historical view of data, handles large volumes of information, and distributes data in a format that enables analysis and reporting. The bank can view data in operational systems that are spread across the enterprise, including vendor information.

Product development: Defect tracking

A major automobile manufacturer needed to quickly identify and fix defects in several lines of its cars. Traditional methods, such as data queries or reporting, were too complex and too slow to identify the sources of problems.

By installing InfoSphere Federation Server, the company was able to identify and fix defects by mining data from multiple databases that store warranty information and correlating warranty reports with individual components or software in its vehicles.

Government: Emergency response

A small government needed to eliminate storage of redundant contact information and simplify maintenance. The department had limited resource for any improvements, and had only one DBA and one manager.

The government chose InfoSphere Federation Server to join employee contact information in a human resources database on Oracle with information about employee skills in an IBM® Db2® database. The information was presented to emergency personnel through a web portal that is implemented with IBM WebSphere® Application Server. By interfacing with existing SQL tools, the small staff was able to merge employee contact information across multiple databases.