Link to home
Start Free TrialLog in
Avatar of Borgs8472
Borgs8472

asked on

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?
Avatar of lcohan
lcohan
Flag of Canada image

Avatar of Borgs8472
Borgs8472

ASKER

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. :/
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial