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 Database: Include such mainstream relational databases as Oracle, SqlServer, Mysql, DB2, Sybase, Access, Derby, Postgre, Informix; Support SQL data sheets or views, or stored procedures.
* Non-relational Database:Essbase, Ssas, Sap, Hadoop, FineCube, Saphana, Sapbw, MongoDB, Hive.
* Text Data Sources: Data in Excel, Txt, XML documents.
* Other Data Sources: Built-in data source in server, built-in data set in the report, and JSON data set.

[AuthorRecommendedPosts post-id="3987"]