Friday, 16 November 2012

OBIEE 64 bit or 32 bit Admin Tool and ODBC BI Server Connections

Oracle Business Intelligence Developer Client Tools Installer (11.1.1.6.0) is available for 32 bit and 64 bit mode. The installable can be found on oracle TechNet.


This is an attempt to explain which ODBC Administrator on Windows 64 bit operating system and when while defining BI Server ODBC connection.

On a Windows 7x64 operating system Microsoft delivers two tools for ODBC Administration - one for 32-bit ODBC connections, one for 64-bit ODBC connections.

You will have to use two different links to administer the ODBC connections:

64-bit ODBC: C:\Windows\System32\odbcad32.exe
32-bit ODBC: C:\Windows\SysWOW64\odbcad32.exe

When installing BI Admin tool this will install the ODBC driver as well which is by default is a 32 bit with standard installation of OBIEE 11g. As client is 32 bit you will see this in the 32 bit ODBC administration. If you install 64-bit Admin client the driver will show up in 64-bit administration.

I would recommend if you have 64-bit environment go with 64-bit version of Admin tool.

I have been working on a migration project from OBIEE 10g to 11g, one of the interesting things which I have found out is that excel ODBC connection which uses BI Server ODBC does not work anymore with OBIEE 11g … there is a work around which I would discuss in next blog.

No comments:

Post a Comment