CloverETL is Java-based tool/framework for data integration and creation of data transformations. It is component based and follows the concept of transformation graphs which consist of individual nodes/components performing simple (or complex) operations on data. Any transformation can be defined as a set of interconnected nodes through which data flows. CloverETL can be used as a standalone application or be embedded into a larger project.
H2 is an SQL database engine written in Java that implements the JDBC API. Embedded, server, and clustering modes are available. A browser based console application is included. The database has strong security features. Disk based and in-memory databases and tables are supported.
BaseX is a light-weight, high-performance, and scalable XML database system and XPath/XQuery processor, including full support for the W3C Update and Full Text extensions. An interactive and user-friendly GUI frontend gives you great insight into large XML data instances. It is platform independent and works out of the box.
MUSCLE (Multi User Server Client Linking Environment) is an N-way messaging server and networking API. It includes client-side networking APIs for various languages, including C, C++, C#, Delphi, Java, and Python. MUSCLE lets programs communicate over a network via streams of serialized Message objects. The included server program ("muscled") lets its clients message each other and store information in its server-side hierarchical database. The database supports flexible queries via hierarchical wildcarding, and "live" updates via a subscription mechanism.
hamsterdb Embedded Storage is an embedded database engine for C/C++, including wrappers for Java, .NET, and Erlang. It supports in-memory databases, very fast database cursors, "record number" databases, ACID transactions, and duplicate keys. hamsterdb is very fast and highly configurable. It compiles and runs on Unix platforms, Linux, Microsoft Windows, and embedded platforms.
SymmetricDS provides file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one-direction or bi-directional, asynchronous data replication. It uses Web and database technologies to replicate data as a scheduled or near-realtime operation. The software has been designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.
With MetaModel, you use a type-safe SQL-like API for querying any datastore. It is a data access framework providing a common interface for exploration and querying of different types of datastores. It isn't a data mapping framework. Instead, it emphasizes abstraction of metadata and the ability to add data sources at runtime, making MetaModel great for generic data processing applications, but less so for applications modeled around a particular domain.
StelsCSV is a JDBC driver that allows performing SQL statements and other JDBC operations upon text files (comma separated, tab-separated, fixed length, etc.). Using this driver, users can easily create a simple database consisting of plain text files. The driver can be used for writing data importing programs and migration tools. It supports most keywords of ANSI SQL92, table joins, INSERT, UPDATE, and DELETE statements, data types, aggregate, converting, string, and user-defined SQL functions.
StelsDBF is a DBF JDBC type 4 driver that allows the user to perform SQL queries and other JDBC operations on DBF files (such as those used by dBase III/IV/V, xBase, and FoxPro). The driver is completely platform-independent and does not require installing additional client or server software to provide access to DBF files. It can be effectively used to create, process, and export DBF databases in your Java applications. It supports most keywords of ANSI SQL'92; inner and outer table joins; CREATE, INSERT, UPDATE and DELETE statements; transactions; aggregate, numeric, and string conversion; and user-defined SQL functions.
StelsMDB is a MDB JDBC type 4 driver that allows you to perform SQL queries and other JDBC operations on Microsoft Access database (versions 2000-2010) files. The driver is completely platform-independent and does not require installing additional client or server software to provide access to MDB files. It can be effectively used to create, process, and export Microsoft Access databases in your Java applications. It supports most keywords of ANSI SQL'92, supports inner and outer table joins, supports CREATE, INSERT, UPDATE, and DELETE statements, supports transactions, and supports aggregate, numeric, string, conversion, and user-defined SQL functions.