Scriptella drivers matrix

Built-in and community drivers for databases, files, directories, scripting languages, and application frameworks. See also the driver package Javadoc.

JDBC bridge drivers

Scriptella provides built-in adapters for popular databases. See the JDBC bridge Javadoc for common properties and behaviour.

Adapter Driver name Native driver Notes
IBM AS/400 Database scriptella.driver.as400.Driver com.ibm.as400.access.AS400JDBCDriver
CUBRID Database scriptella.driver.cubrid.Driver cubrid.jdbc.driver.CUBRIDDriver
DB2 Database scriptella.driver.db2.Driver com.ibm.db2.jcc.DB2Driver
Derby Database scriptella.driver.derby.Driver org.apache.derby.jdbc.ClientDriver; org.apache.derby.jdbc.EmbeddedDriver
H2 Database scriptella.driver.h2.Driver org.h2.Driver
HSQLDB scriptella.driver.hsqldb.Driver org.hsqldb.jdbcDriver
JNDI scriptella.driver.jndi.Driver Any JDBC driver Works with JNDI-bound data source connections, useful in Java EE environments.
Microsoft SQL Server Database scriptella.driver.mssql.Driver com.microsoft.sqlserver.jdbc.SQLServerDriver Works with Microsoft SQL Server 2005 and 2000 JDBC drivers, and also allows the jTDS JDBC driver for Microsoft SQL Server.
MySQL Database scriptella.driver.mysql.Driver com.mysql.jdbc.Driver
JDBC-ODBC Bridge scriptella.driver.odbc.Driver sun.jdbc.odbc.JdbcOdbcDriver JDBC-ODBC bridge driver. The bridge implements JDBC for any database with an ODBC driver.
Oracle Database scriptella.driver.oracle.Driver oracle.jdbc.driver.OracleDriver Built-in Scriptella driver for Oracle, including simplified handling of PL/SQL blocks.
PostgreSQL Database scriptella.driver.postgresql.Driver org.postgresql.Driver
Spring Framework scriptella.driver.spring.Driver Any JDBC driver Works with Spring-managed data source connections. Requires scriptella.driver.spring.EtlExecutorBean in the Spring configuration.
Sybase Database scriptella.driver.sybase.Driver com.sybase.jdbc3.jdbc.SybDriver
JDBC Driver for Excel Spreadsheets scriptella.driver.xls.Driver net.pcal.sqlsheet.XlsDriver Interact with Microsoft Excel spreadsheets using SQL statements.

Non-JDBC drivers

Adapter Driver name Notes
Autodiscovery scriptella.driver.auto.Driver Automatically discovers a suitable driver based on the specified URL.
CSV scriptella.driver.csv.Driver Write and query CSV files.
Janino scriptella.driver.janino.Driver Embed Java code in <query> and <script> elements.
JEXL scriptella.driver.jexl.Driver Use JEXL scripts in <query> and <script> elements.
LDAP scriptella.driver.ldap.Driver Execute LDIF scripts and search-filter queries.
MongoDB org.scriptella.mongodb.Driver Integrates MongoDB with Scriptella.
Mail scriptella.driver.mail.Driver Send email via SMTP.
javax.script bridge scriptella.driver.script.Driver Supports JSR 223-compatible scripting languages such as JavaScript, JRuby, and Groovy. Release 1.3 bundles Rhino for JavaScript; prefer language=rhino. Other engines depend on the runtime and libraries on the classpath.
Scriptella driver scriptella.driver.scriptella.Driver Run nested Scriptella ETL files. Similar to Ant's <ant> task, useful for splitting large ETL files into sub-projects.
Shell scriptella.driver.shell.Driver Execute operating-system shell commands as scripts or queries. Queries export each output line as a row. Runs with the permissions of the Scriptella process.
Text scriptella.driver.text.Driver Work with text data. Supports regular expressions for querying and Ant-style property expansion in output files.
Velocity scriptella.driver.velocity.Driver Integrate Velocity templates into script files.
vtd-xml scriptella.driver.vtdxml.Driver Community vtd-xml XPath driver for Scriptella.
XPath scriptella.driver.xpath.Driver Query XML files with XPath expressions.