Scriptella is an ETL (Extract-Transform-Load) and script execution tool. 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.

Main features:
* Simple and minimalistic XML syntax for ETL scripts.
* Built-in providers for JDBC, CSV, Text, XML, LDAP, Lucene and Velocity.
* Support for many useful JDBC features, e.g. parameters in SQL including file blobs and JDBC escaping.
* Easy-to-Use as a standalone tool or Ant task. No deployment/installation required. Easy-To-Run ETL files directly from Java code.
* Seamless integration with Java/Java EE and Spring

Journal Entries

No entries yet.


Ratings & Reviews

Community Rating
3.7/5.0

Based on 3 user ratings.

Your Rating

Click to rate this project.

over 2 years ago Avatar
Suitable for integration into commercial projects

  by ejboy

As far as I know Scriptella is the only Apache licensed ETL tool.

Was this review helpful to you? |

Links

3 links submitted so far. Submit your own links.

News

Edit RSS feeds.

    Scriptella ETL 0.9 Released

    Scriptella 0.9 is ready for download.
    This release introduced integration with JSR 223 (Scripting for the Java Platform)
    and drivers autodiscovery, based on users feedback, CSV and Text drivers were ... [More] significantly improved and of course Scriptella became even more faster. Other notable features and bug fixes:

    New syntax extension: ?{textfile 'filename/url' } to upload CLOBs from text files.
    Simplified dialect names matching
    Database migration template. etl-template Ant task.
    Support for bind variables/expressions in a href attribute of include element
    Since this release JDK 6 is required to build Scriptella
    We hope you will enjoy the new features. See change log for additional details.
    Make ETL easier - Download Scriptella Now! [Less]

    Scriptella ETL 0.9 Released

    Scriptella 0.9 is ready for download.
    This release introduced integration with JSR 223 (Scripting for the Java Platform)
    and drivers autodiscovery, based on users feedback, CSV and Text drivers were ... [More] significantly improved and of course Scriptella became even more faster. Other notable features and bug fixes:

    New syntax extension: ?{textfile 'filename/url' } to upload CLOBs from text files.
    Simplified dialect names matching
    Database migration template. etl-template Ant task.
    Support for bind variables/expressions in a href attribute of include element
    Since this release JDK 6 is required to build Scriptella
    We hope you will enjoy the new features. See change log for additional details.
    Make ETL easier - Download Scriptella Now! [Less]

    Scriptella ETL 0.8 Released

    Scriptella 0.8 is available.
    New and Notable Features and Bug Fixes:

    Working with dates in ${ ... } JEXL expressions
    Runnable and Callable façade for EtlExecutor.
    Mail provider.
    NULL not handled for CLOBs ... [More] and BLOBs.
    Fix Spring context propagation.
    Send output to the console if no output file URL was specified for Velocity and Text driver.
    Automatically convert windows DRIVE:/ paths to file:/ URL
    Upgraded to Janino 2.5.6
    Removed unused commons-logging classes from scriptella.jar
    We want to thank all the contributors for their patches and ideas! I've also created a project blog at Wordpress.
    Make ETL easier - Download Scriptella Now! [Less]

    Scriptella ETL 0.8 Released

    Scriptella 0.8 is available.
    New and Notable Features and Bug Fixes:

    Working with dates in ${ ... } JEXL expressions
    Runnable and Callable façade for EtlExecutor.
    Mail provider.
    NULL not handled for CLOBs ... [More] and BLOBs.
    Fix Spring context propagation.
    Send output to the console if no output file URL was specified for Velocity and Text driver.
    Automatically convert windows DRIVE:/ paths to file:/ URL
    Upgraded to Janino 2.5.6
    Removed unused commons-logging classes from scriptella.jar
    We want to thank all the contributors for their patches and ideas! I've also created a project blog at Wordpress.
    Make ETL easier - Download Scriptella Now! [Less]

    Scriptella ETL 0.7 Released

    I'm happy to announce the release of open source ETL and script execution tool Scriptella 0.7

    As far as I know it's the only Apache licensed ETL system, so it's perfect for building commercial solutions. As a bonus to this ... [More] release I've added several Scriptella examples to DZone Snippets.
    Make ETL easier - Download Scriptella Now! [Less]

Read all Scriptella ETL articles…

Download Page
84 downloads

Who uses Scriptella ETL?

Avatar Avatar Avatar

Who contributes to Scriptella ETL?

Avatar Anon32 Anon32
I'm a contributor

Who manages Scriptella ETL?

I'm a manager

Where in the world?



Related Projects by Tags

Apatar, Azuki Framework, benerator, livebookstore, XAware


Project Cost

This calculator estimates how much it would cost to hire a team to write this project from scratch. More »
Include
Codebase 24,935
Effort (est.) 6 Person Years
Avg. Salary $ year
$ 312,605