Scriptella

Scriptella

Infobox Software
name = Scriptella

latest_release_version = 1.0 RC
latest_release_date = 2 April 2008
operating_system = Cross-platform
genre = ETL, Data migration and SQL.
license = Apache Software License
website = [http://scriptella.javaforge.com 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.

Typical use

* Database migration.
* Database creation/update scripts.
* Cross-database ETL operations, import/export.
* Alternative for Ant task.
* Automated database schema upgrade.

Features

* 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 file blobs and JDBC escaping.
* Performance. 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 elements
* Transactional execution
* Error handling via elements
* Conditional scripts/queries execution (similar to Ant if/unless attributes but more powerful)
* Easy-to-Use as a standalone tool or Ant task. 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 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.

External links

* [http://scriptella.javaforge.com Scriptella ETL Site]
* [http://jroller.com/page/ejboy Scriptella ETL Author's Blog]
* [http://snippets.dzone.com/tag/scriptella Example code snippets for Scriptella ETL]
*Ohloh project|id=4526|name=Scriptella ETL


Wikimedia Foundation. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Datenmigration — Unter Migration versteht man im Rahmen der Informationstechnik den Umstieg eines wesentlichen Teils der eingesetzten Software beziehungsweise den Transfer von Daten aus einer Umgebung in eine andere, sowie die Umstellung von Hardware einer… …   Deutsch Wikipedia

  • Deprecated — Unter Migration versteht man im Rahmen der Informationstechnik den Umstieg eines wesentlichen Teils der eingesetzten Software beziehungsweise den Transfer von Daten aus einer Umgebung in eine andere, sowie die Umstellung von Hardware einer… …   Deutsch Wikipedia

  • Softwaremigration — Unter Migration versteht man im Rahmen der Informationstechnik den Umstieg eines wesentlichen Teils der eingesetzten Software beziehungsweise den Transfer von Daten aus einer Umgebung in eine andere, sowie die Umstellung von Hardware einer… …   Deutsch Wikipedia

  • ETL — Saltar a navegación, búsqueda ETL son las siglas en inglés de Extraer, Transformar y Cargar (Extract, Transform and Load). Es el proceso que permite a las organizaciones mover datos desde múltiples fuentes, reformatearlos y limpiarlos, y… …   Wikipedia Español

  • ETL — (от англ. Extract, Transform, Load  дословно «извлечение, преобразование, загрузка»)  один из основных процессов в управлении хранилищами данных, который включает в себя: извлечение данных из внешних источников; их трансформация и… …   Википедия

  • List of open source software packages — This is a list of open source software packages: computer software licensed under an open source license. Software that fits the Free software definition may be more appropriately called free software; the GNU project in particular objects to… …   Wikipedia

  • Extract, transform, load — Extract, transform and load (ETL) is a process in database usage and especially in data warehousing that involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into… …   Wikipedia

  • JavaForge — JavaForge.com is a free open source software development community and hosting portal for open source Java projects. It hosts software development services such as Project related Web hosting, Document Management, Wiki, Forum, Online chat, Issue… …   Wikipedia

  • ETL-Prozess — ETL: Datenfluss und unterstützende Programme Extract, Transform, Load (ETL) ist ein Prozess, bei dem Daten aus mehreren ggf. unterschiedlich strukturierten Datenquellen in einer Zieldatenbank vereinigt werden. Extraktion der relevanten Daten aus… …   Deutsch Wikipedia

  • Migration (Informationstechnik) — Unter Migration (von lateinisch migratio für „Wanderung“ oder „Übersiedlung“) werden im Rahmen der Informationstechnik verschiedenartige Umstellungsprozesse in Datenverarbeitungssystemen verstanden. Gelegentlich werden Migration und Portierung… …   Deutsch Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”