反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

Range of data connection support

  • Recent Updates: April 15, 2022

    • 1. Types of data support

    FineBI supports multiple data sources:

    1) Directly connect to the database via JDBC. Refer to section 2.1 for the supported database types.

    2) Use the server dataset to establish a remote connection through the Finereport designer.

    3) Use a custom type of data source program dataset.

    4) Install the JSON dataset used by the plugin.

    2. Range

    2.1 JDBC

    The databases supported by BI and the corresponding connection attribute values are shown in the following table:

    Data source

    Version

    Driver

    URL

    Pivotal Greenplum Database

    5.0

    「Driver 1」org.postgresql.Drive

    「Driver 2」com.pivotal.jdbc.GreenplumDriver

    「Corresponding URL 1 」 jdbc:postgresql://ip:port/dbname

     「Corresponding  URL 2 」jdbc:pivotal:greenplum://ip:port;DatabaseName=xxx

    HP Vertica

    Vertica_7.2.1

    com.vertica.jdbc.Driver 

     jdbc:vertica://ip:port/databaseName 

    Amazon Redshift


    「Driver 1 」com.amazon.redshift.jdbc4.Driver 

    「Driver 2 」com.amazon.redshift.jdbc41.Driver

    「Driver 1 」jdbc:redshift://endpoint:port/database

     「Driver 2 」jdbc:postgresql://endpoint:port/database

    IBM DB2

     DB2 V9.7；DB2_8.2；

    com.ibm.db2.jcc.DB2Driver

    jdbc:db2://ip:port/dbname

    Apache Impala

    impala 2.3；impala 2.9；impala 2.10；

    com.cloudera.impala.jdbc41.Driver

    com.cloudera.impala.jdbc41.Driver

    INFORMIX

    11.7；11.5；  

    com.informix.jdbc.IfxDriver

     jdbc:informix-sqli://ip:port/database:INFORMIXSERVER=server 

    Apache Phoenix

    1.2

    org.apache.phoenix.jdbc.PhoenixDriver

    jdbc:phoenix:ip:port/dbname

    Microsoft SQL Server

    SQL Server 2005、2008、2012、2014、2016、2000；

     com.microsoft.sqlserver.jdbc.SQLServerDriver   

     jdbc:sqlserver://ip:port;databaseName=xxx  

    ADS

     2.0

    com.mysql.jdbc.Driver

      jdbc:mysql://ip:port/my_ads_db

    APACHE KYLIN

    1.5.0；2.2；

    org.apache.kylin.jdbc.Driver 

    jdbc:kylin://ip:port/kylin_project_name 

    MySQL

    MySQL 5.1.73、MySQL 5.5、MySQL 5.6、MySQL 5.7

    「Driver 1 」com.mysql.jdbc.Driver

    「Driver 2 」org.gjt.mm.mysql.Driver

    jdbc:mysql://ip:port/dbname

    DERBY

    10.10.1.1

    org.apache.derby.jdbc.ClientDriver  

    jdbc:derby://ip:port/E:\\derbydatabase\\aaa 

    Oracle

     oracle 9.2.X、oracle 10.2.0、oracle 11.2.0、oracle 12.1.0；

    oracle.jdbc.driver.OracleDriver  

    「Driver 1 」 jdbc:oracle:thin:@ip:port:sid_name

     「Driver 2 」jdbc:oracle:thin:@//ip:port/service_name

    Postgresql

    postgresql_9.5.0；  

    org.postgresql.Driver 

    jdbc:postgresql://ip:port/dbname

    Gbase 8A

    Gbase 8A (based on mysql)

    com.gbase.jdbc.Driver

     jdbc:gbase://ip:port/dbname

    Gbase 8S

    Gbase 8S (based on infomix)

    com.gbasedbt.jdbc.IfxDriver

     jdbc:gbasedbt-sqli://{host}:{port}/{database}  

    Gbase 8T

    Gbase 8T (based on informix)

    com.informix.jdbc.IfxDriver

    jdbc:informix-sqli://ip:port/database:INFORMIXSERVER=server 

    FusionInsight elk

    V100R002C80

    org.postgresql.Driver

      jdbc:postgresql://hostname:port/dbname

    Hadoop Hive

    Hadoop_2.6.3_Hive_1.2.1；hive_1.1；hive2.3；hive2.1.1；

    org.apache.hive.jdbc.HiveDriver 

     jdbc:hive2://ip:port/dbname

    Hbase

    1.2

      org.apache.phoenix.jdbc.PhoenixDriver 

       jdbc:phoenix:ip:port/dbname

    KINGBASE

     KingbaseES 7.1  

    com.kingbase.Driver    

      jdbc:kingbase://ip:port/dbname 

    Presto

     Presto_0.169 

     com.facebook.presto.jdbc.PrestoDriver

     jdbc:presto://host:port/catalog 

    SAP Sybase

     SAP Sybase ASE 16.0；SAP Sybase IQ 16.0；

    com.sybase.jdbc4.jdbc.SybDriver

      jdbc:sybase:Tds:ip:port/dbname  

    SPARK

    1.6.0；2.1；2.3；

    org.apache.hive.jdbc.HiveDriver 

      jdbc:hive2://ip:port/dbname  

    TeraData

    Teradata_16.10；

    com.ncr.teradata.TeraDriver   

    jdbc:teradata://localhost/CLIENT_CHARSET=EUC_CN,    TMODE=TERA,CHARSET=ASCII,LOB_SUPPORT,database=xxx

    TRANSWARP INCEPTOR

    TRANSWARP INCEPTOR _4.6.4；TRANSWARP INCEPTOR_4.7.1；TRANSWARP INCEPTOR_4.5.1；TRANSWARP INCEPTOR_5.2.1；TRANSWARP INCEPTOR_5.1；

    org.apache.hive.jdbc.HiveDriver 

    jdbc:hive2://ip:port/dbname  

    GaussDB 200

    V100R002C80

    org.postgresql.Driver

     jdbc:postgresql://hostname:port/dbname

    HuaWei Cloud DWS

     

    org.postgresql.Driver

    jdbc:postgresql://hostname:port/dbname

    ClickHouse

    20.1.8.41

    ru.yandex.clickhouse.ClickHouseDriver

    jdbc:clickhouse://ip:port

    MaxCompute

    3.2.7 and above

    com.aliyun.odps.jdbc.OdpsDriver

    jdbc:odps:<maxcompute_endpoint>?project=<maxcompute_project_name>

    Alibaba Cloud Hologres

     

    org.postgresql.Driver

    jdbc:postgresql://ip:port/dbname

    2.2 Multidimensional database

    Data source

    Version

    Driver

    URL

    SAP HANA

    4.5.1

    com.sap.db.jdbc.Driver

     jdbc:sap://ip:port?reconnect=true

    Note: FineBI supports program dataset, JSON dataset, new SAP BW dataset, and Mongodb data connection by connecting to the FineReport server dataset. For the operation steps, please refer to: FineReport connects to FineBI remotely.

    Attachment List


    Theme： Data Connection
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭