Open Source Data Warehousing Software

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

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.

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

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

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

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.

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

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 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

La_Azada is an OLAP client developed in java (Eclipse Rich Client Application), and based on olap4j. Supports mondrian and XMLA drivers.

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.

Application for reporting and data visualization with possibility to store queries (data sets for reports), settings of fields and parameters. Easy to use, universal, dynamic, desktop,Windows, lightweight application. Displaying of the list of reports to choose. It is used to query MS SQL database and presentation of data in the form of a report ( subtotals and grouping), Pivot Chart or Pivot Table. Can also be created a pure extract and after copy/paste can be manipulated in any spreadsheet. Easy to use,desktop, Windows, lightweight application. No need to install. If someone is willing to develop and joining the project, then will be made available the source code.

The Iguana is a BI solution generation data management and decision making for Open Sources systems used worldwide and Commercial Systems used in Brazil.

LucidDB is a DBMS optimized for business intelligence. Besides architectural innovations such as column-store, it supports many advanced features from SQL:2003, including SQL/MED and user-defined transformations written in Java.

MiningMart is a graphical tool for transforming data from relational databases. It provides two dual graphical views on the transformations, a data view and a process view. The focus is on the preparation of data for data mining.

OLAP-SC is a business intelligence application for spend + savings transparency, strategic sourcing, procurement / purchasing controlling. IT provides an olap cube model, a relational db model and controlling reports. See: http://www.orpheus-it.com

********** Abandoned project ********** The Application Provides Mangagement for small and medium company. Create invoices, manage clients, employees payroll, inventory, sales, taxes, customer address book and much more, whit only one application

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.

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

JRubik is a set of tools for navigating and reporting over OLAP Datasources, mainly Mondrian and XMLA servers. This project is based on the components developed by the JPivot project.

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.

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.

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.

Archiweb will provide a CMS for managing architecture information and drawings, and viewing projects for selling them. This is a very good CMS for real-estate companies or architicture and blendings companies. It is a ready to install PHPNuke module.