Connecting Designer to SQL Server 2012

building semantic layer
1

Hi,

I have BO XI R3.1. I want to connect to SQL Server 2012 from Universe. Can anyone pls. guide me how can i connect it. BO Server & SQL Server are on separate machine. I was thinking of creating System DSN - ( ODBC or OLEDB) Connection on my client machine first and then use that connection in Universe.

Not sure if its right approach. Also, do i need to install SQL Client on client machine where i am using designer. Do i need to make change any option in CMC.

Thanks,

Diablog (BOB member since 2009-08-04)

2

You’ll need a DSN on the pc where you have installed Designer. If you want to query via webi, you’ll need the same DSN on the webi server too. When you’ve got a working DSN, you can pick it up with a new universe connection. Not sure that R3 actually supports SQL Sever 2012 though.

You don’t need an SQL client - but it’ll help to debug queries.

Debbie

Debbie :uk: (BOB member since 2005-03-01)

3

With 2008, you could create an OLEDB connection and didn’t need any DSNs anywhere.

As Debbie says, I’m not sure if BOXI3.1 supports SQL Server 2012 - it doesn’t as of SP5, I’ve just checked.

4

I have never yet succeeded in getting an OLEDB connection to work consistently. No idea why. I gave up and went back to DSNs as they seem to be far more reliable. :wink:

Debbie

Debbie :uk: (BOB member since 2005-03-01)

5

Interesting.

Never had a problem with them over 2005 or 2008. Can’t remember about 2000, it was that long ago!

6

Interesting thing is Microsoft intend to “do away” with OLEDB connectivity and make connectivity to SQL Server, in future releases, ODBC only.

Super!
:cuss:

Mak 1 :uk: (BOB member since 2005-01-06)