Scriptella

Scriptella
Stable release 1.1 / 28 December 2012
Operating system Cross-platform
Type ETL, Data migration and SQL.
License Apache Software License
Website scriptella.javaforge.com

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

Potential users should be aware that Scriptella does not offer any graphical user interface.

Typical use

Features

      <!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>

External links