Scriptella
Encyclopedia
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
.
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
Graphical user interface
In computing, a graphical user interface is a type of user interface that allows users to interact with electronic devices with images rather than text commands. GUIs can be used in computers, hand-held devices such as MP3 players, portable media players or gaming devices, household appliances and...
.
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 JDBCJava Database ConnectivityJava DataBase Connectivity, commonly referred to as JDBC, is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases...
features , e.g. parameters in SQL including file blobs and JDBC escaping. - Performance. Performance and low memory usage are one of our 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/ODBCOpen Database ConnectivityIn computing, ODBC is a standard C interface for accessing database management systems . The designers of ODBC aimed to make it independent of database systems and operating systems...
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 CSVComma-separated valuesA comma-separated values file stores tabular data in plain-text form. As a result, such a file is easily human-readable ....
, TEXT, XMLXMLExtensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....
, LDAPLightweight Directory Access ProtocolThe Lightweight Directory Access Protocol is an application protocol for accessing and maintaining distributed directory information services over an Internet Protocol network...
, Lucene, Velocity, JEXL and Janino providers. Integration with Java EE, Spring Framework, JMX and JNDI for enterprise ready scripts.