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

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

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.

ETL Converter is a migration tool that builds open source ETL projects from existing projects made with proprietary software. The first version converts DataStage projects into Talend Open Studio projects. Other sources/targets will be available later.

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

Storekeeper is small tool that helps you to keep an eye on your resources in home lab or workshop. It can be used in several places and, thanks to it's single-file and synchronize option, merge data between users.

This is an offshoot project of open source data quality (osDQ) project https://sourceforge.net/projects/dataquality/ This sub project will create apache spark based data pipeline where JSON based metadata (file) will be used to run data processing , data pipeline , data quality and data preparation and data modeling features for big data. This uses java API of apache spark. It can run in local mode also. Get json example at https://github.com/arrahtech/osdq-spark How to run Unzip the zip file Windows : java -cp .\lib\*;osdq-spark-0.0.1.jar org.arrah.framework.spark.run.TransformRunner -c .\example\samplerun.json Mac UNIX java -cp ./lib/*:./osdq-spark-0.0.1.jar org.arrah.framework.spark.run.TransformRunner -c ./example/samplerun.json For those on windows, you need to have hadoop distribtion unzipped on local drive and HADOOP_HOME set. Also copy winutils.exe from here into HADOOP_HOME\bin

Datablender is an advanced data manipulation suite. It extacts data from various sources, including RDBMS and LDAP servers, collapsing identical subtrees. Data can be hierarchically browsed and further integrated, based on similarity criteria.

Trauma registry suite; Data collection application and server scripts to build trauma data warehouse and perform web-based analysis reporting. Cross-platform compatible for Windows, Apple, Unix, or Linux.

"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.

This software allows SAP BW web reports to be printed out directly from a web browser. It allows both fit to page and tile over multiple page options fully controlled by the user.

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

**** IMPORTANT **** Pour prendre connaissance du contenu des mises à jour consultez le ReadMe.txt ********************* Ce logiciel permet, via une interface simplifiée : - la gestion d'un portefeuille de projets de recherches cliniques/d'essais cliniques - la gestion du personnel associé (contrats, affectations, quotité) - le dépôt et le partage de documents par protocole de recherche - une gestion budgétaire simplifiée et partagée - l'accès à une interface d'administration des comptes d'accès et du paramétrage du logiciel L'interêt de ce logiciel repose sur sa simplicité d'installation et d'utilisation. Idéal pour les structures avec peu de personnel. Le nom de l'application vient de Gestion d'Unite de Recherche Clinique. Développé en PHP, supporté par une base de données MySQL. Cette application web fonctionne sur n'importe quel navigateur récent. N'hésitez pas à me contacter pour plus d'informations. Eric

Uses alternate data streams to provide arbitrary tagging and searching of files within NTFS and other modern file systems supporting alternate data streams. Customisable vocabulary provides searchable standardised tagging system of file associations. Unlike most other file archiving systems, no additional database is required, and the system is robust, and persists file attributes irrespective of renaming / moving / copying / modifying etc. I would appreciate your opinions and suggestions / bugs etc.

JBELT is a collection of procedure to create a PLM system oriented to connect the CAD application to the ERP database. Based on the web. The engine are JBoss, PostgreSQL and developed in Java on JBoss Seam framework.

A simple Java ASN BER decoder and profiler A tool for easy manipulation of BER encoded files. An "awk" for ASN.1 BER (for Unix people) or maybe a "notepad" for ASN.1 BER (for Windows people). Jberd (Java BER decoder) is a lightweight BER decoder and associated tools for interpreting and processing BER encoded ASN.1 files. The following facilities are provided: • JBerd Profiler. A tool for profiling the contents of BER encoded files • JBerd Flattener. A tool for converting BER encoded files to flat files for processing by other facilities • JBerd Decoder objects. A set of Java facilities for writing BER applications that require BER decoding Go to the "files" section (link at the top of this page) to download a pdf of detailed documentation. Andrew Forsyth

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

LIM helps a company to administer data about medias (such as CDs), software products, and licenses. To do so one can store data about machines, licensing models etc. Futhermore LIM supports people dealing with hardware/software leasing administration. Us

Monitors webpages for changes and emails output with differences to subscribers. Permits user accounts and registration. PHP/MYSQL.

Simple and easy ETL tool useful for small data warehouse projects. Written in Java.

MixDEM a web based ETL tools meant for Web integration, Data transformation and Mashup edition. It include MixDEM ETL Engine created using ZEND Framework, and MixDEM GUI Editor an AJAX IDE that enable developers to quickly and easily create applications.

Modest collection of OMBPlus scripts for Oracle Warehouse Builder. Utilities for creating repositories and targets, staging source tables, generating surrogate keys, etc.

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.

Google Web Toolkit-based tool for publishing user-friendly OLAP views, reports and dashboards. Uses Mondrian OLAP and a relational database as the back-end.

Partystic Sheets is a simple MySQL manager that provides a friendly user interface to manage databases as sheets. This program prevents overwritting data when users are sharing sheets. You can export databases to XML files.