I'm wondering if anyone has any experience with setting up a push data extraction from multiple sources?
We're looking at providing reporting off the back of several software packages - mining the data structure and then offering customers the chance of creating a link to their data source (whether that be directly to a SQL server, or CSV extract) and pushing it to our cloud server at chosen intervals.
Because we've built the data structure off the back of the software, we can be sure that each client installation falls under the same parameters.
We've had a development quote to build something, but we're looking to see if there are any packages pre-built that do something similar.
Does anyone have experience with any kind of package which pushes data to a data warehouse and is firewall friendly?