Get data from multiple sources - consolidate data

[Former Member]

Recently I was given the need to make queries on cross-bound and consolidated data from multiple tables and on data from multiple clients. The information is only in one sense "Client -> Base Centralizer", do not need all information, are just some tables chosen. All clients run Sybase Adaptive Sql Anywhere 9.0.2.3951

The "centralizing" structure is brand new and can be assembled as we wish, could use current versions! What would be the suggestion to feed this centralizing base? Mobilink?

Many thanks!

DRauber

[VolkerBarth]

Just to add: In case you cannot access the client databases directly (in contrast to Breck's suggestion), and the data you want to collect is rather simple (say, just a few tables without deeper foreign key relationships): As an alternative to MobiLink (or SQL Remote), you might also consider using a web service to collect those. The consolidated could establish a web service and the ASA 9 clients could then use the web client feature to call the service and supply their data. (AFAIK ASA9 does support web services and web client procedures/functions.)

If that is easier to implement than a MobiLink solution will depend on the complexity of the data structures and your knowledge w.r.t. both technologies...