This guide will provide all the details required to setup SSO between Business Objects and SAP BW.

Here are the steps that need to be accomplished

  1. Generate keystore and certificate for SAP BO BI4.0
  2. Import SAP BO BI4.0 certificate into SAP BW
  3. Setup of SAP SSO Service in SAP BO BI4.0 CMC
  4. Setup of SSO against SAP BW for SAP BO BI4.0 BICS or JCO connections

 

  1. Generate keystore and certificate for SAP BO BI4.0
  • Log into the server
  • Bring up the command prompt and browse to the following location <INSTALLDIR>SAP BusinessObjects Enterprise XI4.0javalib

     

  • Run “<INSTALLDIR>SAP Business ObjectsSAP BusinessObjects Enterprise XI 4.0win64_x64sapjvmbinjava” -jar PKCS12Tool.jar -alias mybo -storepass admin123 -dname CN=BOTEST -validity 2555

     

This will generate the cert and keystore file

 

 

  1. Import SAP BO 4.0 Certificate into SAP BW
    1. Send the Binary import cert.der over to the Basis/Netweaver team
    2. Using the t-code STRUSTSS02 the Basis/Netweaver will import the certificate

       


    3. Make sure that cert.der is imported Binary into System PSE


    4. Add the Certificate to the certificate list, click button ‘Add to Certificate List’


    5. Add the certificate to ACL

      Click button ‘Add to Certificate to Access Control List

      Enter System ID – This System ID will be used in BI4.0 CMC to setup of SAP SSO Service

       


       

 

 

  1. Setup of SAP SSO Service in SAP BO BI4.0 CMC
  • Log into the CMC
  • Go to Authentication and click on SAP


 

  • Fill out your system information and click the Update button
  • Import Roles, Add All roles and bring them over to the right hand side

     

  • Verify SAP Authentication is enabled

  • Import keystore keystore.p12 file

    All this information should have been gathered when generating the certificate

     

     

  1. Setup of SSO against SAP BW for SAP BO BI 4.0 BICS or JCO connections
    1. Open the Information Design Tool (IDT)


       

    2. Create an SAP Connection


       

    3. Create an OLAP Connection


       

    4. Select SAP BICS Client

       

       


       

       

    5. Select SAP BICS Client

       

       

    6. Select the cube you would like to use for the query


     


     

     

    1. Open Web Intelligence and create a new report by select a Bex query as a data source


       

      You will now be able to use your data source that will utilize single sign on

       

These are the steps to configure Business Objects 4.0 single sign on with SAP BW. There are quite a few steps so if you have any questions please don’t hesitate to contact me @ info@vynesolutions.com