Abstract: 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.