Big News: FounderDating is joining OneVest to build the largest community for entrepreneurs. Details here
Latest Notifications
You have no recent recommendations.
Name
Title
 
MiniBio
FOLLOW
Title
 Followers
FOLLOW TOPIC

Question goes here

1,300 Followers

  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur

any recommendations for mySQL reporting tools?

we need to produce Excel-style reports (i.e. no graphs or chats at this stage) on a regular basis for multiple customers.
The report is populated with information from mySQL.
The reports have been custom-built by our developer, and any change are time consuming.

I wonder whether there is an efficient tool with a non-technical GUI that would allow us to build, run, schedule, etc. reports.

26 Replies

Lee Ann Guertin
1
0
Lee Ann Guertin Entrepreneur
Editorial Research Manager, Online Analytics
If you have Microsoft Office/Office 365 (which I'm assuming yes since you are using/considering Excel) then try their PowerBI tool. Their "Pro" version will allow you to schedule and publish reports that query databases like MySQL at a low cost, essentially using the Azure cloud services to manage it. $9.95/mo is pretty reasonable. Most of it uses a drag and drop or graphical type of UI as well. Hope this helps. Good luck!
Aleksey Malyshev
0
0
Aleksey Malyshev Entrepreneur
Software Engineer at iTouch Biometrics, LLC
You need to provide a little bit more information about it. Will they see it on a desktop or a web browser? Or maybe you want to send an e-mail report? How far are your customers from the database? If they access it remotely, security is an important consideration.

One of those tools that I know is Microsoft Access.
Lee Ann Guertin
0
0
Lee Ann Guertin Entrepreneur
Editorial Research Manager, Online Analytics
Microsoft Access is another DB platform tool and DB type, not really a reporting platform or a report delivery tool. I wouldn't use it to import data from MySQL since it would basically be just transferring data from one DB into another DB that would then process data to enable the limited reporting UI, which is more effort intensive than it seemed this person was looking for...
Shobhit Verma
0
0
Shobhit Verma Entrepreneur • Advisor
building an adaptive recommendation engine
http://www.tableau.com/ is probably too much ?
Aleksey Malyshev
0
0
Aleksey Malyshev Entrepreneur
Software Engineer at iTouch Biometrics, LLC
Access is not just a DB platform, it is also a nice UI building tool, that you can connect to many databases and build a desktop UI. I have not used it for a while. Maybe Microsoft added more features recently.
Lee Ann Guertin
0
0
Lee Ann Guertin Entrepreneur
Editorial Research Manager, Online Analytics
I realize that I was a little harsh on Access -- I should clarify that you *can* do reporting within MS Access. And you can export to Excel format. You can do that with other tools as well, but most people i have worked with find it less than intuitive and not as sophisticated as other tools on the market. Especially if any charts or visualizations like we have now in Excel are desired. I think it is part of why MS Office has been working on PowerBI as a reporting platform. I'm working with Tableau, Access, Excel, and PowerBI at the moment. Hope this helps!
Matthew Excell
0
0
Matthew Excell Advisor
Lead Architect and Technology Strategy Consultant at Watchman Technologies, L.L.C.
JasperServer will do everything you mentioned (though the post was a touch light on details) and quite a bit more. Web, pdf, Excel and other office exports, etc. Easy to use for anyone who can write sql queries - there is an almost wysiwyg editor (Jaspersoft Studio) for the reports and a raft of documentation for it. The community edition is free or they have paid editions with additional features like adhoc reporting. No, I don't represent them - but several of my startups and clients have used the evolving products to great effect over the last 15 years.
Lee Ann Guertin
1
0
Lee Ann Guertin Entrepreneur
Editorial Research Manager, Online Analytics
I'm in the middle of a licensing negotiation with Tableau right now. It isn't for the faint of heart or for a small budget. You'd need a server license, desktop professional license, and annual maintenance licenses just to even get started. More if you would need to support enterprise level operations or multiple report developers.
Lee Ann Guertin
0
0
Lee Ann Guertin Entrepreneur
Editorial Research Manager, Online Analytics
Every org I have worked with that used JasperServer had a hard time finding Devs for it, to support it, and it did little for them in reporting ease and extensability. Took too long to deliver anything as well. Everyone moved off it. Access isn't being developed at MS as their premium reporting UI platform, especially for visualizations. PowerBI is. It's part of the MS Office suite but is relatively new.
Seth Familian
0
0
Seth Familian Entrepreneur
Digital Strategist, Innovator, Educator + Entrepreneur
https://chartio.com is one potential option, though their pricing isn't transparent (which likely means more $$$) Alternatively check out the large list of analytics tools on https://segment.com/docs/integrations/. There's bound to be one there that fits the bill. Cheers, Seth
Join FounderDating to participate in the discussion
Nothing gets posted to LinkedIn and your information will not be shared.

Just a few more details please.

DO: Start a discussion, share a resource, or ask a question related to entrepreneurship.
DON'T: Post about prohibited topics such as recruiting, cofounder wanted, check out my product
or feedback on the FD site (you can send this to us directly info@founderdating.com).
See the Community Code of Conduct for more details.

Title

Give your question or discussion topic a great title, make it catchy and succinct.

Details

Make sure what you're about to say is specific and relevant - you'll get better responses.

Topics

Tag your discussion so you get more relevant responses.

Question goes here

1,300 Followers

  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
Know someone who should answer this question? Enter their email below
Stay current and follow these discussion topics?