Open Framework, Information Management Strategy & Collaborative Governance | Data & Social Methodology - MIKE2.0 Methodology
Wiki Home
Collapse Expand Close

Members
Collapse Expand Close

To join, please contact us.

Improve MIKE 2.0
Collapse Expand Close
Need somewhere to start? How about the most wanted pages; or the pages we know need more work; or even the stub that somebody else has started, but hasn't been able to finish. Or create a ticket for any issues you have found.

Scriptella

From MIKE2.0 Methodology

Share/Save/Bookmark
Jump to: navigation, search
Under construction.png
This article is currently Under Construction. It is undergoing major changes as it is in the early stages of development. Users should help contribute to this article to get it to the point where is ready for a Peer Review.


Scriptella is an ETL and script execution tool whose primary focus is simplicity. It allows the use of SQL or another scripting language suitable for the data source to perform required transformations.

Contents

Relationship to MIKE2.0

SAFE Architecture

  • Used to deliver the ETL sub-component

Overall Implementation Guide

ETL Design and Implementation Activities of MIKE2.0, which are:

Alignment with Strategic Requirements for Infrastructure Development

Product Review

Key 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 a ETL file.
  • Support for many useful JDBC features , e.g. parameters in SQL including references to file blobs and JDBC escaping.
  • Support for evaluated expressions and properties (JEXL syntax)
  • Support for cross-database ETL scripts by using <dialect> elements

Pros

  • Free
  • Easy-to-Use as a standalone tool. No deployment/installation required.
  • 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.
  • 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.

Cons

  • The source code for Scriptella ETL has less than a year of continuous activity, making this a relatively new project

Desired Enhancements

Functonality that users of the MIKE2.0 Methodology would like to see added to this product are as follows:

User Valuation Enhancements

Voting scores from MIKE2.0 Contributors on the value of the asset in the context of the overall methodology

Usage

Product Access

Scriptella Download available from product website

Open Source Licensing

Comparable Open Source Products

Reference Implementations through MIKE2.0

Wiki Contributors
Collapse Expand Close