1930558 - How to utilize the 64-bit SAP BAPI driver with UNV universes in BI 4.x (Windows)

SAP BusinessObjects Business Intelligence Platform 4.0 (BI 4.0) introduces a 64-bit Web Intelligence Processing Server (WIPS) that can load 64-bit database drivers.  This greatly increases the resources available to the WIPS and benefited many database connection types.

There was no 64-bit Windows version of the SAP BAPI libraries with the initial release of BI 4.0 though so the WIPS process had to utilize the 32-bit Connection Server (CS32) for connectivity to SAP BAPI.

SAP BusinessObjects Business Intelligence Platform 4.1 SP01+ (BI 4.1.1.0) introduces an updated SAP BAPI driver for connectivity to SAP Business Warehouse (BW) on Windows.  This driver allows for the 64-bit WIPS server to load the SAP BAPI driver in process, or in Library mode as we call it instead of using the CS32 server.

NOTE:  In SAP BusinessObjects Enterprise XI 3.1 (XI 3.1) the Web Intelligence Processing Server was a 32-bit process so it could load this 32-bit BAPI driver natively and fetch data without utilizing a connection server process. We refer to this as loading the driver Inproc or in Library mode.

More details on the history of this can be found in the following KBA:

1756239 - Classic universes that use a BAPI connection to SAP BW use the 32-bit Connection Server on BI 4.0 for Windows

The latest Data Access Guides also have a chapter (7.11 SAP BW Connections) that talks about his new functionality.

Read more...

• SAP BusinessObjects Business Intelligence Platform 4.1 SP01 and higher
• Microsoft Windows Operating System
• SAP BW (BAPI) Datasource
• Universe (UNV)

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Enterprise XI 3.1

webi connectionserver connectionserver32 wiprocessingserver wireportserver bw oda mda unv bapi bics bex connectivity 64bit 32bit bit 32 64 driver migration upgrade , KBA , BI-RA-ODA , OLAP Data Access Components , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , How To