Overview
There are many ways to connect data sources in FineReport.
1. Direct connection to the database through JDBC.
2. Share data connections with the application server through JNDI.
3. Connect with multidimensional databases through the XMLA data connection.
4. Connect to the SAP system through JCO.
You can create data connections in the designer or on the platform. The following table shows details.
Data Connection Type | Designer/Platform |
---|---|
JDBC | Designer/platform (recommended) |
JNDI | Designer |
Multidimensional Database | Designer |
Other databases | Designer |
Supported Data Type
Officially supported JDBC connection | Apache Impala Data Connection Apache Phoenix Data Connection Amazon Redshift Data Connection Cache Data Connection DORIS Data Connection DERBY Data Connection Dremio Data Connection FusionInsight HD Data Connection FusionInsight elk Data Connection GBase 8T Data Connection GBase 8T Data Connection GBase 8T Data Connection GaussDB 200 Data Connection Hadoop Hive Data Connection H2 Data Connection Hbase Data Connection HSQL Data Connection HP Vertica Data Connection IBM DB2 Data Connection INFORMIX Data Connection KINGBASE Data Connection MySQL Data Connection Microsoft SQL Server Data Connection ODBC Data Connection Oracle Data Connection PostgreSQL Data Connection Presto Data Connection Pivotal Greenplum Database Data Connection SAP Sybase Data Connection SAP HANA Data Connection SQLite Data Connection SPARK Data Connection TBase Data Connection TiDB Data Connection Trino Data Connection TeraData Data Connection TRANSWARP INCEPTOR Data Connection Aliyun Hologres Data Connection Aliyun AnalyticDB Data Connection Aliyun MaxCompute Data Connection Huawei Cloud DWS Data Connection |
Other JDBC connections | [Designer] HanGao Data Connection [Designer] dBASE Data Connection [Designer] Access Data Connection [Designer] Connect to Oracle Through OCI [Designer] Connect to ACCESS Through ODBC |
Microsoft Analysis Services (SSAS) Oracle Essbase SAP HANA | |
JNDI data connection | [Designer] JNDI Connection to the Database [Designer] WebLogic Configuration for JNDI Connection [Designer] Tomcat Configuration for JNDI Connection |
Plugin installation needed before the Connection | Redis Dataset New SSAS Plugin InfluxDB Dataset MongoDB Database Connection Spider Dataset Plugin Elasticsearch Dataset - Enjoyment Edition |
More Data Types
FineDataLink
The data processed by FineDataLink can be utilized in FineReport.
FineDataLink can bring more types of data docking capabilities to FineReport. The following table shows data sources supported in FineDataLink but not in FineReport currently.
Data Source Type | Data Source | Data Read | Data Write |
---|---|---|---|
Database | KingBase | √ | √ |
StarRocks | √ | √ | |
Interface Type | API | √ | √ |
Jodoo | √ | √ | |
SAP RFC | √ | Under development | |
WebService | √ | Under development |