Data Sources That Support Direct Connection
Databases supported by FineBI and the corresponding attributes are shown in the following table.
| Supported Databases | Data Extraction | Direct Connection |
|---|---|---|
| Amazon Redshift | √ | √ |
Apache Impala | √ | √ |
Apache Phoenix | √ | × |
ADS | √ | √ |
APACHE KYLIN | √ | √ |
ClickHouse | √ | √ |
Doris | √ | √ |
DERBY | √ | × |
Dremio | √ | √ |
Presto | √ | √ |
PostgreSQL | √ | √ |
Pivotal Greenplum Database | √ | √ |
Hologres | √ | √ |
MaxCompute | √ | √ |
StarRocks | √ | √ |
TBase | √ | √ |
Trino | √ | √ |
Transwarp Inceptor | √ | √ |
TeraData | √ | √ |
TiDB | √ | √ |
Microsoft SQL Server | √ | √ |
MySQL | √ | √ |
GaussDB 200 | √ | √ |
Gbase 8A | √ | √ |
Gbase 8S | √ | × |
Gbase 8T | √ | × |
Oracle | √ | √ |
DM | √ | √ |
AnalyticDB | √ | √ |
KingBase | √ | × |
IBM DB2 | √ | √ |
Informix | √ | √ |
Hadoop Hive | √ | × |
HBase | √ | × |
HSQL | √ | √ |
HP Vertica | √ | √ |
SAP HANA | √ | √ |
SAP Sybase | √ | √ |
Spark | √ | × |
√ | √ | |
StarRocks | √ | √ |
FusionInsight elk | √ | × |
DWS | √ | √ |
[Direct Connection] Kyligence (Enterprise Edition) | × | √ |
StarRocks | √ | √ |
Other Data Sources
New SAP BW dataset and JSON dataset can be connected through plugins.
In addition, FineBI can be connected to the program dataset, JSON dataset, new SAP BW dataset, and MongoDB by connecting to the server dataset of FineReport.
More Data Sources
The data processed by FineDataLink can be used by FineReport. FineDataLink supports data reading and writing. Data sources that are not supported by FineReport, but supported by FineDataLink are as shown in the following table.
| Data Source Type | Data source | Read | Write |
|---|---|---|---|
Database | KingBase | √ | √ |
StarRocks | √ | √ | |
Interface Type | API | √ | √ |
Jodoo | √ | √ | |
SAP RFC | √ | Under development | |
WebService | √ | Under development |
Note:
