I would recommend looking into using Jaspersoft for embedding reports into your applications. It works with MySQL in the cloud and allows users to interact with the data. But you should not take my word for it. Go to www.jaspersoft.com/embedded where you can see a demo of the product and a listing of all the features that I think would pertain to your situation. From this page, you can also download the software, see code samples and also view tutorials on developing an application with embedded reports.
Hope this helps!
Search for a product comparison in BI (Business Intelligence) Tools
Head of Data Analytics at a marketing services firm
Vendor
Apr 4, 2014
Hi,
I think the open source version of eclipse BIRT will be a good option. It
is very flexible, customizable, great community support, totally free and
above all can be easily integrated into web pages using JavaScript.
Customer Success Manager at a tech vendor with 11-50 employees
Vendor
Apr 3, 2014
I strongly believe that Belladati can solve the issue and meet your requirements. It is Agile BI tool which allows you quickly create reports. Their expertise are in Embedded analytics and also allows easy access to the system REST API. Please take a look to the sample provided: www.belladati.com/company/blog/2014/02/25/hr-performance-evaluation-with-embedded-belladati.
Senior Consultant at a tech company with 51-200 employees
Real User
Apr 3, 2014
I recommend you do a little research on BI Open Source solutions. In your case I guess that Spago BI can fulfill your needs. For each new report you can create a query or a special kind of simple fact table with dates including all data that you would need in the future for the same kind of reports. Afterwards you will have time to upgrade to a real DW/BI structure.
Spago BI is an Italian tool that built a set of different Open Source DW and analysis tools making them work together, so you can select the stage process that you need now only -> Reporting.
Solution Architect at a healthcare company with 1,001-5,000 employees
Real User
Apr 3, 2014
Sure …
If the customer needs scale in terms of both numbers of users (with high concurrency) and volume of data - I’d suggest MicroStrategy as it has in my opinion the best ability to handle both scaling challenges of all enterprise BI platforms out there today. The powerful analytics and multi-pass SQL capabilities of it’s ROLAP engine means no calculation/aggregation/derivation would be too complex to handle and MicroStrategy handles this complexity internally and doesn’t force pre-calc’ed or pre-aggregated or pre-designed constructs to effect it. They also have arguably the best mobile BI capabilities as well for iOS and Android.
For reports containing graphs and grids – you can decide if you want it pixel-perfect without user interactivity (i.e. drilling, sorting, etc.) and create a MicroStrategy Report Services document. For interactive reports/dashboards, you would render MicroStrategy Web reports. To embed, you can skin/style the MicroStrategy interface with the corporate UI standards or use the MicroStrategy SDK for deeper integration/interaction with an existing front end Web application/framework.
Consultant at a tech consulting company with 51-200 employees
Consultant
Top 10
Apr 3, 2014
I strongly recommend Pentaho Reporting capabilities, very useful for embedding reports into other applications. Runs under JVM and with an Open source edition without license fee. Pentaho Reporting includes a strong core of formulas including Open Formula standards, possibility of adding script codes, multiple data source connection via JDBC drivers (Oracle, MySQL, SQL Server, PostgreSQL, MongoDB, Vertica, Big Data platforms...) and without proprietary costs.
Business Analyst at a energy/utilities company with 1,001-5,000 employees
Vendor
Apr 3, 2014
I suggest using the following tools
1. SAP Crystal Report should be pretty easy to implement also same as
2. Microsoft Reporting Service since you can deploy it to the web site.
I suggest you to use a report Server such as MICROSOFT (SSIRS), Jasper
Report Server or any other related Technology.
You'll have to first create a connection to your MySQL db and design those
reports.
So the user will log in into this server and call reports they have access to.
Manager of Data Analytics at a tech vendor with 501-1,000 employees
Vendor
Apr 3, 2014
We recently implemented an embedded BI solution in our collaboration software using LogiAnalytics Info and were very happy with the results. The solution provides users the ability to create customized dashboards and the underlying data source is a web service using JSON. The Architect wrote a couple of plug-ins to support our token based security and re-pivot of the data, they took about a week to complete. Also, we used CSS to re-skin brand LogiAnalytics as part of the application. LogiAnalytics licensing model is flexible and we choose server based licensing since we have a large user base with unpredictable usage patterns. Our solution includes various data visualizations and grids tied to our underlying search API. LogiAnalytics doesn’t provide pixel perfect reports but can handle most other duties.
MySQL is an open-source database known for its ease of use and high performance. It offers features like replication and clustering, making it ideal for diverse applications. Its cost-effectiveness and LAMP integration are key advantages for businesses.MySQL supports a variety of languages and platforms, providing reliable, scalable data management. Its graphical interface and LAMP architecture integration enhance its usability, while community support further strengthens its appeal....
I would recommend looking into using Jaspersoft for embedding reports into your applications. It works with MySQL in the cloud and allows users to interact with the data. But you should not take my word for it. Go to www.jaspersoft.com/embedded where you can see a demo of the product and a listing of all the features that I think would pertain to your situation. From this page, you can also download the software, see code samples and also view tutorials on developing an application with embedded reports.
Hope this helps!
Hi,
I think the open source version of eclipse BIRT will be a good option. It
is very flexible, customizable, great community support, totally free and
above all can be easily integrated into web pages using JavaScript.
Regards,
Mandar
Open Source BI Tools like Japsersoft would be suitable to meet your requirement,
Pentaho,BIRT can be other options
No
Not really in my wheel house.
Given your presumable Linux expertise, I think you ought to take a look at these:
1. JasperReports (both commercial and free)
2. BIRT (www.eclipse.org/birt/phoenix/)
Many other options are available but it's hard to recommend without more context.
I strongly believe that Belladati can solve the issue and meet your requirements. It is Agile BI tool which allows you quickly create reports. Their expertise are in Embedded analytics and also allows easy access to the system REST API. Please take a look to the sample provided: www.belladati.com/company/blog/2014/02/25/hr-performance-evaluation-with-embedded-belladati.
Tableau or Crystal Reports support that too. Its more complicated with these solution. You can go on tableau link: alphasoftware.net/palace-entertainment-turns-to-alpha-to-help-in-the-smooth-running-of-their-37-theme-and-water-parks-in-the-usa/how-to-embed-and-integrate-tableau-analytics-in-alpha/
Disclosure: I work for BellaDati
SSRS may actually work pretty nice. It embeds nicely with Asp.net and it has all objects you need for reporting.
I recommend you do a little research on BI Open Source solutions. In your case I guess that Spago BI can fulfill your needs. For each new report you can create a query or a special kind of simple fact table with dates including all data that you would need in the future for the same kind of reports. Afterwards you will have time to upgrade to a real DW/BI structure.
Spago BI is an Italian tool that built a set of different Open Source DW and analysis tools making them work together, so you can select the stage process that you need now only -> Reporting.
Regards,
Marcelo
Sure …
If the customer needs scale in terms of both numbers of users (with high concurrency) and volume of data - I’d suggest MicroStrategy as it has in my opinion the best ability to handle both scaling challenges of all enterprise BI platforms out there today. The powerful analytics and multi-pass SQL capabilities of it’s ROLAP engine means no calculation/aggregation/derivation would be too complex to handle and MicroStrategy handles this complexity internally and doesn’t force pre-calc’ed or pre-aggregated or pre-designed constructs to effect it. They also have arguably the best mobile BI capabilities as well for iOS and Android.
For reports containing graphs and grids – you can decide if you want it pixel-perfect without user interactivity (i.e. drilling, sorting, etc.) and create a MicroStrategy Report Services document. For interactive reports/dashboards, you would render MicroStrategy Web reports. To embed, you can skin/style the MicroStrategy interface with the corporate UI standards or use the MicroStrategy SDK for deeper integration/interaction with an existing front end Web application/framework.
Hope that helps,
Steve Cornett
I strongly recommend Pentaho Reporting capabilities, very useful for embedding reports into other applications. Runs under JVM and with an Open source edition without license fee. Pentaho Reporting includes a strong core of formulas including Open Formula standards, possibility of adding script codes, multiple data source connection via JDBC drivers (Oracle, MySQL, SQL Server, PostgreSQL, MongoDB, Vertica, Big Data platforms...) and without proprietary costs.
I suggest using the following tools
1. SAP Crystal Report should be pretty easy to implement also same as
2. Microsoft Reporting Service since you can deploy it to the web site.
I suggest you to use a report Server such as MICROSOFT (SSIRS), Jasper
Report Server or any other related Technology.
You'll have to first create a connection to your MySQL db and design those
reports.
So the user will log in into this server and call reports they have access to.
We recently implemented an embedded BI solution in our collaboration software using LogiAnalytics Info and were very happy with the results. The solution provides users the ability to create customized dashboards and the underlying data source is a web service using JSON. The Architect wrote a couple of plug-ins to support our token based security and re-pivot of the data, they took about a week to complete. Also, we used CSS to re-skin brand LogiAnalytics as part of the application. LogiAnalytics licensing model is flexible and we choose server based licensing since we have a large user base with unpredictable usage patterns. Our solution includes various data visualizations and grids tied to our underlying search API. LogiAnalytics doesn’t provide pixel perfect reports but can handle most other duties.