Scriptella

Scriptella
Stable release
1.1 / 28 December 2012
Written inJava
Operating systemCross-platform
TypeETL, Data migration and SQL.
LicenseApache License
Websitescriptella.org
Repositorygithub.com/scriptella/scriptella-etl

Scriptella is an open source extract transform load (ETL) and script execution tool written in Java. It allows the use of SQL or another scripting language suitable for the data source to perform required transformations.[1] Scriptella does not offer any graphical user interface.

Typical use

  • Database migration.
  • Database creation/update scripts.
  • Cross-database ETL operations, import/export.
  • Alternative for Ant <sql> task.
  • Automated database schema upgrade.[2]

Features

  • Simple XML syntax for scripts. Add dynamics to your existing SQL scripts by creating a thin wrapper XML file:
    <!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>
  • Support for multiple datasources (or multiple connections to a single database) in an ETL file.
  • Support for many useful JDBC features, e.g. parameters in SQL including file blobs and JDBC escaping.
  • Performance and low memory usage are one of the primary goals.
  • Support for evaluated expressions and properties (JEXL syntax)
  • Support for cross-database ETL scripts by using <dialect> elements
  • Transactional execution
  • Error handling via <onerror> elements
  • Conditional scripts/queries execution (similar to Ant if/unless attributes but more powerful)
  • Easy-to-Use as a standalone tool or Ant task, without deployment or installation.
  • 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 and integration with scripting languages. Out of the box support for JSR 223 (Scripting for the Java Platform) compatible languages.
  • 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.

Further reading

  • Biswas, Neepa; Sarkar, Anamitra; Mondal, Kartick Chandra (2019). "Empirical Analysis of Programmable ETL Tools". Computational Intelligence, Communications, and Business Analytics. Communications in Computer and Information Science. Vol. 1031. Springer. pp. 267–277. doi:10.1007/978-981-13-8581-0_22. ISBN 978-981-13-8580-3. Retrieved 31 March 2025.
  • Information Resources Management Association (30 April 2010). Information Resources Management: Concepts, Methodologies, Tools and Applications. Information Science Reference. pp. 630, 642. ISBN 978-1-61520-966-8. Retrieved 31 March 2025.

References

  1. ^ Andrew Glover (2010-09-28). "Groovy ETLs with Scriptella". InfoWorld. Retrieved 2025-04-07.
  2. ^ "Scriptella: Typical use". 2019-10-04.
Stub icon

This free and open-source software article is a stub. You can help Wikipedia by adding missing information.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.