|
<< Click to Display Table of Contents >> 支持的数据源范围复制链接 |
1.支持的数据源类型
Yonghong Z-Suite支持连接多种类型的数据源，包括：
•读取本地文本文件作为文本数据源创建Excel数据集；
•连接关系型数据库生成SQL数据源；
•连接多维数据库生成多维数据源；
•连接其他目标如NoSQL数据库、服务器请求等生成其他数据源。
2.支持范围
数据源 |
默认驱动 |
驱动版本 |
默认URL |
|---|---|---|---|
ACESS |
sun.jdbc.odbc.JdbcOdbcDriver com.hxtt.sql.acess.AcessDriver |
jdk自带 |
jdbc:odbc: jdbc:Access:/// |
ANALYTICDB |
com.mysql.jdbc.Driver |
5.1.39 |
jdbc:mysql://<Databaseserver>:3306/<DatabaseName> |
CLICKHOUSE |
ru.yandex.clickhouse.ClickHouseDriver |
- |
jdbc:clickhouse://<Databaseserver>:8123/<DatabaseName> |
CTSDB |
- |
- |
http://<Databaseserver>:9200 |
DAMENG |
dm.jdbc.driver.DmDriver |
18 |
jdbc:dm://<Databaseserver>:5236 |
DATA MART |
g5.jdbc.GDriver |
- |
jdbc:yonghong:z |
DB2 |
com.ibm.db2.jcc.DB2Driver com.ibm.db2.jdbc.net.DB2Driver |
11.1 |
jdbc:db2://<Databaseserver>:50000/<DatabaseName> |
DERBY |
org.apache.derby.jdbc.ClientDriver org.apache.derby.jdbc.EmbeddedDriver |
10.14.2.0 |
jdbc:derby:<Databaseserver>:1527/<DatabaseName> |
ELASTIC SEARCH (JDBC连接） |
org.elasticsearch.xpack.sql.jdbc.EsDriver |
7.12.0 |
jdbc:es://http://<Databaseserver>:9200 |
FUSIONINSIGHT ELK |
org.postgresql.Driver |
9.1 |
jdbc:postgresql://<Databaseserver>:5432 |
FUSIONINSIGHT HD |
org.apache.hive.jdbc.HiveDriver |
1.1.0 |
jdbc:hive2://<Databaseserver>:10000 |
GAUSSDB 100 |
com.huawei.gauss.jdbc.ZenithDriver |
- |
jdbc:zenith:@<Databaseserver>:1888 |
GAUSSDB 200 |
org.postgresql.Driver com.huawei.causs200.jdbc.Driver |
9.1 |
jdbc:postgresql://<Databaseserver>:5432 jdbc:gaussdb://<Databaseserver>:5432 |
GBASE8A |
com.gbase.jdbc.Driver |
8.3.81.53 |
jdbc:gbase://<Databaseserver>:5258/<DatabaseName> |
GENERIC |
- |
- |
- |
GREENPLUM |
org.postgresql.Driver com.pivotal.jdbc.GreenplumDriver |
9.1 |
jdbc:postgresql://<Databaseserver>:5432 jdbc:pivotal:greenplum://<Databaseserver>:5432 |
HANA |
com.sap.db.jdbc.Driver |
1.9 |
jdbc:sap://<Databaseserver>:30015 |
HBASE |
org.appache.phoenix.queryserver.client.Driver org.appache.phoenix.jdbc.PhoenixDriver |
4.12.0 |
jdbc:phoenix:<Databaseserver>:8765;serialization=PROTOBUF |
HIVE |
org.apache.hive.jdbc.HiveDriver org.apache.hadoop.hive.jdbc.HiveDriver |
1.1.0 |
jdbc:hiver2://<Databaseserver>:10000 jdbc:hiver://<Databaseserver>:10000 |
HUAWEICLOUD DWS |
org.postgresql.Driver |
9.1 |
jdbc:postgresql://<Databaseserver>:5432 |
IMPALA |
com.cloudera.impala.jdbc41.Driver org.apache.hive.jdbc.HiveDriver |
- |
jdbc:impala://<Databaseserver>:21050/impala;auth=noSasl jdbc:hiver://<Databaseserver>:21050/impala;auth=noSasl |
INFORMIX |
com.informix.jdbc.IfxDriver |
3.00.JC3 |
jdbc:informix-sqli://<Databaseserver>:1533/ <DatabaseName>:INFORMIXSERVER=<DBSERVERNAME> |
KINGBASE |
com.kingbase8.Driver com.kingbase.Driver |
- |
jdbc:kingbase8://<Databaseserver>:54321/<DatabaseName> jdbc:kingbase://<Databaseserver>:54321/<DatabaseName> |
KYLIN |
org.apache.kylin.jdbc.Driver |
1.6.0 |
jdbc:kylin://<Databaseserver>:7070/<ProjectName> |
MAX COMPUTE |
com.aliyun.odps.jdbc.OdpsDriver |
- |
jdbc:odps:<Endpoint> |
MYSQL |
com.mysql.jdbc.Driver org.gjt.mm.mysql.Driver |
5.1.39 |
jdbc:mysql://<Databaseserver>:3306/<DatabaseName> |
ORACLE |
oracle.jdbc.driver.OracleDriver oracle.jdbc.OracleDriver |
14 |
jdbc:oracle:thin:@<Databaseserver>:1521:<sid>
|
POSTGRESQL |
org.postgresql.Driver |
9.1 |
jdbc:postgresql://<Databaseserver>:5432 |
PRESTO |
com.facebook.presto.jdbc.PrestoDriver |
0.152 |
jdbc:presto://<Databaseserver>:8080/hive/<DatabaseName> |
SPARK |
org.apache.hive.jdbc.HiveDriver org.apache.hadoop.hive.jdbc.HiveDriver |
1.1.0 |
jdbc:hiver2://<Databaseserver>:10000 jdbc:hiver://<Databaseserver>:10000 |
SQLSERVER |
com.microsoft.sqlserver.jdbc.SQLServerDriver com.microsoft.jdbc.sqlserver.SQLServerDriver |
41 |
jdbc:sqlserver://<Databaseserver>:1433;databaseName=<DatabaseName> jdbc:microsoft:sqlserver://<Databaseserver>:1433;databaseName=<DatabaseName> |
SYBASE IQ |
com.sybase.jdbc2.jdbc.SybDriver com.sybase.jdbc3.jdbc.SybDriver |
5.5 |
jdbc:sybase:Tds:<Databaseserver>:5000 |
TBDS |
org.apache.hive.jdbc.HiveDriver org.apache.hadoop.hive.jdbc.HiveDriver |
1.1.0 |
jdbc:hiver2://<Databaseserver>:10000 jdbc:hiver://<Databaseserver>:10000 |
TBDS OLAP |
com.facebook.presto.jdbc.PrestoDriver |
0.152 |
jdbc:presto://<Databaseserver>:8080/hive/<DatabaseName> |
TERADATA |
com.teradata.jdbc.TeraDriver |
4 |
jdbc:teradata://<Databaseserver> |
TRANSWARP |
org.apache.hive.jdbc.HiveDriver org.apache.hadoop.hive.jdbc.HiveDriver |
1.1.0 |
jdbc:hiver2://<Databaseserver>:10000 jdbc:hiver://<Databaseserver>:10000 |
VERTICA |
com.vertica.jdbc.Driver com.vertica.Driver |
7.1.2 |
jdbc:vertica://<Databaseserver>:5433/<DatabaseName> |
2.2 多维数据源&其他数据源
数据源 |
url |
|---|---|
ORACLE ESSBASE |
jdbc:xmla:Server=http://<Databaseserver>:13080/aps/XMLA |
SAP BW |
jdbc:xmla:Server=http://<Databaseserver>:8000/sap/bw/xml/soap/xmla(MDX连接） |
SSAS |
jdbc:xmla:Server=http://<Databaseserver>:80/olap/msmdpump.dll |
MONGO |
mongodb://<Databaseserver>:27017 |
NEO4J |
bolt://<Databaseserver>:7687(驱动：org.neo4j.driver.Driver) |
RESTful |
请求地址，无固定格式 |