Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. It allows the use of SQL or another

scripting language A scripting language or script language is a programming language that is used to manipulate, customize, and automate the facilities of an existing system. Scripting languages are usually interpreted at runtime rather than compiled. A scripting ...

suitable for the data source to perform required transformations. Scriptella does not offer any

graphical user interface The GUI ( "UI" by itself is still usually pronounced . or ), graphical user interface, is a form of user interface that allows users to interact with electronic devices through graphical icons and audio indicator such as primary notation, inste ...

Typical use

* Database migration. * Database creation/update scripts. * Cross-database ETL operations, import/export. * Alternative for Ant task. * Automated database schema upgrade.

Features

* 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 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 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, 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 In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An ...

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. * Built-In CSV, TEXT,

XML Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. T ...

, LDAP,

Lucene Apache Lucene is a free and open-source search engine software library, originally written in Java by Doug Cutting. It is supported by the Apache Software Foundation and is released under the Apache Software License. Lucene is widely used as a ...

Velocity Velocity is the directional speed of an object in motion as an indication of its rate of change in position as observed from a particular frame of reference and as measured by a particular standard of time (e.g. northbound). Velocity is a ...

, JEXL and Janino providers. Integration with Java EE, Spring Framework, JMX and JNDI for enterprise ready scripts.

External links

* * * Extract, transform, load tools Data warehousing products Data management {{compu-stub