I am relatively new to application development (at least in the professional world) and was wondering what the best way to go about querying several different databases and transferring that data to 1 central database.
As a bit of a background I’m working on developing an application that will merge all of the company I work for’s network monitoring data in one place that can be accessed easily as opposed to needing to check multiple applications.
My first idea would be to develop a Java server application that has connections to all the databases I need and queries and transforms that data in regular intervals (once a minute, once every 20 seconds, etc.) and then inserts all that new data into the central SQL Server 2005 database. Is there any easier way? Would using a different programming language be easier? Would I be able to do it directly through SQL Server? Would I be able to somehow combine all of this into a JSP/ASP site?
Any suggestions?