The General Etl System Based On Metadata Database Design And Development

After ERP and CRM,Business Intelligence system is the new informationsystem.Corporation has the information manager system,it also need a system what tohelp them to realize the decision-making automatic.The operating conditions of TheEnterprises dependent on the decision-makingThe Basis of decision-making relay on the experience,the data of the Corporation,the Methodes of making decisions. BI comes to help the Corporation to make thedecision.ETL is the Abbreviation of Extraction-Transformation-Loading, it Chinese name isdata Extraction, Transformation and Loading. ETL is the soul of the BI,is the base ofthe BI.The succeed ETL make the BI much more useful. The value of ETL is the dataunification,data centralization,data visibility.Data wearhousing is the method of theresolving the information acnode, ETL is the bridge of the information acnode.ETL extract the data from other parts,such as relation databse or flat file.Then itmake the clearing and Transformation for the data,loading the data into the DSS,OLAPor Dataminning system.With years experience of implementationing the datawearhousing,the ETL,the BIsystem,Conclusion of the function of ETL tool,I make the programing of the ETLsystem.It rely on the feature of database and programing tool.The Purpose of the systemis make developing of ETL to be simple,enhancing the useful of the ETL system.Also itcan debase the workload of ETL developer.