Scriptella is an open source extract transform load (ETL) and script execution tool written in Java. It allows the use of

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

or another

scripting language In computing, a script is a relatively short and simple set of instructions that typically automation, automate an otherwise manual process. The act of writing a script is called scripting. A scripting language or script language is a programming ...

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

graphical user interface A graphical user interface, or GUI, is a form of user interface that allows user (computing), users to human–computer interaction, interact with electronic devices through Graphics, graphical icon (computing), icons and visual indicators such ...

Typical use

* Database migration. * Database creation/update scripts. * Cross-database ETL operations, import/export. * Alternative for

Ant Ants are Eusociality, eusocial insects of the Family (biology), family Formicidae and, along with the related wasps and bees, belong to the Taxonomy (biology), order Hymenoptera. Ants evolved from Vespoidea, vespoid wasp ancestors in the Cre ...

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 Java Database Connectivity (JDBC) is an application programming interface (API) for the Java (programming language), Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java ...

features, e.g. parameters in SQL including file blobs and JDBC escaping. * 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

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 data. It defines a set of rules for encoding electronic document, documents in a format that is both human-readable and Machine-r ...

LDAP The Lightweight Directory Access Protocol (LDAP ) is an open, vendor-neutral, industry standard application protocol for accessing and maintaining distributed Directory service, directory information services over an Internet Protocol (IP) networ ...

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 a measurement of speed in a certain direction of motion. It is a fundamental concept in kinematics, the branch of classical mechanics that describes the motion of physical objects. Velocity is a vector (geometry), vector Physical q ...

, JEXL and Janino providers. Integration with

Java EE Jakarta EE, formerly Java Platform, Enterprise Edition (Java EE) and Java 2 Platform, Enterprise Edition (J2EE), is a set of specifications, extending Java SE with specifications for enterprise features such as distributed computing and web serv ...

Spring Framework The Spring Framework is an application framework and inversion of control container for the Java platform. The framework's core features can be used by any Java application, but there are extensions for building web applications on top of the Ja ...

, JMX and JNDI for enterprise ready scripts.

References

External links

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

Typical use

Features

Further reading

References

External links