Synonyms with MS SQL

building semantic layer
1

Hi there
Is it possible to create a universe on MS SQL using synonym tables? I am unable to see them in the schema.
I have access and can view them from MSSQL Studio, but not through IDT.
I see there is a parameter that needs to be set for use with Oracle but not sure if this is the same for SQL?
We are using BO 4.1 sp5 and SQL 2008 (I know -it’s ancient, I can’t change it though??)
Thanks

SarahG :australia: (BOB member since 2005-08-22)

2

The type of connection you use has an impact on this also. We have one universe built over a Microsoft SQL Server database that uses synonyms and we had to use an OLEDB connection to get it to work. Our universe is a unv universe though so we are using Universe Design Tool. I wouldn’t be surprised if it was different with the IDT though.