Caigen Entry JDBC Driver was created to allow customers to perform SQL operations upon Microsoft Entry data source files.
This supports information mining on storage data source, compressed data source(.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2), SAMBA data source(smb), and url data source(http, https, file transfer protocol).
Here are a few key features of “Caigen Access JDBC Driver”:
· It supports ANSI SQL 92 standard, and more than 230 sql functions. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, GROUP_CONCAT, GROUPING, WITH ROLLUP, WITH CUBE, multiple-row VALUES table, PIVOT table, UNPIVOT table, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery.
· It facilitates dealings.
Needs:
· Entry
Limitations:
· Limited to 50 queries, 5000 series for each query