Open Source Java Data Warehousing Software

This project is dedicated to open source data quality and data preparation solutions. Data Quality includes profiling, filtering, governance, similarity check, data enrichment alteration, real time alerting, basket analysis, bubble chart Warehouse validation, single customer view etc. defined by Strategy. This tool is developing high performance integrated data management platform which will seamlessly do Data Integration, Data Profiling, Data Quality, Data Preparation, Dummy Data Creation, Meta Data Discovery, Anomaly Discovery, Data Cleansing, Reporting and Analytic. It also had Hadoop ( Big data ) support to move files to/from Hadoop Grid, Create, Load and Profile Hive Tables. This project is also known as "Aggregate Profiler" Resful API for this project is getting built as (Beta Version) https://sourceforge.net/projects/restful-api-for-osdq/ apache spark based data quality is getting built at https://sourceforge.net/projects/apache-spark-osdq/

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

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

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

CrNiCKL (pronounced "chronicle") is a data manager written in Java handling large sets of heterogeneous time series. A simple schema system allows to confiture value types and time domains. CrNiCKL runs on top of SQL or NoSQL databases. Drivers for JDBC and MongoDB are available.

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.

GenerateData is a general purpose data generation engine. No plug-ins, no APIs, just data generation made easy. From single files, to referentially sound databases, point, click, tweak and generate.

Main reason to open this project was desire to test some solutions like ability to remote upgrade or working with db. Anyway, software is working and is use as help to keep warehouse up to date.

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.

OpenFakt is an open source Java invoicing and billing system using XML definition files for various forms (address book, articles, invoices, stock management). It is language, database and platform independent and aims at small to big companies.

"Information is data in action", and, consequently, having good quality data is essential. The AESTEL package contains two highly configurable applications for data management: A data loader and a reporting application, i.e. DataLoader and AEREA, respectively. The data loader application applies user-defined instructions to validate, process and load data. The reporting application provides a query builder and spreadsheet template designer. Both applications work with any relational data model. (Postgres and Oracle have been tested). The two applications have been initially developed for small molecule drug discovery research. However, they can be extended for use in other data domains.

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.

Reporting solution that collects data from multiple MySQL databases and presents important metrics and reports related to performance and usage.

The project has been renamed CrNiCKL (chronicle) and moved to http://crnickl.sourceforge.net. ChronoDB is a data manager written in Java. It supports time series of any type. With its simple and powerful schema subsystem it takes charge of very large heterogeneous data sets. The software consist of an API and a generic implementation layer running on top of an SQL or a NoSQL system. Applications can mix objects from multiple ChronoDB databases.

A group a subprojects for Data Cleaning projects, mainly as a step of a Data Mining Project. Visit www.datacleaningopensource.com to review our current applications or if you want to add yours. NOTE: PROGRAMMING SKILLS ARE REQUIRED.

FormatCheck screens flat files looking for violations in the format of the data. It uses a set of XML files that define the rules for each file format. The Swing front-end allows the user to run the verification, view and print the errors.

JWDE extracts product information set from web and dumps is into db so e-commerce packages can use it. Currently JWDE can extract information from saved HTML files and convert it into JWDE XML format which can be save to osCMax e-commerce product.

The JasperSoft Business Intelligence Suite provides integrated reporting, analysis, and data integration to make faster, better decisions. * Integrated or stand-alone * Analytic & operational data integration * Embeddable with ERP or CRM

This is a Java based RESTful Web Service designed to interface with the proprietary MD (Melissa Data) windows database. MD provides several interfaces to validate addresses, phone numbers, email addresses, zip codes, amd more.

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.

O3-XDS stands for "Open Three (O3) - Cross Enterprise Document Sharing". O3-XDS is an Open Source and IHE compliant XDS Registry and Repository.

OGSA-DAI is a product that allows data resources, such as file collections, relational or XML databases, to be accessed, integrated and federated across the Internet.

OLAP Query Designer is a fork of JRubik, and will incorportate an all new interface and query designer. I allows querying of OLAP Datasources like Mondrian, and is based around JPivot and the Pentaho project.

Octopus Graphical Editor is a front end / GUI to help users to create XML files for Enhydra Octopus, which is a Java based ETL (Extraction, Transformation and Load) tool.

OLAP mapper is an OLAP engine written in Java. It enables you to interactively analyze very large datasets stored in SQL databases without writing SQL. The main concept of application is based on the star schema visualization.