Scriptella is an ETL and scripts execution tool that is open source.
This software is perfect for various purposes such as database migration, database creation and update scripts, cross-database ETL operations, import/export, and is an excellent alternative for Ant's SQL task. Additionally, it can be used for automated database schema upgrade. The primary goal of Scriptella is exceptional performance and low memory usage.
One of its most notable features is its simple XML syntax for scripts. This allows you to add dynamic features to your existing SQL scripts by creating a thin wrapper XML file. You can use the support for multiple datasources (or multiple connections to a single database) in a script file, and Scriptella offers support for many useful JDBC features, e.g. parameters in SQL, including file blobs and JDBC escaping.
Scriptella offers several features such as support for evaluated expressions and properties through JEXL syntax, cross-database ETL scripts using elements, transactional execution, error handling via elements, and conditional scripts/queries execution similar to Ant's if/unless attributes, but more powerful.
What's more, Scriptella is easy to use as a standalone tool or Ant task, and no installation or deployment is needed. Additionally, it offers built-in adapters for popular databases for a tight integration, supports any database with JDBC/ODBC compliant driver, and comes with a Service Provider Interface (SPI) for interoperability with non-JDBC DataSources. It also has built-In CSV, LDAP, Velocity, and Janino providers, integration with Spring Framework, and JNDI for enterprise-ready scripts.
The stable 0.9 Release has added auto-discovery for JDBC drivers, support for JSR 223, and a new ?{textfile 'filename/url' } syntax extension for uploading CLOBs from text files. It also includes a database migration template for easy migration, among other features.
The 1.0 RC Development Release has improved features, such as making the driver attribute optional with a default value, the ability to execute multiple ETL files in Spring, a new dialect exclusion attribute, and support for more drivers like IBM AS/400 and SqlSheet JDBC Excel driver.
Overall, Scriptella is an excellent option for anyone looking for a simple and efficient way to implement ETL processes.
Version 0.9 / 1.0 RC: N/A