Seamless Integration
—Service without reporting server
Every programmer with experience in Business Intelligence (BI) project development knows that the most troublesome problem in the project is reporting, if you want to free yourself from that troublesome work, the best way is to choose some reporting tool, which can customize report flexibly and resolve programming problems, and as well as reduce maintenance workload and leave the work to project implementers.
But reporting tools can only handle reports in the BI project, and it is a part of the project, so integration of the reporting tool becomes very important.
At present there are lots of report tools on the market, such as: Crystal, Brio, Style Report; They all provide a dedicated report server and a complete set of user role management mechanism, which results in many problems when it is integrated by programmers, concrete analysis is as follows:
- Dedicated report server results in report performance bottleneck.
- Unable to share the capability of web server cluster.
- Unable to share the capability of connection pool management.
- Unable to deploy uniformly, implementers need to deploy both their web application and report server.
- Insufficient user roles, there always exists unique user role in the specific applications and industries. As user role management of universal products, it can never meet a wide variety of users’ needs.
As a professional report solution provider，RAQSOFT has its original ideas in this area. RAQ Report provides JAR package to programmers to integrate report tool with their own systems, it has no dedicated report server, no application architecture and no individual user role management mechanism, which make system integration conveniently. The advantages are analyzed as follows:
- Have no dedicated report server; report performance depends on web server directly.
- Able to share the capability of web server cluster.
- Able to share the capability of connection pool management.
- Able to be packed up with web application in WAR format and deployed uniformly, and reduce the workload of the implementers.
- Use existing user role management mechanism of the web application directly, have no incompatibility problem of two management mechanism; provide uniform login screen, end users don’t have to log in twice.
Summary: integration solution adopted in RAQ Report is novel and unique; totally solves the integration problems which have bothered the programmers for a long time. It is suitable for application integration, and has wonderful performance in both usability and integration capability.