Tools for Administering the Data Warehouse in Oracle 11g

Tools for Data Warehouse in Oracle 11g or 10g

 To enable, to quickly and efficiently create and administer an Oracle data warehouse. The following are some of the products, tools, and utilities you can use to achieve your goals with your data warehouse:

 Oracle Universal Installer:

Oracle Universal Installer installs your Oracle software and options. It can automatically start the Database Configuration Assistant (DBCA) to install a database.

 Oracle Enterprise Manager:

The primary tool for managing your database is Oracle Enterprise Manager, a Web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise

Manager for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and for Oracle utilities such as

SQL*Loader and Recovery Manager.

Oracle Warehouse Builder:

The primary product for populating and maintaining a data warehouse, Oracle

Warehouse Builder provides ETL, data quality management, and metadata management functionality in a single product.

Warehouse Builder includes a unified repository hosted on an Oracle Database. Warehouse Builder leverages Oracle Database functionality to generate code optimized for loading into and maintaining Oracle Database targets.

 Database Tuning Pack:

Oracle Database Tuning Pack offers a set of new technologies that automate the entire database tuning process, which significantly lowers database management costs and enhances performance and reliability. The key features of Oracle Database Tuning Pack that will be used in this guide are the SQL Access and SQL Tuning Advisors.

Analytic Workspace Manager Application Plug-ins:

This release of Analytic Workspace Manager includes two application plug-ins:

1.       The Oracle Business Intelligence Enterprise Edition (OBIEE) Plug-in for Analytic Workspace Manager (obieeplugin.jar) lets you quickly create an OBIEE 10g or 11g repository that enables the OBIEE Server (and therefore any OBIEE client, including Dashboards, Answers, Delivers, and the MS Office Plug-in) to query Oracle Database 11g OLAP cubes.

2.       The Data Validation Plug-in for Analytic Workspace Manager (datavplugin.jar) provides tests to quickly find conditions in dimension table data that might cause errors when maintaining an OLAP dimension or cause problems when querying a cube using business intelligence tools. The data validation plug-in also includes methods that can quickly fix many different types of data errors in dimension tables. Please refer to the Review Guide for Data Validation Plug-in.pdf for a tutorial on the use of the Data Validation Plug-in.

Oracle Application Express:

Oracle Application Express (Oracle APEX), is the low code web application development tool for the Oracle database. Application Express enables you to design, develop and deploy beautiful, responsive, database-driven applications, either on-premises or in the cloud. Using only a web browser and limited programming experience, you can rapidly develop and deploy professional applications that are both fast and secure for any device from desktop to mobile. Oracle Application Express combines the qualities of a low code tool such as productivity, ease of use, and flexibility, with the qualities of an enterprise development tool such as security, integrity, availability, availability and built for the web. See how you can take advantage of this fully-supported, no-cost feature of the Oracle Database by signing up for an account at apex.oracle.com.