Scriptella Scriptella is an open source Extract-Transform-Load (ETL) and scripts execution tool.
Download

Scriptella Ranking & Summary

Scriptella Tags

scripts ETL Extract-Transform-Load ETL execution scripts execution Scriptella

Scriptella Description

Scriptella is an open source Extract-Transform-Load (ETL) and scripts execution tool. Scriptella is an open source Extract-Transform-Load (ETL) and scripts execution tool. 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 your datasource) to perform required transformations.Typical use· Database migration.· Database creation/update scripts.· Cross-database ETL operations, import/export.· Alternative for Ant < sql > 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: < !DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd" >< etl > < connection driver="$driver" url="$url" user="$user" password="$password"/ > < script > < include href="PATH_TO_YOUR_SCRIPT.sql"/ > -- And/or directly insert SQL statements here < /script >< /etl > · Support for multiple datasources (or multiple connections to a single database) in a script 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 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 attrbutes but more powerful) · Easy-to-Use as a standalone tool or Ant task. No deployment/installation required. · 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. · Built-In CSV, LDAP, Velocity and Janino providers. Integration with Spring Framework and JNDI for enterprise ready scripts.What's New in 0.9 Stable Release:· This release added auto-discovery for JDBC drivers, support for JSR 223 (scripting for the Java platform), and a new ?{textfile 'filename/url' } syntax extension for uploading CLOBs from text files.· A database migration template was added.· An issue with the LDAP driver when using search.scope and search.basedn parameters was fixed.· Dialect name matching was simplified.· Support for bind variables/expressions in an HREF attribute of an include element was added.· A skip_lines connection parameter was added for the CSV and Text drivers.What's New in 1.0 RC Development Release:· The driver attribute was made optional with a default value of "auto". etl.text utility methods were added to format strings.· The ability to execute multiple ETL files in Spring was added.· The "exclude=true/false" attribute was added for the dialect tag.· A NullpointerException in JEXL expressions if running in multiple threads was fixed.· Inserting NULL values into a DB2 database was fixed.· The onerror regex matching for message and type attributes was simplified.· New drivers were added for IBM AS/400 and SqlSheet JDBC Excel driver.· The CSV driver was improved.· The opencsv library was replaced with a built-in implementation.

Scriptella Related Software