Open Source Java Data Management Systems for BSD

Pentaho couples data integration with business analytics in a modern platform to easily access, visualize and explore data that impacts business results. Use it as a full suite or as individual components that are accessible on-premise, in the cloud, or on-the-go (mobile). Pentaho enables IT and developers to access and integrate data from any source and deliver it to your applications all from within an intuitive and easy to use graphical tool. The Pentaho Enterprise Edition Free Trial can be obtained from https://pentaho.com/download/

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

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

ADaMSoft is a free and Open Source Data Mining software developed in Java. It contains data management methods and it can create ready to use reports. It can read data from several sources and it can write the results in different formats.

GeoKettle is a powerful, metadata-driven spatial ETL (Extract, Transform and Load) tool dedicated to the integration of different data sources for building and updating geospatial databases, data warehouses and services.

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.

Open Source Web-based Business Intelligence platform

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

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.

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.

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.

The giServer is an easy-to-use integration server for process automation and event-driven or scheduled execution of batch jobs. Instead of using complex XML configuration files an elaborate GUI for batch job management is included. Some possible usage scenarios are: - Automatic processing of incoming data files - Big Data applications - Process automation - Data Mining/Aggregation applications - Automatic Reporting - Processing and analysis of database records

easyDE is an Enterprise Business Intelligence platform that facilitates timely and effective business decision for companies to gain competitive advantage. Allow a wide range of end-users to quickly deploy rich analyses with a single integrated product.

Adele was developed to simplify the daily work with data. Use it as a swiss knife to fill the gap between your work with spreadsheet application like MS Excel and enterprise servers like SAP ERP. Specialized tools like Rapid Miner, KNIME or similiary stuff should not be replaced. But Adele is designed for business people working with spreadsheet applications to analyse their data. There are many technical concepts in an easier way included. For example realtime OLAP, transformations, charts, analysis tools,... Connectors (e.g. JDBC, SAP ABAP, OData) can be used to pre-analyse the data and extract it without saving the data as text files. A plugin concept for enhancements are available. Enjoy! Its free for commercial use too. Adele runs without installation from USB stick for Windows, Linux and MacOSX. Last added changes: - data science tools (V1, IQR) - export to remote and desktop databases (mysql,sqlite, ms access) - internet features for emails and domains

BIRD stands for Business Intelligence Research and Development and it is part of the CoIntell Corporation (www.cointell.com). The goal of the BIRD community is to develop smart BI solutions Fast!

BPMspace is open for extensions and free to use. BPMspace connects business processes with each other, similar to a relational database. Learn how to build/model a CMS and CMDB: http://www.mitsm.de/schulungen/spezial-schulungen/itil-cmdb-modellierung-und-konzeption

Beigesoft™ EIS is free accounting software. This is JEE-WEB-based software that works anywhere - on MS Windows, Mac, Linux and Android. This is the first version of the successor to Beige Accounting All In One. The main goal was successfully achieved, it works noticeably faster on weak devices such as a smartphone than its predecessor. It works as: * Standalone A-Jetty web-app for standard Java (Ms Windows, Mac, Nix...). * Standalone A-Jetty web-app for Android (use "Beigesoft Enterprise Information System" to find it in Google Play Store or https://play.google.com/store/apps/details?id=org.beigesoft.accandr). * Standard JEE web-application on any JEE server (cloud). You can download it from central Maven repository https://search.maven.org/#search%7Cga%7C1%7Cg%3A%22org.beigesoft%22 See https://sites.google.com/site/beigesoftware/eis-bobs-pizza Beigesoft EIS Bob's Pizza example.

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

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

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

Compiere MFG+SCM Manufacturing Extended System (MES). Include Shop Floor Control, Supply chain management, Quality management, modbus interface, iReport barcode extension etc. Support batch and on demand manufacturing. Works alone or connected to ERP.

DeciGen® is an ERP with added features for help in decision making process. DeciGen incorporates Decision Support System over an framework of ERP to provide a feature rich solution. It aims to achieve the final goal of IT - to run business smoothly. Dec

The Enterprise Knowledge Base (EKB) from ModelDriven.org is a repository for enterprise knowledge: metadata, planning and governance. The EKB can manage and transform both structured and unstructured data as files, Eclipse-EMF or RDF ontologies.

Open source Application and Data Integration Platform that allows developers and end-users to integrate and transform information using a web-based drag-and-drop interface that doesn't require coding or programming skills.