Latest feature:

• 2024-11-21 provides privateKeyFile connection property to assign the private key file for Sftp protocol to build public-key authentication without password.
• 2024-03-18 supports OFFSET clause and FETCH clause.
• 2023-04-01 supports SWITCH function.
• 2022-04-16 supports FTP with explicit SSL/TLS encryption (FTPES).
• 2022-04-16 supports FTP with implicit SSL/TLS (FTPS).
• 2022-02-14 supports CTE syntax (common table expression).
• 2022-01-26 provides SAMBA support for Azure file share.
• 2021-12-15 provides function SPLIT_PART(string, delimiter,field_number) .
• 2021-03-24 provides dynamical column, ILIKE pattern, expression calculation for PIVOT table and UNPIVOT table.
• 2021-02-08 supports seamlessly files and directories in Seven Zip file formats(.7z) in jdbc url and sql.
• 2021-01-06 provides new table object(XML_TABLE, JSON_TABLE, VALUES_TABLE) for ETL.

2020-12-30 JSON v1.0 JDBC4.3 Package(1652KB) JDBC4.2 Package(1656KB) JDBC4.1 Package(1644KB) JDBC4.0 Package(1640KB) JDBC3.0 Package(1510KB) JDBC2.0 Package(1468KB) JDBC1.2 Package(1488KB)

• supports XPATH
• can convert automatically one complicated element/object into a relational table.
• supports JSON5's comment syntax(/* */ or //)
• supports seamlessly url(http, ftp) database in jdbc url and sql.
• supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
• supports seamlessly files and directories in ZIP, GZIP, TAR and BZ2 file formats(.ZIP, .JAR, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
• supports all of four transaction levels.
• supports CREATE DATABASE, CREATE CATALOG, CREATE TABLE, DROP TABLE, ALTER TABLE, CREATE VIEW, DROP VIEW, SELECT, INSERT, UPDATE, and DELETE sql.
• Development Documentation is available.
• supports JDB4.2, JDBC4.1, JDBC4.0, JDBC3.0, JDBC2.0 and JDBC1.2.