| 数据源类型 | 版本 | 驱动程序类 | 连接字符串 |
|---|
| aliyun AnalyticDB |
| com.mysql.jdbc.Driver | jdbc:mysql://<servername>/<database>?useUnicode=true&characterEncoding=UTF-8&engine=MPP |
| aliyun MaxCompute |
| com.aliyun.odps.jdbc.OdpsDriver | jdbc:odps:<endpoint>?project=<project>&charset=UTF-8 |
| ClickHouse |
| ru.yandex.clickhouse.ClickHouseDriver | jdbc:clickhouse://<servername>:8123/<database>?socket_timeout=1000000 |
| DB2 |
| com.ibm.db2.jcc.DB2Driver | jdbc:db2://<servername>:<port>/<database> |
| GBase 8S V8.4 |
| com.informix.jdbc.IfxDriver | jdbc:informix-sqli://<host>:9088/<database>:INFORMIXSERVER=<servicename>;CLIENT_LOCALE=zh_cn.utf8;DB_LOCALE=zh_cn.utf8;NEWCODESET=utf8,8859-1,819 |
| GBase 8S V8.8 |
| com.informix.jdbc.IfxDriver | jdbc:informix-sqli://<host>:9088/<database>:INFORMIXSERVER=<servicename>;CLIENT_LOCALE=zh_cn.utf8;DB_LOCALE=zh_cn.utf8;NEWCODESET=utf8,8859-1,819 |
| Gauss100 |
| com.huawei.gauss.jdbc.ZenithDriver | jdbc:zenith:@<servername>:<port>?useSSL=true |
| Gauss200 |
| com.huawei.gauss200.jdbc.Driver | jdbc:gaussdb://<servername>:25308/<dbName> |
| Gbase 8A |
| com.gbase.jdbc.Driver | jdbc:gbase://<servername>:<port>/<dbName> |
| Greenplum |
| org.postgresql.Driver | jdbc:postgresql://<servername>:5432/<dbName> |
| HANA |
| com.sap.db.jdbc.Driver | jdbc:sap://<servername>:30015?reconnect=true |
| Hadoop_Hive |
| org.apache.hive.jdbc.HiveDriver | jdbc:hive2://<servername>:10000/default |
| Huawei FusionInsight HD |
| org.apache.hive.jdbc.HiveDriver | jdbc:hive2://<zkServer1>:24002,<zkServer2>:24002,<zkServer3>:24002/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;sasl.qop=auth-conf;auth=KERBEROS;principal=hive/hadoop.hadoop.com@HADOOP.COM |
| IMPALA |
| com.cloudera.impala.jdbc41.Driver | jdbc:impala://<servername>:<port>/<database> |
| Infobright |
| com.mysql.jdbc.Driver | jdbc:mysql://<servername>:<port>/<database>?useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=GBK&zeroDateTimeBehavior=convertToNull |
| Informix |
| com.informix.jdbc.IfxDriver | jdbc:informix-sqli://<servername>:1526/<database>:INFORMIXSERVER=<InformixServer>;NEWLOCALE=zh_cn,en_us;NEWCODESET=GBK,8859-1,819 |
| Kingbase |
| com.kingbase.Driver | jdbc:kingbase://<servername>:54321/<dbName> |
| KingbaseAnalytics |
| com.kingbase.kingbaseanalyticsdb.Driver | jdbc:kingbaseanalyticsdb://<servername>:<port>/<database> |
| Kylin |
| org.apache.kylin.jdbc.Driver | jdbc:kylin://<servername>:<port>/<projectName> |
| MS SQL Server |
| net.sourceforge.jtds.jdbc.Driver | jdbc:jtds:sqlserver://<servername>:1433;DatabaseName=<database> |
| MySQL |
| com.mysql.jdbc.Driver | jdbc:mysql://<servername>:<port>/<database>?useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=GBK&zeroDateTimeBehavior=convertToNull |
| OBASE |
| com.mysql.jdbc.Driver | jdbc:mysql://<servername>/<database>?useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=GBK&zeroDateTimeBehavior=convertToNull |
| Oracle |
| oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@<ip>:1521/<serviceName> |
| Oracle TimesTen |
| com.timesten.jdbc.TimesTenClientDriver | jdbc:timesten:client:dsn={dsnname} |
| PostgreSQL |
| org.postgresql.Driver | jdbc:postgresql://<servername>:5432/<dbName> |
| Presto |
| com.facebook.presto.jdbc.PrestoDriver | jdbc:presto://<servername>:38080/<database> |
| ShenTong |
| com.oscar.Driver | jdbc:oscar://<servername>/<database> |
| Smartbi JDBC for Excel |
| smartbi.jdbc.ExcelDriver | jdbc:smartbi:excel:<filename or fileresource:id> |
| Smartbi Jdbc4Olap |
| smartbi.jdbc.OlapDriver | http://<servername>/smartbixmla/XmlaHandler.ashx |
| Spark SQL |
| org.apache.hive.jdbc.HiveDriver | jdbc:hive2://<servername>:10000/default |
| Sybase |
| com.sybase.jdbc3.jdbc.SybDriver | jdbc:sybase:Tds:<servername>:<port>/<database>?CHARSET=cp936 |
| Teradata_V12 |
| com.teradata.jdbc.TeraDriver | jdbc:teradata://<servername>/DataBase=<dbName>,LOB_SUPPORT=off,client_charset=gbk |
| Teradata_V13及其以上 |
| com.ncr.teradata.TeraDriver | jdbc:teradata://<servername>/DataBase=<dbName>,LOB_SUPPORT=off,client_charset=gbk |
| Vertica |
| com.vertica.jdbc.Driver | jdbc:vertica://<servername>:5433/<database> |
| 星环 |
| org.apache.hive.jdbc.HiveDriver | jdbc:hive2://<servername>:10000/default |
| 达梦7 |
| dm.jdbc.driver.DmDriver | jdbc:dm://<servername>:5236/<database> |
| 达梦6 |
| dm6.jdbc.driver.DmDriver | jdbc:dm6://<servername>:5236/<database> |
| Other |
|
|
|
| MongoDB |
| smartbi.jdbc.MongoDriver | jdbc:smartbi:mongo:<server>:<port>/<dbName> |
| Tinysoft |
| smartbi.jdbc.tinysoft.TinysoftDriver | jdbc:smartbi:tsserver://<servername>:1099/ |
