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 |
Previous：Data Connection to Hologres
