Accessing multiple databases through Synonyms

[dsds]

I need to get data from three different datasources, Oracle, Netezza & Greenplum. I am thinking of creating DB links. That way i can get all my objects from one schema as tables or synonyms. This way i wont have to deal with local processing from multiple database access. Do you think it will work?

[cognostechie]

Yes, it does work though it has it's limitations. It would just avoid local processing on the Cognos server but there still might be a situation where no single database would do the entire processing. The processing would take place on the DB server instead of the Cognos server but it depends on whether all 3 DBs are on the same physical machine.

[dsds]

They are not on the same machine