Hi, I am the reporting girl.
Our company has been gradually running ERP, HR, and financial systems within several years. They service different departments independently.
One day, my boss told me he wants to see customer, sales, financial and employee data in a uniform portal and wants to make cross data analysis among them.

OH, my god!
Those data dependently stored in 3 different databases of 3 systems.

When I was just in trouble, a reporting tool really help me a lot!

Fetch the data I need from Mysql, Oracle, and SQL SERVER. Then design the report format and do calculations in the report designer. Finally, view it via a browser or a reporting system!

What’ s more, the data in the report will change with changes in the 3 systems. No duplicate work is needed!
This is the famous muti-data resources function of reporting tool.
Two points are important to note here:
First, data from the same or different databases can be integrated into one report.

Second, the tool can support as many data sources as possible.

FineReport supports the following types of data sources:

• Relational Databases:
  • Traditional RDBMSs including Oracle, SQL Server, MySQL, DB2, Sybase, Access, Derby, PostgreSQL, and Informix
  • Enterprise solutions like mySAP
  • MPP databases for large-scale data processing
  • Supports SQL tables, views, and stored procedures
• Non-relational Databases:
  • OLAP solutions: Essbase, SSAS
  • Big Data platforms: Hadoop, Hive
  • Enterprise systems: SAP HANA, SAP BW
  • NoSQL databases: MongoDB
  • In-memory analytics: FineCube
• Text Data Sources:
  • Excel, TXT, and XML documents
• Other Data Sources:
  • Server built-in data sources
  • Report built-in datasets
  • JSON datasets