The Design And Realization Of ETL Tool

As the common application of computers and the fastened development of Internet, all kinds of businesses contact become more and more, which result data rise by index as time goes on. But among the data, inconsistent data usually exist, and they are separated, isolated as well as different in type. Even, it is hard to access or manage these data. They are also not used for users to make decision. However, these data contain valuable information for the companies'leader. So these data can be used to improve the companies'decision level, and make the companies get greater advantages, which is the big problem for the Business Intelligent to solve.According to study and analyze the existent Business Intelligence software, it is find that these software really keep some questions. So aiming at these questions, this Business Intelligence software is designed and realized for domestic middle or small scale companies. This system advised a solution that separates interface configuration on client end and execution work on server end, and the whole system based on mete data. Additionally, this system is designed for data source model, transformation model, workflow model, monitor model as well as schedule execution model. Data source is the base of the system, which adapted factory schema to be finished. The transformation process is complicated and cockamamie, and it based script analysis and temp db technology. Workflow is the core of the system, which used recursion method to accomplish its workflow execution. And based on time trigger technology, the components of scheduler and monitor of workflow is realized.All of the models are tested completely, the results of which prove the system's usability.