Connect to Database
Data Connector in FineReport
FineReport provides 5 methods for data connectivity:
-
Direct JDBC Connection: This method facilitates direct access to relational databases via JDBC, ensuring efficient and seamless data retrieval.
-
JNDI Connection: By utilizing JNDI (Java Naming and Directory Interface), FineReport enables shared data connections with application servers, optimizing resource management in multi-tier environments.
-
XMLA Integration: FineReport supports connectivity to multidimensional databases through XMLA (XML for Analysis), allowing users to access and manipulate complex analytical data efficiently.
-
SAP System Connectivity via JCO: Leveraging JCO (Java Connector Architecture), FineReport integrates seamlessly with SAP systems, providing direct access to enterprise resource planning (ERP) data for enhanced business intelligence.
-
FineDataLink for Data Development: FineDataLink provides a robust framework for data development that streamlines data integration processes and enhances your overall data management capabilities.
Database Data Sources
The Database category provides the following data connections:
SQL Server database
Access database
MongoDB
Oracle database
Oracle Cloud Infrastructure
Oracle Essbase
IBM Db2 database
IBM Informix database
MySQL database
PostgreSQL database
Sybase database
Teradata database
SAP HANA database
SAP BW
SAP Sybase
Amazon Redshift
Amazon S3
Impala
Hadoop Hive
ClikHouse
Hbase
HSQL
SQLite
Spark
TiDB
Trino
Presto
Vertica
StarRocks
Snowflake
Pivotal Greenplum Database
Essbase
Elasticsearch
ClickHouse
Dremio Software
Dremio Cloud
Kyligence
Apache Kylin
Apache Impala
Apache Phoenix
Apache doris
Apache Derby
FusionInsight HD
FusionInsight elk
GBase 8T
Kingbase
File Data Sources
The File category provides the following data connections:
- Excel Workbook
- Text/CSV
- XML
- JSON
This guide gives you a basic understanding of FineReport. For usage instructions, please refer to the technical documentation.
