Supported Data Sources- FineBI Document

Last update： 2023-11-09

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	√	×
SQLite	√	√
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	√	√
Database	StarRocks	√	√
Interface Type	API	√	√
	Jodoo	√	√
	SAP RFC	√	Under development
	WebService	√	Under development

Note:

For data sources supported by FineDataLink, see Data Sources Supported by FineDataLink.

Previous：Driver Management

Next：Spider Dataset Plugin

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

Supported Data Sources

Data Sources That Support Direct Connection

Other Data Sources

More Data Sources

附件列表