Scriptella Scriptella - ETL and script execution tool
Download

Scriptella Ranking & Summary

Scriptella Tags

execute database migration script execute script execution script execution

Scriptella Description

Scriptella - ETL and script execution tool Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.Our primary focus is simplicity. You 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.Typical use:· Executing scripts written in SQL, JavaScript, JEXL, Velocity and many more.· Database migration. Interoperability with LDAP, JDBC, XML and other datasources.· Cross-database ETL operations, import/export from/to CSV, text and XML and other formats.· Alternative for Ant task.· Automated database schema upgrade.Here are some key features of "Scriptella":· Simple XML syntax for scripts. Add dynamics to your existing SQL scripts by creating a thin wrapper XML file:· Support for multiple datasources (or multiple connections to a single database) in a ETL file.· Support for many useful JDBC features , e.g. parameters in SQL including references to file blobs and JDBC escaping.· Performance. Performance and low memory usage are one of our primary goals.· Support for evaluated expressions and properties (JEXL syntax)· Support for cross-database ETL scripts by using elements· Transactional execution· Error handling via elements· Conditional scripts/queries execution (similar to Ant if/unless attributes but more powerful)· Easy-to-Use as a standalone tool or Ant task. No deployment/installation required.· 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 scripting languages. Out of the box support for JSR 223 (Scripting for the Java Platform) compatible languages.· Built-In CSV, XML, LDAP, Lucene, Velocity, Excel, Text, JEXL and Janino providers. Integration with Java EE, Spring Framework, JMX , JNDI and JavaMail for enterprise ready scripts.NOTE: Scriptella is licensed and released under the Apache License, Version 2.0.

Scriptella Related Software