Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member456023
Contributor
6,158

This article will go through the SAP BW and BI Platform integration process to trigger schedule from BW in the BI Platform


It should be noted that this topic has been covered before by Vishal Mour in this post
https://blogs.sap.com/2017/11/08/sap-bi-4.2-sp05-triggering-schedule-in-bi-platform-from-bw-part-1/


I assume, however, that some steps can be elaborated in detail to help users execute the steps easily.

Prerequisite
Before we start the BW and BI Platform integration, x509 certificate based trusted authentication should be enabled for REST SDK.


For configuration details refer below blog
https://blogs.sap.com/2017/06/06/trusted-x509-authentication-support-in-sap-businessobjects-platform...


Setup Process



Trust Between BW and BI Platform


Import WACS server certificate in BW trust store



  • When WACS is configured for https, simple step to get WACS server certificate

  • Launch WACS server https URL
    Ex – https://<WACS_Server_Host>:<SSL_Port>/biprws

  • Export https certificate from browser and save in .cer format and save any root certificate


In the SAP BW system, go to transaction “STRUST” and import the WACS server certificate into the SSL client SSL Client (Standard) and click the Add to Certificate List button, click on Save.




Import BW server certificate in BOE WACS server trust store


In the SAP BW system, go to transaction “STRUST” and export the server certificates from the SYSTEM PSE and SSL client SSL Client (Standard), choose binary as the format with and save with .crt extension (ex – Cert1.crt and Cert2.crt).



Import the above exported BW certificates using the following command into the BI Platform WACS server keystore truststore (WACS truststore should already be configured, as mentioned in the prerequisites)


Command
<sap_bobj_installed_dir>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin > keytool import -alias BW1 -file Cert1.crt -keystore <wacs_trust_keystore>


<sap_bobj_installed_dir>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin > keytool import -alias BW2 -file Cert2.crt -keystore <wacs_trust_keystore>



Restart WACS server



Create and Test http Destination in ABAP


Go to transaction SM59




  1. Select “HTTP Connections to External Server” and Choose Create


Enter a name
Under Technical Settings, make the following entries
Target host – This is the host that you want to connect to (WACS Server Host)
Service no – Here, you specify the port (WACS Server https port)





  1. Under Logon/Security, make the following entries


SSL - Active
SSL Certificate - Choose “DFAULT SSL Client (Standard)”



Click on Save



Test Connection


Click on Connection Test, if all the configuration steps are performed correctly, the test connection will show success.



The success response indicates that the Trust has been established between BW and BI Platform


Note – For SSL Communication, SAP BI Platform uses version TLS 1.2/1.1 The same needs to be    enabled in SAP BW system as well. Else due to cipher suite mismatch the connection might fail.


To enabled TLS v1.2 in SAP BW system, follow the blog below.


How to enable TLSv1.2 in SAP Netweaver ABAP


https://blogs.sap.com/2019/11/11/how-to-enable-tls-v1.2-in-sap-netweaver-abap/



Create BW Event and Assign to Report



  1. Login into CMC --> Events

  2. Under BW Events folder, create a new BW Event, provide the details and click ok. The event will be created



Note – We can create multiple BW Events based on the requirement, ideally one for each data           source such as Cube, DSO etc on which your BI Platform report is created.


3. Right click report and select schedule ---> Events ---> BW Events


You should be able to see the list of BW events created under Available Events.


4. Select the right event and move it under Events to Wait for



This completes the BW and BI Platform Integration Configuration, as well as configuring BW Events in BI Platform


For Part 2 – How to configure Process Type in BW


Follow below blog
https://blogs.sap.com/2017/11/08/sap-bi-4.2-sp05-triggering-schedule-in-bi-platform-from-bw-part-2/



Learn More:


https://blogs.sap.com/2018/02/28/saml-integration-between-microsoft-azure-portal-and-sap-analytics-c...


https://blogs.sap.com/2017/12/19/sap-analytics-cloud-saml-sso-using-adfs-active-directory-federation...


https://blogs.sap.com/2018/02/22/adfs-with-sap-business-intelligence-platform/


https://blogs.sap.com/2018/03/01/saml-integration-between-microsoft-azure-portal-and-sap-business-in...

10 Comments