When Business Objects BI 4 needs 64bit ODBC driver ?

[Former Member]

Our BOE 4.0 SP6 is running on a 64 bit Windows Server. We have migrated our Crystal Reports and Webi from XI R2 environment to BI 4.0.

Our reports are built on top of old .UNV universes.  The vendor database which these Universes use are MS SQL Server and Oracle.

Currently we have configured the 32 bit ODBC drivers for these databases in SysWOW64 folder of the server.

Random reports which i tested are running fine through Client tools as well as via Launchpad.

I learnt somewhere in the SDN forum that, Launchpad needs 64 bit driver to refresh the report?

But today when i spoke to a SAP support engineer he said, only Crystal Enterprise and those reports which are built on top of .UNX universes need 64 bit driver?

So i am confused.. which is correct? When BOE looks for a 64 bit driver? In my case as we dont have 64bit driver will all our reports would run fine?

Thanks !!

Kind regards,

Tilak

[Former Member · Accepted solution]

1. The Universe Design Tool needs 32-bit ODBC sources in order to create .UNV format universes. To do this, go via Start > Programs > Business Objects > BI Platform > "32-bit Data Source Administrator". This version points to %WINDIR%\SysWOW64\odbcad32.exe
2. In BI 4.0, the WebI Processing Server and Information Design Tool need 64-bit ODBC sources for .UNX format universes. To do this, type 'ODBC' in Start > Run menu on Windows 2008 (64-bit) Server. This Data Source Administrator points to %WINDIR%\System32\odbcad32.exe

Any reports/Dashbaords/Crystal built on UNX universes., needs 64 bit ODBC drivers. Both 32 bit and 64 bit ODBC drivers need to be named same.

[Former Member · Accepted solution]

Thanks Jawahar.

So to confirm what you said, all Webi reports which run on BI 4.0 Environment need 64 bit driver?

Am i correct?thanks..

[Former Member · Accepted solution]

Reports built on UNX universes, not based on UNV universes

[Former Member]

SAP BI4.0 Universe tools require a 32 bit middleware driver for universe creation.  A 32 bit odbc should be created in the \Windows\SysWOW64\odbcad32.exe and a 64 bit middleware is required for Server - Reporting.

Both Entries in the ODBC DSN should be identical.

[Former Member]

For report creation in WEBI 4.0 I have created universe in .unv and database is oracle 10g 32 bit. My system is windows 2008 server 64 bit. Oracle was successfully installed and I have created universe and rich client report. I want to know whether oracle 10g 32 bit will support for webi or not.