SL SDK, 32-bit DLL with 64-bit db

[Former Member]

Trying to retrieve a UNX universe using the 4.1 Semantic Layer SDK.

Apparently, we need to use the 32 bit DLLs if the universe is uses a

32-bit Driver. It fails if we are using 64 bit DLLs.

Question is:

    If a UNX universe is using a 64 bit db and DSN, does it require that we

    use the 64 bit SL SDK DLLs to retrieve metadata? Or can this be done

    using the 32 bit DLLs.

[Former Member · Accepted solution]

Hello Murtuza,

In BI 4.1 SP3, you can use the JDBC connectivity for 64-bit database. With respect to the the database, you can use either 32bit or 64 bit BO DLLs in your environment path variable. You also have an option to use 32 bit or 64 bit JDK.

I believe we cannot use the above workflow in case of 64 bit ODBC drivers because IDT is a 32 bit client tool & it cannot access the 64 bit ODBC Data Sources.

Hope it helps.

Thanks,

Shailendra

[Former Member]

Hello Dr. Murtaza,

This is a very interesting question.

I also don't get it, as the BOXI client tools (e.g. Information Design Tool) runs in a 32 bit boxi installation. This installation only has the 32 bit binaries (Windows win32_x86).

It would be great if someone from SAP with expertise could answer your question.

Thanks,

Bernd

[Former Member]

Hi Bernd

This is for BOBJ 4.1 which ships with both 32 and 64 bit DLLs. I was unable to load the UNX universe

metadata using the SL SDK wit 64 bit libraries. The support response what that when the underlying db

is 32-bit and access is thru 32-bit ODBC, we can only use the 32-bit DLLs.

So, my question is whether I can do the reverse? i.e. use 32-bit DLLs to retrieve Semantic Layer

metadata from a UNX universe based on a 64 bit db?

Thanks

[former_member4998]

Hi

Please check the below links.

http://scn.sap.com/docs/DOC-32303

http://wiki.scn.sap.com/wiki/display/BOBJ/How+to+Install+the+BI+Platform+4.0+.NET+SDK+on+a+Developme...

http://scn.sap.com/community/bi-platform/blog/2013/10/08/explorer-performance-and-stability-enhancem...

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/10/24/finally-a-64-bit-drive...

[Former Member]

Hello Sreenivasulu,

The links you posted do not help answering the question from Dr. Murtaza.

Bernd