You can use Operational Data Provisioning (ODP) to connect SAP Business ByDesign system as the source system to the BW system. The communication is via HTTP/SOAP (Web Service). With the ODP context for SAP Business ByDesign (BYD), analysis views, SAP Business ByDesign data is provided for replication into BW. If you are using SAP Business ByDesign in the cloud for subsidiaries of your company, you can integrate local data from SAP Business ByDesign systems and business data from SAP ERP in SAP BW for analysis purposes.
Prerequisites for Creating an ODP Source System
To configurate the connection in the BW system, you need the following information from SAP Business ByDesign:
WSDL (Web Services Description Language) file
This file is needed in order to set up communication between SAP Business ByDesign and the BW system. When creating the ODP source system in BW, you specify this WSDL file in the SOA Manager in order to set up the Web service.
Certificates for a secure connection between SAP Business ByDesign and SAP BW:
GTE CyberTrust Global Root certificate
Cybertrust SureServer Standard Validation CA certificate
These certificates need to be imported into the BW system using the Trust Manager (transaction STRUST) before you start creating the ODP source system.
Depending on the authentification method that you have agreed with SAP Business ByDesign, you need the following information about the credentials for the user who communication is set up for:
Authentification method |
Information |
SSL Client Certificate |
PKCS#12 key pair file with corresponding password This PKCS#12 key pair file needs to be imported into the BW system using the Trust Manager (transaction STRUST) before you start creating the ODP source system. |
User ID and password |
User ID and password |
Make sure that ICF service APPL_SOAP_MANAGEMENT is active.
More information: Activating/Deactivating ICF Services
Web Service Configuration in the SOA Manager
In the Web Service Configuration in the SOA Manager, you create and configure a logical port for the default consumer proxy CO_RSDSPX_ODP_IN.
For SAP Business ByDesign systems, once you have entered a name and description for the new logical port, select WSDL-Based Configuration as the configuration type and enter the WSDL access setting and the WSDL location. Enter the user name and password under Configuration of the Logical Port on the Consumer Security tab.
More information: Configuring the Consumer Proxy
Note the following: