Open Source Data Warehousing Software

DataCleaner is a data quality analysis application and a solution platform for DQ solutions. It's core is a strong data profiling engine, which is extensible and thereby adds data cleansing, transformations, enrichment, deduplication, matching and merging. Website: http://datacleaner.github.io

The aoetools are programs for users of the ATA over Ethernet (AoE) network storage protocol, a simple protocol for using storage over an ethernet LAN. The vblade program (storage target) exports a block device using AoE.

ReportServer is a modern and versatile open source business intelligence (BI) platform with powerful reporting features. With ReportServer you are not limited to one provider's solutions. ReportServer integrates Jasper, Birt, Mondrian and Excel-based reporting: choose what best suits your needs! The source code is also available in GitHub: https://github.com/infofabrik/reportserver ReportServer scripting samples: https://github.com/infofabrik/reportserver-samples

OpenReports is a powerful, flexible, and easy to use web reporting solution that provides browser based, parameter driven, dynamic report generation and flexible report scheduling capabilities. Supports JasperReports, JFreeReport, JXLS, and Eclipse BIRT

Snowplow is ideal for data teams who want to manage the collection and warehousing of data across all their platforms and products.

MailArchiva is a powerful, full featured email archiving (email archiver) and compliance solution for mail systems such as Microsoft Exchange. It stores all incoming, outgoing and internal emails for long term storage. A web based user interface is avail

Help us to improve Freezer Web Access. We want to hear your feedback! Request new Freezer Web Access feature or module and receive a free Single User version with new feature. https://www.atgclabs.com/products/fw Freezer Web Access is a user friendly program designed to assist researchers with establishing an efficient system for storing frozen biological samples. FWA can track all of your research, development and process scale-up data in a single data storage platform, providing a organized and time effective means of keeping inventory and tracking samples on a large scale, while integrating sample storage and data storage on one easy-to-use format, minimizing confusion and increasing overall efficiency. With FWA, storage of samples is simple and systematic by entering them into the program according to their physical arrangements we create virtual containers matching these configurations and dimensions.

With Alfresco Audit Analysis and Reporting (A.A.A.R.) is provided a solution to extract, store and query audit data together with the document/folder informations at a very detailed level, with the goal to be useful to the end-user in a very easy way. To reach that goal, to make the data more friendly for the end-user, the data are published in reports in well-known formats (pdf, Microsoft Excel, csv, etc.) and stored directly in Alfresco as static documents organized in folders, versioned, authorized and published. On the top of the A.A.A.R. solution, the A.A.A.R. Analytics is a set of powerful tools to analyze data in an interactive and customizable way with a user console composed by dashboards, reports and free analysis.

Inventory, manufacturing, sales (POS) automation suite that consists of software written in Java 6 and custom developed hardware.

DBBrowser is an open source (GPL license), cross-platform tool which can be used to view the contents of a database. It works with Oracle and MySQL. The user can view, modify, delete records without writing SQL.

Palo ETL Server is a Java based Tool for Extraction, Transformation and Loading of mass data into the Palo OLAP Server. Palo ETL Server is one part of the Palo Suite.

Query2Report provides a simple opensource business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting. The application transforms bunch SQL queries to beautiful google charts. The application caters to real time reporting with automatic refresh functionality. Refer to video tutorials Concepts - https://youtu.be/NdEUZ2suiv8 Data Analytics Demo - https://youtu.be/evCf74Ou7kg Data Forecast Demo - https://youtu.be/Nmi1UIDpFpM Report Showcase - https://youtu.be/gxlEGq5iSm8 Getting Started - https://youtu.be/vyU7BUE5rbs Building First Report - https://youtu.be/MZm6rhf2_Ts Source Repo GitHub : https://github.com/yogeshsd/query2report

Command line data Copy/Migration tool for Oracle. Supports Oracle 7.3, Oracle 8i, Oracle 9i, Oracle 10G, Oracle 11G and 13 major databases. 1. Exadata 2. Sybase ASE 3. Informix Innovator C 4. Sybase SQL Anywhere 5. DB2 UDB 6. CSV 7. SQLServer 8. MariaDB 9. Sybase IQ 10. PostgreSQL 11. MySQL 12. Informix IDS 13. TimesTen

This is a very simple inventory system targeting for small business with small warehouse and it is is designed for fashion and clothing industry. It is a browser based applications which utilized AJAX to let user input color/size on a two dimension table

openwms.org is a modularized warehouse management system split into a core project, a tms module and a wms module running in an OSGi environment to assure high availability and maintainability !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! SOURCE CODE HAS BEEN MOVED TO GitHub.org https://github.com/openwms/org.openwms !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

A generic SQL driven data audit tool for detecting differences between any JDBC accessible database tables and other data sources. Platform independent. It's a unix like diff for databases. Produces key values with the differing column name and data

JMagallanes is an open source end user application for Olap and Dynamic Reports written in Java/J2EE. Combines static reports, pivot table and charts. It reads from SQL and other data sources.

The ServiceNow Data Mart Loader (a.k.a. ServiceNow DataPump) is a Java application which uses ServiceNow’s Direct Web Services (SOAP) API to extract meta-data and data from your Service-now ITSM instance. The application automatically creates and maintains tables in an Oracle or MySQL database. Please view the Wiki Quick Start Guide for instructions. NOTE: This project has been rehosted on github (see https://github.com/gflewis/sndml). The updated version has been tested with Geneva and Helsinki, but the GUI is no longer supported.

Snowflake is a CASE Tool directed towards data warehousing projects. Through an easy to use graphical interface, it allows the construction of a conceptual design of the data warehouse or data mart, using a simple multidimensional notation.

The data pumper is the database tool! ... a Java command line program to copy data from a database or text file into a database / text file (with optional mailing). Make a select on Database-A and a update on Database-B, or execute a SQL statement. For IBM i (AS400) users is also a CL-Command included.

OLAP application in PHP for MySQL databases. No java-based web service needed. No MDX language to use. Download FooodMart Database for MySQL http://pentaho.dlpage.phi-integration.com/mondrian/mysql-foodmart-database On line demo and information at http://phpmyolap.altervista.org/

This tool acts as a preprocessor and transforms data from a database into arff format for weka data mining. Vertical to horizontal transformation for association analysis. The tool can use databases for which an OleDB adapter exists. Vb.Net for Win32

AMB New Generation Data Empowerment - offers a comprehensive approach to data governance needs with ground breaking features to locate, identify, discover, manage and protect your overall data infrastructure. Repeatable Process/Exposed Repository.

AlphaMiner is an open source data mining platform that offers versatile data mining model building and data cleansing features with an user friendly workflow interface.

Appacts was designed and developed with user in mind, leaving old style analytics services behind and starting fresh. We’ve looked for a way to empower our users by presenting data to them in a quick summarised view. We are here to make analytics exciting, engaging and more importantly productive, so you can make right decisions quickly.