Simple XML syntax for scripts. Add dynamics to your existing SQL scripts by creating a thin wrapper XML file:
<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd"><etl><connectiondriver="$driver"url="$url"user="$user"password="$password"/><script><includehref="PATH_TO_YOUR_SCRIPT.sql"/>--And/ordirectlyinsertSQLstatementshere
</script></etl>
Support for multiple datasources (or multiple connections to a single database) in an ETL file.
Support for many useful JDBC features, e.g. parameters in SQL including file blobs and JDBC escaping.
Performance. Performance and low memory usage are one of the primary goals.
Support for evaluated expressions and properties (JEXL syntax)
Support for cross-database ETL scripts by using <dialect> elements
Transactional execution
Error handling via <onerror> elements
Conditional scripts/queries execution (similar to Ant if/unless attributes but more powerful)
Easy-to-Use as a standalone tool or
Ant task, without deployment or installation.
Easy-To-Run ETL files directly from Java code.
Built-in adapters for popular databases for a tight integration. Support for any database with JDBC/
ODBC compliant driver.
Service Provider Interface (SPI) for interoperability with non-JDBC DataSources and integration with scripting languages. Out of the box support for
JSR 223 (Scripting for the Java Platform) compatible languages.