Central reporting for diverse database datacapture?

So our menagerie of web applications frequently feature a small data capture element, e.g. a 'competition entries' table, or 'contact us' table.

The applications are often bespoke so there is no time to build a fully featured administration or reporting page.

As a result, a developer is typically charged with connecting to the production application and performing the data extract for the client team. This is boring for the developer any myself who has to grant and deny access to these resources.

I'm thinking what might be a suitable solution for central self-service reporting for the company. Perhaps an application that is given data_reader access against every application we host, secure via our AD?

Maybe we should consider different approaches like capturing data straight to google analytics? Or is there an easier way for application administrators to connect to their GUI-less applications I've not thought of?
LVL 4
Borgs8472Asked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
Depends on where and how heterogeneous you data is. I believe sometimes 3rd party tools can help even is you have the best .NET developers in house for simple reason it may be there already for you and for free if you check the last two links above. For instance we use free "Logi Report" in house even if we have SQL/SSRS reports and top .NET developers as well. Hope this helps.
0
 
lcohanDatabase AnalystCommented:
0
 
Borgs8472Author Commented:
No I wasn't thinking along those lines. We have top class .net developers in house I should mention, but I don't know what the most flexible application architecture to bring it all together is. :/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.