Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. The primary focus is simplicity and don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.
ETL Software Free
Easy to run
Easy to use
Contact for Pricing
Small (<50 employees), Medium (50 to 1000 Enterprise (>1001 employees)
Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. Its primary focus is simplicity hence users don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.
The solution features simple XML syntax for scripts and all users need is to add dynamics to their existing SQL scripts by creating a thin wrapper XML file.Moreover, it allows users to work with multiple data sources in a single ETL file while offering support for many useful JDBC features like batching, prepared statements and parameters in SQL including references to files (BLOBs) and JDBC escaping.
It also offers support for evaluated expressions and properties (based on JEXL syntax).Additionally, the platform can be used as a standalone tool or Ant task and it does not require any deployment or installation.It comes with built-in adapters for popular databases for a tight integration and support for any database with JDBC/ODBC compliant driver.
The solution features a Service Provider Interface (SPI) designed for interoperability with non-JDBC DataSources and scripting languages and an out-of-the box support for JSR 223 (Scripting for the Java™ Platform) compatible languages. It also comes with built-In CSV, Excel, Text, XML, LDAP, Lucene, Velocity, JEXL and Janino providers, and it supports integration with Java EE, Spring Framework, JMX , JNDI and JavaMail for enterprise ready scripts.