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

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy