基于SOA的银行非现场稽核系统中ETL设计与实现

Design and Realization of Bank Non-scene Auditing ETL Based on SOA

本文基于SOA设计思想,采用XML技术实现异构数据源的通用接口访问方式,提出一种采用配置文件来增强系统灵活性的方法,该方法提高了系统的可扩展性,稳定地完成ETL功能.DCT系统也可方便扩展用于其他行业数据仓库的ETL任务.

A self-developed ETL tool which is named DCT system is designed and realized under the background of the commercial bank non-scene auditing. The ETL system based on SOA is proposed in this pager,the XML technology is added for implementing the general access interface to heterogeneous muti-data sources.It is also enhanced the flexibility by using the configuration file. DCT system is convinced for the further development and expansion. Practical applications indicate that DCT system has a high flexibility, scalability. ETL functionality is stable completed. The implementation of DCT for bank data warehouse system is put forward.