反馈已提交

网络繁忙

Direct Connect Databases Supporting Integrated Analysis with Excel

  • Last update:  2023-04-26
  • Overview

    All extract data tables from databases can be associated, merged horizontally or vertically with Excel tables for integrated analysis.

    Only some direct data tables from databases can be associated, merged horizontally or vertically with Excel tables, while other databases are gradually being adapted.

    Databases Supporting Integration

    The direct databases that support association, Left and Right Merge, up and down merge with Excel are shown in the table below:

    Note: When connecting to the database, you need to ensure that the entered user has write permission to this database, otherwise it will not be possible to perform integrated analysis.

    Database

    Database Version

    FineBI Version

    Microsoft SQL Server   2016

    2016

    6.0

    Oracle

    11

    Pivotal Greenplum

    9

    Apache Impala

    2.0

    SAP Sybase

    IQ 16.0

    PostgreSQL

    9

    ClickHouse

    20.1.8.41

    Presto

    0.218

    GaussDB 200

    GaussDB 200

    MySQL

    8.0, 5.6.31, 5.5, 5.5.5, 5.6.35, 5.7, 5.6.37, 5.5.46, 6.5, 5.7.16, 5.6.29, 5.6.22, 5.6.34, 5.6.28, 5.1

    Hologres

    Unlimited

    DORIS

    Unlimited

    SAP HANA

    4.5.1

    6.0.4

    StarRocks

    Unlimited

    6.0.4

    GBase 8a

    Unlimited

    6.0.6


    附件列表


    主题: Data Center
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    feedback

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

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

    不再提示

    10s后关闭