Scriptella

From MIKE2 Methodology

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 1 Relationship to MIKE2.0 1.1 SAFE Architecture 1.2 Overall Implementation Guide 1.3 Alignment with Strategic Requirements for Infrastructure Development 2 Product Review 2.1 Key Features 2.2 Pros 2.3 Cons 2.4 Desired Enhancements 2.5 User Valuation Enhancements 3 Usage 3.1 Product Access 3.2 Open Source Licensing 3.3 Comparable Open Source Products 3.4 Reference Implementations through MIKE2.0

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:

• ETL Physical Design
• Technology Backplane Development

Alignment with Strategic Requirements for Infrastructure Development

• Review against Technology Selection QuickScan

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

• GNU Public License (GPL)

Comparable Open Source Products

• Kettle
• KETL
• CloverETL
• Talend Open Source Solutions

Reference Implementations through MIKE2.0