Monday, 18 February 2013

Oracle Table Synonym in Information Design Tool

Battling with using Synonyms in IDT upgrade to SP5 Patch 5:

Go to C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle

Look for oracle.sbo and edit it with notepad

Look for : <Parameter Name="Include Synonyms">False</Parameter>

Change this true and save: <Parameter Name="Include Synonyms">True</Parameter>

Restart Services and then you are Good to go!!!
Posted by at

2 comments:

  1. Swap18 February 2015 at 22:10

    This comment has been removed by the author.

    ReplyDelete
  2. Swap18 February 2015 at 22:15

    Hi Emman,
    I tried implementing the solution you have provided here (by changing the parameter value to 'True') but no success. I have IDT installed on my machine and I could change the value of Oracle.sbo file. When I try to add a Public Synonym in Data Foundation layer, it does NOT SHOW UP. We are using BO 4.1. Am I missing anything? Appreciate your help!

    ReplyDelete

Subscribe to: Post Comments (Atom)