Data Warehouse Tools
The tools that allow sourcing of data contents and formats accurately and external data stores into the data warehouse have to perform several essential tasks that contain:
There are several selection criteria which should be considered while implementing a data warehouse:
Data Warehouse Software Components
A warehousing team will require different types of tools during a warehouse project. These software products usually fall into one or more of the categories illustrated, as shown in the figure.
Extraction and Transformation
The warehouse team needs tools that can extract, transform, integrate, clean, and load information from a source system into one or more data warehouse databases. Middleware and gateway products may be needed for warehouses that extract a record from a host-based source system.
Software products are also needed to store warehouse data and their accompanying metadata. Relational database management systems are well suited to large and growing warehouses.
Data access and retrieval
Different types of software are needed to access, retrieve, distribute, and present warehouse data to its end-clients.