View containing data from multiple databases

[Former Member]

Hi

In a 3rd party integration szenario I have the following challenge:

On 1 Sybase server, there are 3 ERP companies stored in 3 dbs. The table structures on these 3 dbs are 100% identical. In my application I would like to show data from all 3 companies together in 1 view. Let's say, I want to see addresses from all 3 companies.

Is there a way to create a view containing data from more than 1 db (meaning from more than 1 company)?

Tanks in advance, your help is greatly appreciated. Heinz

[VolkerBarth]

Here are some more questions with samples how to access tables from other SQL Anywhere databases:

• Grant select to another database/schema
• Query over two SQL Anywhere 12 databases

I'm sure there are several more tagged woth "remote-data-access" or "proxy-tables".

As to the UNION ALL statement: In case performace suffers (this is sometimes a problem with remote data), it's a common strategy to copy remote data to the "local" database, say to a (possibly local temporary table) via INSERT ... SELECT FROM myProxyTable, and then to run the UNION ALL on the local copy.