We are setting up mirroring our Salesforce to mySQL using CopyStorm.
One object in particular will be mirrored with no deletion (all data ever will accumulate in mySQL while in Salesforce it will be deleted after 1 month due to space considerations).
So mySQL is literally ending up as our "current Salesforce data" plus ALL data on ObjectX "ever" ongoing.
My general thought was "we point Crystal Reports at this SQL data and do our reporting".
Is anyone doing anything remotely like this and have any advice, either on another product, or anything related? This isn't necessarily for heavy BI purposes, but once the powers that be master reporting on ObjectX outside of SF, the next iteration will be to do even more reporting "offline".
The one alternative could be JasperReports, though I've JUST started looking at that.
I haven't used a product like Crystal Reports in over a decade, so I wish to ask those who may be doing something along these lines with their Salesforce data.
Thanks for any insights.
Update 2014-08-19: JasperReports, watching a few videos of it in action, seems like you are using QuarkXpress or PageMaker to write a simple report. That doesn't seem like a solution to me. Still researching...
Update 2014-10-31: Company is moving forward with a full BI solution - MicroStrategy - after all has been said and done. The prep work in MS is ... intense ... but the end result is a reporting and BI platform that is insanely powerful.