Scriptella: Difference between revisions

Revision as of 17:15, 21 September 2019

Revision as of 00:23, 3 April 2020

Line 12:

| genre = [[Extract transform load|ETL]], [[Data migration]] and [[SQL]].

| license = [[Apache Software License]]

| website = [http{{URL|https://scriptella.org http://scriptella.org]}}

}}

'''Scriptella''' is an open source [[Extract transform load|ETL (Extract-Transform-Load)]] and script execution tool written in Java. Its primary focus is simplicity. It doesn't require the user to learn another complex XML-based language to use it, but allows the use of [[SQL]] or another [[scripting language]] suitable for the data source to perform required transformations. Scriptella does not offer any [[graphical user interface]].

==Typical use==

Line 21:

* Database creation/update scripts.

* Cross-database ETL operations, import/export.

* Alternative for [[Apache_Ant|Ant]] <code><sql></code> task.

* Automated database schema upgrade.

Line 39:

* '''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 <code><dialect></code> elements

* '''Transactional execution'''

* '''Error handling''' via <code><onerror></code> elements

* '''Conditional scripts/queries execution''' (similar to Ant if/unless attributes but more powerful)

* '''Easy-to-Use''' as a standalone tool or [[Apache_Ant|Ant]] task., Nowithout deployment/installation requiredor 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/[[Open Database Connectivity|ODBC]] compliant driver.

Line 50:

==External links==

* [{{Official website|https://scriptella.org Scriptella ETL Site]/}}

* {{GitHub|scriptella/scriptella-etl}}

* [https://groups.google.com/d/forum/scriptella/ Discussion forum]

* [https://www.javaforge.com/proj/forum/browseForum.do?forum_id=3126 Discussion forum(deprecated)]

* {{Openhub|id=p_4526|name=Scriptella ETL}}