Research On Bank Data Integration Based On ETL

At present, the competitions on the finical markets, especially on the banking business, are showing a growing trend. This phenomenon particularly reflected after China became a member of the WTO. As one of the important commitments for accession to the WTO, the comprehensive opening of the finical markets provides a good opportunity for the international banks to access to the Chinese markets. Consequently, China is facing the international banks involved in the domestic financial competition, In addition, with the accelerating process of global economic integration, IT technology is also undergoing a change rapidly changes. And the IT technology is widely used at an alarming rate, and profound impact on all aspects of society. The same is true in the banking industry. The applications of the computer technology allow banks to meet the market and the customer’s ever-changing demand. This leads to more commercial banks are abandoning the past rely on subjective judgments, but to build a complete, accurate and timely bank data platform and base on the data to take effective management and develop the banking services and customer. Therefore, how to enhance the comprehensive strength of the bank, will greatly affect the market competition ability.This thesis is precisely embarks from the background above, Trying to start from the data processing, to provide the construction scheme for the bank data center, in this way to improve the efficiency of bank data processing. It also tries to lay a solid foundation for the construction of the bank’s data warehouse. In this process, it mainly based on the ETL process which is commonly accepted in the world. By choosing the right kind of data extraction, transformation tools, it tries to unify the data which was generated in the ordinary course of banking business process and to load it into the data mart. This thesis used ODI as the main tool. In this way to achieve data centralized processing. This thesis tried to achieve the unified storage and management of data and integrated using, and to enhance the efficiency of bank data processing.