JDBC Drivers

datasqill provides free JDBC drivers that can be used freely. These drivers aim to enable the use of the "Transfer between DBs" module for reading data that does not actually reside in a database and for which there are therefore no JDBC drivers. The following drivers are currently implemented:

• JDBC driver for CSV files
• JDBC driver for Excel files
• JDBC driver for JSON files
• JDBC driver for XML files
• JDBC driver for YAML files
• JDBC driver for LDAP servers
• JDBC driver for Salesforce
• JDBC driver for Eloqua
• JDBC driver for SAP

All drivers use an SQL parser, so the SQL language scope for these sources is approximately the same.

For use with datasqill, the drivers also provide metainformation (or system tables). For example, with the file-based JDBC drivers, files in a specific directory can be queried as metadata in the Loop Query in the module and iterated over via the Loop Query. The SQL in the Loop query thus selects from the metadata (or system tables) and the SQL in the action then selects from the source object.

The drivers currently only support reading via SQL SELECT statement.