Font size:
Scriptella ETL Drivers Matrix
This document describes Scriptella Drivers supported by Scriptella.
See also the
Javadoc
for the built-in drivers.
JDBC Bridge Drivers
Scriptella providers a set of built-in drivers for popular databases, see also JDBC Bridge Javadoc for common properties and behaviour.
Note
Although usage of JDBC adapters is recommended you are free to use any JDBC compliant driver.
| Adapter Name | Scriptella 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 | This driver allows to work with JNDI-bound datasource connections, useful in J2EE environment | |
| Microsoft SQL Server Database | scriptella.driver.mssql.Driver | com.microsoft.sqlserver.jdbc.SQLServerDriver | This driver works with Microsoft SQL Server 2005, Microsoft SQL Server 2000 JDBC drivers and also allows to use 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 ODBC driver. | |
| Oracle Database | scriptella.driver.oracle.Driver | oracle.jdbc.driver.OracleDriver | Built-in Scriptella driver for Oracle. The following extra features supported:
|
|
| PostgreSQL Database | scriptella.driver.postgresql.Driver | org.postgresql.Driver | ||
| Spring Framework | scriptella.driver.spring.Driver | Any JDBC driver | This driver allows to work with
Spring
managed datasource connections, useful in Spring Framework
projects.
The driver requires scriptella.driver.spring.EtlExecutorBean to be used in 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 | This driver allows you to interact with Microsoft Excel spreadsheets using SQL statements. |
Non-JDBC Drivers
| Adapter Name | Scriptella Driver Name | Notes |
|---|---|---|
| Autodiscovery | scriptella.driver.auto.Driver | Automatically discovers a necessary driver based on the specified url. |
| CSV | scriptella.driver.csv.Driver | The driver to write and query CSV files. |
| Janino | scriptella.driver.janino.Driver | This driver allows embedding of Java code into <query> and <script> elements. |
| JEXL | scriptella.driver.jexl.Driver | Allows usage of JEXL scripts in <query> and <script> elements. |
| LDAP | scriptella.driver.ldap.Driver | This driver allows executing LDIF scripts and search filter queries. |
| Lucene | scriptella.driver.lucene.Driver | This driver allows search queries through lucene indexed data. |
| MongoDB | org.scriptella.mongodb.Driver | Provides integration of MongoDB with Scriptella. |
| scriptella.driver.mail.Driver | Allows sending E-Mails via SMTP. | |
| javax.script bridge | scriptella.driver.script.Driver | Provides support for JSR 223 compatible scripting languages like JavaScript, JRuby, Grovy etc. See JSR-223 script engines project for the list of supported languages. |
| Scriptella driver | scriptella.driver.scriptella.Driver | Driver for running Scriptella ETL files. Similar to Ant's <ant> task, i.e. it is suitable for splitting large ETL files into sub-projects. |
| Text | scriptella.driver.text.Driver | The driver for working with text data. It supports regular expressions syntax for quering and ant style property expansion in outputted text files. |
| Velocity | scriptella.driver.velocity.Driver | This driver allows to integrate velocity templates into script files. |
| vtd-xml | scriptella.driver.vtdxml.Driver | Implementation of vtd-xml as xpath driver for Scriptella. |
| XPath | scriptella.driver.xpath.Driver | This driver allows querying XML files with XPath expressions. |
by Fyodor Kupolov
1.0