P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven.
GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL».
GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with Java classes.
GETL taken into account when developing ideas and following requirements:
1. The simpler the class hierarchy, the easier solution;
2. The data structures tend to change over time, or not be known in advance, working with them must be maintained;
3. All routine work ETL should be automated wherever possible;
4. Compiling the code on the fly bail speed and reserve for the optimization;
5. Sophisticated class hierarchy guarantee easy connection of other open source solutions.
Feature
- Support for working with CSV, JSON, XML and Excel files
- Support for working with JDBC sources (tables, sql queries, DDL, sequence)
- Support for copying the data flow between sources
- Intelligent processing of data (mapping and cast) in flows
- Support for working with temporal data
- Support for data transformation (aggregation and sorting)
- Support for parallel execution of tasks
- Support for configuration files
- Support work with log files
- Statistics gathering speed execution of processes
- Manage files on file systems and FTP
- Library of functions for working with strings, dates, files, lists, maps and for the transformation of values
Toolsverse ETL Framework
ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications.
Key Features:
* embeddable, open source and free
* fast and scalable
* uses target database features to do transformatio.........
Hibernate
Hibernate is an Object/Relational Mapper tool. It's very popular among Java applications and implements the Java Persistence API. Hibernate ORM enables developers to more easily write applications whose data outlives the application process. As an Object/Relational Mapping (ORM) framework, Hibernate.........
log4db2
Log4db2 is a logging utility for DB2 for LUW that uses SQL instructions with SQL PL code.
Its purpose is to provide an easy way to write messages from a SQL routine, with the possibility to query these messages directly from the database and view the generated output, allowing to monitor the progre.........
miMas - GUI tool for SQL developers
miMas is an intuitive GUI tool for SQL query development and data browsing. It provides a common set of features across all databases and can be installed on any Operating System which has a Java Runtime available.
The tool uses JDBC drivers for connecting to a database. For most popular databases.........
HPCC Systems
HPCC Systems from LexisNexis Risk Solutions offers an open source, proven, data-intensive supercomputing platform designed for the enterprise to process & solve Big Data analytical problems. As an alternative to legacy technology, HPCC Systems is comprised of a single architecture, a consistent data.........
XML Editor/Validator/Designer with CAMV
The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JS.........
Lab Inventory
Request new Lab Inventory feature or module and receive a free Single User version with new feature.
Help us to improve Lab Inventory. We want to hear your feedback!
https://www.atgclabs.com/products/li
The Lab Inventory System is an innovative, easy to learn solution for research laboratories.
You.........
OpenUnderwriter (Insurance Distribution)
OpenUnderwriter is an open source software house specialising in the development of IT solutions for the insurance market.
Specialists in the areas of eBusiness and component based development, the team has developed technology for a number of major insurance companies.
The OpenUnderwriter platfor.........
Open Source Data Quality and Profiling
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 Str.........
Lioness (Languages Interop Framework)
Framework for making Windows applications that are one .exe file in AutoHotKey_L,C++,C#, VB.NET,Java,Groovy,Common Lisp,Nemerle,Ruby,Python,PHP,Lua,Tcl,Perl,Jint,S#,WSH VBScript,HTML/JavaScript/CSS,COM, PowerShell without compiling . For .NET 4....
