IDT Database Middleware Drivers missing (ODBC & OLEDB)

building semantic layer
1

Hi all,

I did search this forum and various others for this problem however I cannot find a solution.

I have recently installed SAP BusinessObject BI Platform 4.0 Client Tools SP6 on my Windows 7 machine. I have created a project in the Information Design Tool, and when attempting to create a new Relational Connection, the list of Database Middleware Drivers available is very limited.

I wish to make a connection to a SQL server, and I believe this would be achieved via an ODBC or OLE DB driver however none of which are available.

All I have available under Microsoft is:
MS SQL Server 2008 -> JDBC Drivers
MS SQL Server 2012 -> JDBC Drivers

I have already created a system DSN through ODBCAD32.exe. In fact I created three, using different drivers for each

SQL Server
ODBC Driver 11 for SQL Server
SQL Server Native Client 10.0

Can someone please provide instruction on how I make a connection to my SQL database from IDT.

Thanks
Gary

GJustG (BOB member since 2015-03-11)

2

You don’t necessarily need to go through setting up your own dsns. Set the preference to use server-side middleware - you can then ‘consume’ whatever your admins have setup without the need for fiddling around with drivers, dsns etc.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi Nick,

I have set my Secured Connections preference to use ‘Server Middleware’ in my IDT. However I am still only seeing the same options when trying to create a connection.

Any ideas?

Thanks
Gary

GJustG (BOB member since 2015-03-11)