Abstract:In order to solve the data exchange problem that between the heterogeneous databases upgrade with enterprise data models, create a common heterogeneous data exchange tools based on metadata. The study was focus on of the description and of ETL metadata, common heterogeneous data exchange system, and metadata storage model. Finally, implementation automatic extraction metadata and use of metadata to drive the implementation of the ETL engine functions. The tool has been applied well in Daqing Oilfield Exploration Institute data centers construction.