Faced with the necessity of collecting data from multiple systems, for further use with the purpose of generating analytical reports.
Powerful on the Internet, but anything intelligible did not find, so ask for help.
Are in search of solutions able to meet the following requirements:
-Collecting data from multiple databases from different vendors, oracle db, mssql, etc.
-Configuring time ranges collect (every day, every hour, etc.)
-Select full or incremental fee depending on the conditions (such as once a month full and every hour incremental)
-Setting tables and fields from which data is collected (for each system its own set)
-Availability of remote access to systems from which data can be collected (e.g. data warehouse in St. Petersburg, and the target system in Moscow and Novosibirsk)
-Zoom (new systems)
The area is new to me, if you need clarification, I am ready to answer all questions.