From MIKE2.0 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.
Relationship to MIKE2.0
- 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
- 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
- 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.
- The source code for Scriptella ETL has less than a year of continuous activity, making this a relatively new project
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
Scriptella Download available from product website
Open Source Licensing
Comparable Open Source Products
Reference Implementations through MIKE2.0