REVIEWER: William Petersen, vice president of Bank of Tokyo- Mitsubishi.

BACKGROUND: The Bank of Tokyo-Mitsubishi, Ltd. (BTM) is Japan's premier bank. Through its Mitsubishi Tokyo Financial Group, Inc., it offers an extensive scope of commercial, investment and trust banking products and services to businesses, governments and individuals worldwide. BTM's domestic network comprises more than 300 branches, sub-branches and agencies. Its overseas operations consist of approximately 400 facilities located in all the major financial and commercial centers of the world.

PLATFORMS: Thirteen COBOL-based operational application databases on an IBM Mainframe DB2 on OS/390.

PROBLEM SOLVED: When faced with regulatory reporting requirements, Bank of Tokyo-Mitsubishi decided to build a data warehouse to meet those requirements and satisfy additional business needs, such as credit risk management, CPA/profitability reporting and head office reporting (sending various reports to the Tokyo head office). We decided to use DB2 for the data warehouse, BusinessObjects as the query tool and the ETI Solution for populating the data warehouse from our legacy source systems and for pulling reports from the data warehouse.

PRODUCT FUNCTIONALITY: The ETI Solution was used to create the interfaces that load the warehouse, the interfaces that refresh the warehouse and the interfaces that provide various reports. ETI's point-and-click interface allowed us to define business rules once and then drag and drop across different interface specifications. The ETI Solution produced all the programs and job control script in addition to a blueprint of all the steps needed to consolidate, cleanse, sort and merge the data from multiple sources and load into the data warehouse. We were also able to use the ETI Solution to export the required meta data to the IBM Information Catalog Meta Data Repository.

STRENGTHS: One of the key benefits of using the ETI Solution was its ability to generate native code and JCL for use in OS/390 environments. Since the programs generated by the ETI Solution run directly from the sources to targets without having to go through an engine, BTM was able to easily scale the solution to handle massive volumes of data ­ on average, 115,000 deals per day.

WEAKNESSES: The ETI products require some setup by a highly qualified administrator to be able to automate the generation of JCL and support certain business rules.

SELECTION CRITERIA: BTM chose the ETI Solution on the basis of its strong reputation and track record as a superior product, ETI's quality customer service and the availability of highly qualified, knowledgeable consultants. Also, it was of critical importance for BTM to achieve a speedy implementation and easily customize the product to BTM's diverse environment. The product's power enables BTM to gain numerous benefits from the simple, point-and-click intuitive interfaces. No other vendor could provide a complete meta data audit trail, native access to legacy data and adapt to our ever-changing environment.

DELIVERABLES: BTM's primary deliverable was the consolidation of multiple source system transactional data into a defined data repository. BTM started using ETI in November of 1999. Since then, we have successfully implemented three phases of our data warehouse and are now in phase four. ROI benefits include generated program code in one-quarter of the time required with traditional methods (i.e., custom COBOL coding) and a 90 percent reduction in entire development and testing cycle time. We have found that we have had to implement many changes to the original specifications. The ETI Solution has allowed us to enhance the programs in a timely and efficient manner. It provides a level of meta data (transformations and mappings) which is otherwise non-existent and provides flexibility in development options. We have on many occasions changed the design approach to utilize ETI when other methods proved unexpectedly inappropriate. There is no need to hire COBOL- specific resources, and we are able to train employees on the job to use ETI in a relatively short period of time.

VENDOR SUPPORT: We used ETI consultants during the initial phases of the project. ETI has provided good support with knowledgeable personnel. Our issues have been addressed in a quick, complete and friendly manner.

DOCUMENTATION: ETI provides comprehensive documentation. Overall, it provides good detail, especially in its reference areas. Cross-referencing was easy by utilizing the ETI*Bookshelf CD that provides cross-referencing assistance.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access