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?
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.
They are not on the same machine