The Research & Application of ETL Tool in Business Intelligence Project

In modern business, vast amounts of data are accumulated, which makes the decision making process complicated. How to change the existing situation of "mass data, poor knowledge", support better business decision making and help enterprises increase profits and market share become the business and IT sector issues of mutual concern. Business intelligence technologies emerge as the times require. ETL plays an important part role in BI project, which realize the technical service and decision making support. This article sets out an overview of ETL, the main module of ETL, the optimization scheme of ETL, as well as the specific implementation of the ETL process.