Has anyone come across a solution to allow Designer to recognize the column names of Oracle synonyms in Refresh Structure and Integrity Check? I have used the solution of adding that database owner before and have also had views created off the tables to be able to see columns, but currently I’m working in an environment where the synonyms are database-linked to another instance. Therefore adding the database owner and referencing the base table isn’t an option. I can create views but if there is a way to see synonym column names, that would be preferable. Synonyms have been an ongoing problem in Designer but I haven’t seen a good solution yet. I am moving several large universes and converting from DB2 and want to be able to use integrity check to make sure all tables and columns needed exist in the new environment.
Are you able to access the synonyms through SQL*PLUS with the user ?
Please check these:
a) See that the user in designer connection has access to synonyms ?
b) You must also check the strategy you are using to build the universe ? I don’t remember the exact filename, you have to add few lines to the standard strategy file…
c) Also check the product ‘Data Federator’ from BO ?
Yes, the ID in the connection has access to the synonyms. The objects referencing the synonyms work fine. It is only the refresh structure and integrity check features that do not recognize the columns in the synonyms. This has been a well-known problem in the last few versions of Business Objects. I saw a posted solution for Sybase, but not for Oracle. Just hoping someone came up with a solution for Oracle.
I don’t believe editing the external strategy will help, but I’m willing to try if anyone has had success with it. Thanks
(BOB member since 2002-08-19)