I. An Overview of BI Connect
1) "BI Connect" refers to the integration of business intelligence tools with various data sources to streamline and enhance data analysis processes. This connectivity is crucial for facilitating real-time access to data, supporting comprehensive analytics, and driving insightful business decisions.
2) The ability to connect seamlessly with multiple data systems allows organizations to leverage their data more effectively, leading to improved operational efficiency and strategic advantage. Using BI Connect empowers businesses to harness the full potential of their data assets, optimizing decision-making and competitive positioning.
3) 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 | √ | √ |
II. Data Sources of BI Connect
1 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.
2 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:
III. A Conclusion of BI Connect
In conclusion, BI Connect is instrumental in enhancing business intelligence systems by ensuring efficient and seamless data integration from diverse sources. This capability significantly enhances analytical accuracy and speeds up decision-making processes, providing businesses with a robust framework for data-driven strategies. By enabling real-time data access and comprehensive analytics, BI Connect plays a pivotal role in optimizing business operations and competitiveness.
