Scriptella: Difference between revisions

Revision as of 03:53, 23 June 2025

Latest revision as of 12:30, 23 June 2025

Line 10:

| operating_system = [[Cross-platform]]

| genre = [[Extract transform load|ETL]], [[Data migration]] and [[SQL]].

| license = [[Apache Software License]]

| website = {{URL|https://scriptella.org/}}

}}

{{Portal|Free and open-source software}}

'''Scriptella''' is an open source [[Extractextract transform load|ETL]] (Extract-Transform-LoadETL)]] 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.<ref>{{cite web

| url=https://www.infoworld.com/article/2160447/groovy-etls-with-scriptella.html

| title=Groovy ETLs with Scriptella

Line 31:

==Features==

* '''Simple XML syntax''' for scripts. Add dynamics to your existing SQL scripts by creating a thin wrapper XML file:<syntaxhighlight lang="xml">

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

</syntaxhighlight>

* Support for multiple datasources (or multiple connections to a single database) in an ETL file.

Line 52:

* Built-in adapters for popular databases for a tight integration. Support for any database with JDBC/[[Open Database Connectivity|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|JSR 223 (Scripting for the Java Platform)]] compatible languages.

* Built-Inin [[Comma-separated values|CSV]], TEXT, [[XML]], [[Lightweight Directory Access Protocol|LDAP]], [[Apache Lucene|Lucene]], [[Apache Velocity|Velocity]], JEXL and Janino providers. Integration with [[Java EE]], [[Spring framework|Spring Framework]], [[Java Management Extensions|JMX]] and [[JNDI]] for enterprise ready scripts.

==Further reading==

* {{cite book |last1=Biswas |first1=Neepa |last2=Sarkar |first2=Anamitra |last3=Mondal |first3=Kartick Chandra |chapter=Empirical Analysis of Programmable ETL Tools |title=Computational Intelligence, Communications, and Business Analytics |series=Communications in Computer and Information Science |date=2019 |volume=1031 |pages=267–277 |doi=10.1007/978-981-13-8581-0_22 |chapter-url=https://link.springer.com/chapter/10.1007/978-981-13-8581-0_22 |access-date=31 March 2025 |publisher=Springer |isbn=978-981-13-8580-3 |language=en}}

* {{cite book |author1=Information Resources Management Association |author1-link=Information Resources Management Association |title=Information Resources Management: Concepts, Methodologies, Tools and Applications |date=30 April 2010 |publisher=Information Science Reference |isbn=978-1-61520-966-8 |pages=630, 642 |url=https://books.google.com/books?id=zIdVXq5BLOMC |access-date=31 March 2025 |language=en}}

== References ==

<references/>

==External links==

Line 67 ⟶ 69:

[[Category:Data warehousing products]]

[[Category:Data management]]

== References ==

<references/>

{{compu-stub}}