数据库兼容

1. 数据源支持常规、国产、大数据、Nosql等30多种数据库

积木报表提供强大引擎，支持以SQL的方式去查询csv、mogodb等非物理数据库。

数据库	支持
MySQL	√
Oracle、Oracle9i	√
SqlServer、SqlServer2012	√
PostgreSQL	√
DB2、Informix	√
MariaDB	√
SQLite、Hsqldb、Derby、H2	√
达梦、人大金仓、神通	√
华为高斯、虚谷、瀚高数据库、 TDengine 涛思数据	√
阿里云PolarDB、PPAS、HerdDB	√
Hive、HBase、CouchBase	√
导入Excel、csv、json文件数据集	√
SQLite、TiDB、Doris、clickhouse、 MongoDB-BI	√
elasticsearch、mogodb	√

2. 添加其他数据库的maven依赖，例如oracle

<!--  sqlserver-->
<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>sqljdbc4</artifactId>
    <version>4.0</version>
    <scope>runtime</scope>
</dependency>
<!-- oracle驱动 -->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>
    <scope>runtime</scope>
</dependency>
<!-- postgresql驱动 -->
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.6</version>
    <scope>runtime</scope>
</dependency>
<!-- 达梦驱动 -->
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>DmJdbcDriver18</artifactId>
    <version>1.0</version>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>DmDialectForHibernate</artifactId>
    <version>5.3</version>
    <scope>runtime</scope>
</dependency>
<!-- sqlite -->
<dependency>
    <groupId>org.xerial</groupId>
    <artifactId>sqlite-jdbc</artifactId>
    <version>3.7.2</version>
    <scope>runtime</scope>
</dependency>
<!--hsqldb-->
<dependency>
    <groupId>org.hsqldb</groupId>
    <artifactId>hsqldb</artifactId>
    <version>2.2.8</version>
    <scope>runtime</scope>
</dependency>
<!--h2-->
<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.4.197</version>
    <scope>runtime</scope>
</dependency>
<!--derby-->
<dependency>
    <groupId>org.apache.derby</groupId>
    <artifactId>derbyclient</artifactId>
    <version>10.11.1.1</version>
    <scope>runtime</scope>
</dependency>
<!--db2-->
<dependency>
    <groupId>com.ibm.db2</groupId>
    <artifactId>jcc</artifactId>
    <version>11.5.0.0</version>
    <scope>runtime</scope>
</dependency>
<!--神通-->
<dependency>
    <groupId>com.csicit.thirdparty</groupId>
    <artifactId>oscar</artifactId>
    <version>1.0.1</version>
    <scope>runtime</scope>
</dependency>
<!--人大金仓-->
<dependency>
    <groupId>kingbase</groupId>
    <artifactId>kingbase8</artifactId>
    <version>8</version>
    <scope>runtime</scope>
</dependency>
<!--clickhouse-->
<dependency>
    <groupId>com.clickhouse</groupId>
    <artifactId>clickhouse-jdbc</artifactId>
    <version>0.6.5</version>
</dependency>
<!--TDengine-->
<dependency>
    <groupId>com.taosdata.jdbc</groupId>
    <artifactId>taos-jdbcdriver</artifactId>
    <version>3.3.3</version>
</dependency>