Central reporting for diverse database datacapture?
Posted on 2011-02-16
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?