Profile

Cover photo
Raqsoft-Expert of Desktop BI
18 followers|7,734 views
AboutPostsPhotosVideos

Stream

 
A New Way to Consolidate Various Data Sources for Reporting Tool

In report development, we may need to present the data from multiple databases in one report, such as data from MSSQL database for CRM and Oracle database for ERP. If the reporting tool like iReport only supports single data source, then we need to consolidate the multiple data sources into a single data source.
The Crystal, BIRT, and other so-called reporting tools for multiple data source can only join 2 result sets roughly, and are also very inconvenient for the complex multi-data-source computations. For example, compute the yearly growth rate of order value for each client in ERP, group by the client data from CRM, and then present in a report.
It is believed that most companies adopt the commence strategy to only provide the single-data-source edition reporting tools, even if they are already capable of providing full support for multiple data sources.
How can we handle such a situation?
The commonest practice is to utilize the ETL or Data Warehouse tool - consolidate the data from various platforms to a single database. This practice will surely require preparing ETL scripts for regular updates according to the specific rules, building a global view or organizing the data as a single data source with stored procedures, as well as the contribution of DBA. All in all, this way to achieve the goal is at the great cost of additional human resource, a great deal of time, and modification to the database.
If the cost is not a priority concern, then the higher edition of database administration tools could be a better choice for implementation, such as, Server Link or Linked DB. In doing so, we will have to purchase the database server for separate use, recruit additional staffing, bear maintenance expenditure, and keep the safety considerations in mind. In facts, such practice only automates a few ETL functions based on the same core. The inconveniences in handling the complex computations for data sources are still there unsolved.
We need a tool that is not only lightweight, convenient, and easy-to-use, but also powerful enough to handle such situation.
esProc is such a tool that is specially built for database computation, expert at simplifying the complex computation, and perfect in debugging. With the support for cross-database computation and JDBC interface, esProc can easily integrate with reporting tools.
Still the above case, the whole procedure of data retrieving, computation, and merging can be accomplished in a few lines of esProc scripts clearly and concisely, as shown below:



Then, the result can be queried directly through the JDBC interface for Java report, just as easy as connecting to the common database.
In addition, esProc is especially designed for the massive amount of structured data, with the grid style and agile syntax. Thanks to its support for the external parameters and the direct data retrieving & computing across multiple databases, text files, and Excel sheets, esProc can perfectly consolidate multiple data sources and act as the computation layer of report data source of less couplings and more common use.
1
Add a comment...
 
How to Improve Java’s Computing Ability for Various Data Sources? Many Java applications are not incorporated with database. So, what if using such Java applications for query or structured data computing? See more at: http://datakeyword.blogspot.com/2013/06/computing-with-java-for-massive-data.html
1
Add a comment...
 
Raqsoft Launches esProc Dev – a Powerful Developer Tool. esProc is a developer tool for data computing with higher development efficiency, better debugging features, easier codes maintenance, and Big Data support. It is database computing script with more advanced core model, and specializes in complex computing objects. See more at: http://www.raqsoft.com/raqsoft-launches-esproc-dev-a-powerful-developer-tool.html
1
Add a comment...
 
esProc is a developer tool for data computing with higher development efficiency, better debugging features, easier codes maintenance, and Big Data support. Detail visit: http://www.raqsoft.com/what-is-esproc.html
2
Add a comment...
 
For example, find out the materials whose inventory level is below the warning limit for 3 consecutive days in the recent 2 weeks. Among those materials, which are used to produce the top 5 Halloween best-sellers? In another example, find out the agents contributing to the 60% of the total sales. Assign those agents in proper order to the salespersons whose performances rank ahead of others in the year-end sales promotion. More: http://datakeyword.blogspot.com/2013/05/could-business-computing-be-done-by.html
1
Add a comment...
 
A Strong Helper Is Available When Excel Sucks.
For many years until today, MS Excel is the most popular spreadsheet software in the world. It’s undeniable that Excel is a very powerful spreadsheet in almost every aspect. With intuitive interface, outstanding computation ability and excellent chart tools, Excel is liked by many people and used in all industries, enterprises in any size and any workspace environment. What a flexible and powerful tool! When it comes to complex computing tasks which are difficult to conduct with common functions of Excel, the powerful VBA will help users to solve them. It sounds that Excel is invincible, right?
http://www.raqsoft.com/a-strong-helper-is-available-when-excel-sucks.html?new=1
1
Add a comment...
Have them in circles
18 people
Ash Baldan's profile photo
Ding Daisy's profile photo
Jessica Qiu's profile photo
Diego Rodriguez's profile photo
DATA EXPERT's profile photo
Srikanth Bigclasses's profile photo
Johann Petrak's profile photo
Vita Zhang's profile photo
ariel bujeiro's profile photo
 
esCalc - Brand New Business Spreadsheet to Manipulate Data at Will. Check what is esCalc and esCalc do for you  from this video. esCalc - Brand New Business Spreadsheet to Manipulate Data at Will
1
1
Raqsoft BI OLAP's profile photo
Add a comment...
 
Do you agree that Java computational capability should be improved especially on complex structured data computing? Check our blog - New Algorithm Helps Java for Massive Structured Data Computing.  See more at: http://datakeyword.blogspot.com/2013/06/new-algorithm-helps-java-for-massive.html
2
Add a comment...
 
As a developer tool for database and reports, what's esProc innovation? Check here to see how esProc is different from other database developer tools? http://www.raqsoft.com/esproc-innovation.html
2
1
Raqsoft BI OLAP's profile photo
Add a comment...
 
Are you looking for a efficient developer tool for business computing? Then there you have come across the right choice, esProc. What is esProc? A Developer Tool for Business Computing! esProc is a database script, enabling agile and easy-to-use statement for the interactive analysis of structured data, and is especially good at dealing with complex, flexible or occasional data.  More: http://www.raqsoft.com/what-is-esproc.html
1
Add a comment...
 
Are you looking for a tool to calculate and further process on the report? I am sure you are looking for a report calculator. Check the detail on how esCalc to perform perfect as a report calculator. http://www.raqsoft.com/report-calculator-for-desktop-bi.html
1
Add a comment...
 
40+ Free Data Analysis and Visualization Tools 2013. Please +1 or spread it if you feel it useful. http://datakeyword.blogspot.com/2013/04/40-free-data-analysis-and-visualization.html
2
2
Raqsoft BI OLAP's profile photoData Visualization's profile photo
Add a comment...
People
Have them in circles
18 people
Ash Baldan's profile photo
Ding Daisy's profile photo
Jessica Qiu's profile photo
Diego Rodriguez's profile photo
DATA EXPERT's profile photo
Srikanth Bigclasses's profile photo
Johann Petrak's profile photo
Vita Zhang's profile photo
ariel bujeiro's profile photo
Contact Information
Contact info
Phone
86 10 51295366
Story
Tagline
Business Intelligence, Real OLAP, Data Mining, esProc, esCalc, structured data analysis
Links