基于ETL技术在ODS系统中的应用

ETL Technology in the ODS-based System

当今,越来越多的企业正在构建ODS运营数据仓储系统来满足其战略决策需要。利用ETL工具可以对异构数据源中的业务数据抽取和转换,并将其装载到ODS中,为基于企业统一数据之上的决策分析应用提供高质量的数据。因此,搭建一个高效的ETL平台,在整个ODS系统中具有非常重要的意义。

Nowadays,more and more companies are building a ODS operational data storage system to meet the needs of its strategic decision-making. ETL tools can make use of heterogeneous data sources in the data extraction and conversion operations,and its load to the ODS,the data based on the enterprise,the uniform application of decision analysis to provide high-quality data. Therefore,to build an efficient ETL platform,in the ODS system has very important significance.