Oracle Synonym is not available in IDT 4.1

[Former Member]

Hello Friends,

I am working on a universe using IDT 4.1. I have created a db connection (based on Oracle 11g -> Oracle Client driver) and have used SSO authentication which is working fine. I see the list of tables and views under a schema but public synonyms are missing. I saw a post which suggested to make a change in the Oracle.sbo file located at C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle on my machine. I verified that I have the access to the public synonym.

I made the following change and restarted the machine but I still don't see the public synonyms. Your help is appreciated!

<Parameter Name="Include Synonyms">True</Parameter>

thanks,

Swapnil

[Former Member]

Hi Swapnil,

Can you confirm, from where you are accessing the client tools? Is it from the local machine or from citrix?

Can you try to make the changes to oracle.sbo file under odbc folder?

Regards,

Siva