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 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
2014-04-04T18:10:44Z
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
2014-04-03T15:41:20Z
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
Tableau or Crystal Reports support that too. Its more complicated with these solution. You can go on tableau link: alphasoftware.net
Senior Consultant at a tech company with 51-200 employees
Vendor
2014-04-03T12:30:26Z
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
2014-04-03T12:23:52Z
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 20
2014-04-03T11:56:08Z
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
2014-04-03T11:53:47Z
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 Viewpoint Construction Software
Vendor
2014-04-03T11:32:15Z
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 a cost-efficient and scalable relational database management system widely used in web, mobile applications, and academic projects.
MySQL is utilized for backend operations, data analysis, reporting, financial transactions, and ERP databases. It supports deployment on local servers, Cloud, and Kubernetes. Its free, open-source nature along with strong community support make it popular among companies. MySQL's compatibility with multiple platforms and programming languages...
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 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)
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
Tableau or Crystal Reports support that too. Its more complicated with these solution. You can go on tableau link: alphasoftware.net
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.