支持的数据源范围

<< Click to Display Table of Contents >>

当前位置:  数据准备 > 数据源 

支持的数据源范围

复制链接

1.支持的数据源类型

Yonghong Z-Suite支持连接多种类型的数据源,包括:

读取本地文本文件作为文本数据源创建Excel数据集;

连接关系型数据库生成SQL数据源;

连接多维数据库生成多维数据源;

连接其他目标如NoSQL数据库、服务器请求等生成其他数据源。

2.支持范围

2.1 SQL数据源

数据源

默认驱动

驱动版本

默认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

请求地址,无固定格式