Data Warehouse software provides access to structured and unstructured information and operational and transactional data in real time.
It provides users with all the functionality needed to obtain optimum return from a firm's most important investment -- information.
Consequently, this type of software plays a key part in ensuring that a business remains successful.
Data warehouse software provides much more than just data storage. After all, if you just want to store information relational databases would fit the bill.
Where data warehouse software adds a new dimension is that it offers the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary.
Software included in this article also help users to administer and monitor data quality, to ensure that it is relevant to the business situation.
This article highlights the best data warehouse software that runs under Linux. Although there is not a wide range available, all of the applications featured below are strongly recommended for any business which wants to tap the full potential of its information resources.
|Data Warehouse Software|
|Talend Open Studio||Project for data integration based on Eclipse RCP|
|LucidDB||Power Data Warehouses, OLAP servers and Business Intelligence systems|
|KETL||Production ready ETL platform|
|DataCleaner||Data quality application suite for data profiling, validation and comparison|
|MailArchiva||Email archiving and compliance|
|Apatar||ETL and mashup data integration|