Does anyone have/know of a tool that can pull data from multiple sources to do reporting? We would like to pull data from our data warehouse and salesforce.com to display in salesforce.com. Am I going to have to export the data from salesforce.com to our warehouse and then do reporting from there? If so, how do I display that in saleforce.com, ie web service, crystal reports, etc...
The current Reports Module in salesforce has a lot of limiations with respect to the number of objects selected, matrix reports limitations and so on.
Does salesforce recommend any other reporting tool that can be integrated with our salesforce app that has extensive reporting capabilities for prompted reports and so on. We have tried jasper, QueryAmp...but none these server the specific user requirements.
We appreciate all your feedbacks as we have a lot of requests coming from business for reporting capabilities (especially matrix reports) in our application.
Let me know if you need any further information in this regard.
