2. Data Warehousing
2.1. Oracle Data Integrator
Oracle Data Integrator Enterprise Edition delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance, reduces data integration costs, even across heterogeneous systems. Unlike conventional ETL tools, Oracle Data Integrator EE offers the productivity of a declarative design approach, as well as the benefits of an active integration platform for seamless batch and real-time integration. In addition, hot-pluggable Knowledge Modules provide modularity, flexibility, and extensibility.
Read more
2.2. Informatica Powercenter
Informatica PowerCenter integrates data from virtually any business system, in any format, and delivers that data throughout the enterprise at any speed to improve operational efficiency. Highly available, high-performance, and highly scalable, the software serves as the foundation for all enterprise data integration projects.
2.3. Oracle Warehouse Builder
Oracle Warehouse Builder is a single, comprehensive tool for all aspects of data integration. Warehouse Builder leverages Oracle Database to transform data into high-quality information. It provides data quality, data auditing, fully integrated relational and dimensional modeling, and full lifecycle management of data and metadata. Warehouse Builder enables you to create data warehouses, migrate data from legacy systems, consolidate data from disparate data sources, clean and transform data to provide quality information, and manage corporate metadata.
Oracle Warehouse Builder (OWB) 11g is a data warehousing-centered data modeling and data integration solution, built into every Oracle 11g database.
OWB 11gR2 is pre-installed with Oracle Database 11gR2, and can be installed and used alongside Oracle Database 10gR2 and 11gR1.