Misplaced Pages

Scriptella

Article snapshot taken from[REDACTED] with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Script execution tool
This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages)
This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Scriptella" – news · newspapers · books · scholar · JSTOR (March 2012) (Learn how and when to remove this message)
The topic of this article may not meet Misplaced Pages's notability guidelines for products and services. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted.
Find sources: "Scriptella" – news · newspapers · books · scholar · JSTOR (March 2012) (Learn how and when to remove this message)
(Learn how and when to remove this message)
Scriptella
[REDACTED]
Stable release1.1 / 28 December 2012
Operating systemCross-platform
TypeETL, Data migration and SQL.
LicenseApache Software License
Websitescriptella.org

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 suitable for the data source to perform required transformations. Scriptella does not offer any graphical user interface.

Typical use

  • Database migration.
  • Database creation/update scripts.
  • Cross-database ETL operations, import/export.
  • Alternative for Ant <sql> 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:
          <!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 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 <dialect> elements
  • Transactional execution
  • Error handling via <onerror> 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 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, LDAP, Lucene, Velocity, JEXL and Janino providers. Integration with Java EE, Spring Framework, JMX and JNDI for enterprise ready scripts.

External links


Stub icon

This computing article is a stub. You can help Misplaced Pages by expanding it.

Categories:
Scriptella Add topic