SAP BusinessObjects Enterprise & SAP Enterprise Po...

IngoH · ‎03-29-2010

In this short blog series I will explain the different options how you are able to integrate SAP BusinessObjects Enterprise based content – such as Crystal Reports, Xcelsius, Web Intelligence, or BusinessObjects Explorer – into the SAP Enterprise Portal.

Part 1 will be the technical pre-requisites
Part 2 will be about the SAP BusinessObjects iView template as part of the SAP Integration Kit
Part 3 will be about the URL iView option
Part 4 will be about the integration with the KM part of your SAP Enterprise Portal.

Part 1: Technical pre-requisites

Before we can start delivering content from our BusinessObjects Enterprise system via the SAP Enterprise portal we need to ensure the following items are setup and configured:

All involved system need to leverage a fully qualified host name and need to be in the same domain as otherwise the SSO token from the portal will expire right away
The SAP Enterprise Portal and the underlying SAP system, for example SAP NetWeaver BW, need to trust each other
The underlying SAP system need to be configured to accept SSO logon tickets from the portal
The SAP Authentication needs to be configured on the BusinessObjects Enterprise system
The involved web applications, such as InfoView, OpenDocument, and SAP BusinessObjects Explorer, need to be configured to use the SAP authentication as default authentication

Configuring Trust between your SAP Enterprise Portal and you SAP system

In this step we will configure the trust between the SAP system (in our example SAP BW) and the SAP Enterprise Portal.

Navigate to System Administration > System Configuration and select in the Detail Navigation the menu item Keystore Administration
!http://images.quickblogcast.com/7/7/2/6/3/245948-236277/chapter9figure2.jpg?a=72|alt=|src=http://ima...!
Make sure you select the tab Content.
Click the button Download verify.der File. You can download the certificate file and import it in the next step to your SAP NetWeaver BW system.
You might have to rename the file so that it become a ZIP file. Extract the content from the archive to your local disk.
Now logon to your SAP NetWeaver BW system with an administrative account and start the transactionSTRUSTSSO2.
In the Trust Manager on the left side open the folder for the entry System PSE.
!http://images.quickblogcast.com/7/7/2/6/3/245948-236277/chapter9figure3.jpg?a=11|alt=|src=http://ima...!
Now use the button Import Certificate (bottom left corner) and import the file we downloaded from the SAP Enterprise Portal previously.
!http://images.quickblogcast.com/7/7/2/6/3/245948-236277/chapter9figure5.jpg?a=64|alt=|src=http://ima...!
Select the file and use the option Binary.
After you uploaded the file use the button Add to Certificate List.
Then click the button Add to ACL.
A popup screen is shown and you need to enter the System ID of your portal and enter 000 for the client field.
!http://images.quickblogcast.com/7/7/2/6/3/245948-236277/chapter9figure6.jpg?a=59|alt=|src=http://ima...!
You now imported the portal certificate into your SAP NetWeaver BW system and established trust between both systems

Accepting SSO Tickets

For the SAP system to be able to leverage the SAP Enterprise portal token means, that the profile parameters need to be configured for Single Sign On. You can leverage transaction RZ10 to edit or add new profile parameters, but please keep in mind that changing or adding values will require a restart of your SAP system.

In your SAP system, in our example SAP NetWeaver BW, make sure the following profile parameters are configured:

Profile parameter

Value

Comment

login/create_sso2_ticket	1 or 2	Use the value 1 if the server possesses a public-key certificate signed by the SAP CA. Use the value 2 if the certificate is self-signed. If you are not sure, then use the value 2.
login/accept_sso2_ticket	1	Use the value 1 so that the system will also accept logon tickets.

Configuring SAP Authentication for BusinessObjects Enterprise

Parameter name

Configuration Value </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> authentication.default </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> secSAPR3 </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> siteminder.enabled </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> False </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> sso.enabled </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> True </td> </tr> </tbody></table> h4. OpenDocument 
For the Java version of OpenDocument (Windows environment) you need to edit the file web.xml, which is located (assuming Tomcat as application server) in the directory \Program Files\Business Objects\Tomcat55\webapps\OpenDocument\WEB-INF. In addition you can make the change to the file in the folder <INSTALLDIR>\BusinessObjects Enterprise12.0\warfiles\WebApps\OpenDocument\WEB-INF. The files in the second locations are being used when you redeploy the web applications with a tool like wdeploy. For the .Net version of OpenDocument you need to edit the file web.config, which is located in the directory \Program Files\Business Objects\BusinessObjects Enterprise 12.0\Web Content\InfoViewApp\OpenDocument. Make sure the following parameters are set <table border="1" cellspacing="0" cellpadding="0" style="border: medium none ; border-collapse: collapse"> <tbody><tr> <td width="242" valign="top" style="border: 1pt solid black; padding: 0in 5.4pt; width: 181.8pt"> Parameter name

Configuration Value </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> opendoc.authentication.default </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> secSAPR3 </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> opendoc.siteminder.enabled </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> False </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> opendoc.sso.enabled </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> True </td> </tr> </tbody></table> h4. SAP BusinessObjects Explorer
For SAP BusinessObjects Explorer you need to do similar changes like we did before for InfoView and OpenDocument. Navigate to the folder \Program Files\Business Objects\Tomcat55\webapps\polestar\WEB-INF\classes. This path is assuming an installation on Windows using Tomcat as application server. For Unix deployments the default path would be <INSTALLDIR>/bobje/enterprise120/java/applications .In case you are using a different application server or operating system make sure you navigate to the web application folder of your application server. In the file default.settings.properties make sure the following parameters are set: <table border="1" cellspacing="0" cellpadding="0" style="border: medium none ; border-collapse: collapse"> <tbody><tr> <td width="242" valign="top" style="border: 1pt solid black; padding: 0in 5.4pt; width: 181.8pt"> Property </td> <td width="242" valign="top" style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> Value </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> show.sapsystem.name </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> True </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> disable.sapsystem.name </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> False </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> show.sapclient.name </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> True </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> disable.sapclient.name </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> False </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> authentications </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> secEnterprise,secWinAD,secLDAP,secSAPR3 </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> hide.authentication.method </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> False </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> disable.authentication.method </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> False </td> </tr> <tr> <td width="242" valign="top" style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 181.8pt"> Default.authentication.method </td> <td width="242" valign="top" style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 181.8pt"> secSAPR3 </td> </tr> </tbody></table> These items cover the technical pre-requisites for showing content from your BusinessObjects Enterprise system in the SAP Enterprise Portal. In the next part we will use the BusinessObjects iView template to show content from our system in the portal. </ol>