Showing posts with label BW. Show all posts
Showing posts with label BW. Show all posts

Sunday, July 12, 2009

Importing the SAP Basis Plug-In

To integrate between SAP BW 3.5 and SAP EP 6.0 (especially for SAP role upload), you need to import the SAP Enterprise Portal Plug-In (PI_BASIS).


As of SAP Web Application Server 6.40, the SAP Enterprise Portal Plug-In is part of SAP Basis Plug-In. For more information, see SAP note 723189.

Procedure

1. Download the SAP Basis Plug-In (PI_BASIS) from the SAP Software Distribution Center in the SAP Service Marketplace (quick link SWDC).

2. Start the Transport Management System(transaction code STMS).

3. Import the SAP Basis Plug-In into the BW system.

Check

You can do a check when you upload BW roles into the portal. For more information.

For more information, see SAP note 655941.

Setting Up the Repository Manager for BW Documents and BW Metadata

Documents and metadata created in SAP BW (especially documentation for metadata) can be integrated into the Knowledge Manager of the SAP Enterprise Portal using the Repository Manager. There they are displayed together with other documents for the end user in a directory structure.

The documents are located in the BW system. The Repository Managers enable access to these documents within the portal using Knowledge Management. The variegated functions of Knowledge Management can be applied to these documents (feedback, rating, text search and so on).

The Repository Managers for BW documents and BW metadata are especially useful for two scenarios:

· BEx Web Application as a Link in Knowledge Management .

· BW documents and BW metadata.


Note that Repository Managers cannot be used for navigating in Knowledge Management unconditionally. Because of the flat folder hierarchy, a directory can contain a very large number of objects (for example, all queries for a system) and displaying the documents in a KM navigation iView can lead to problems in terms of performance.

For more current information, see SAP note 702350.

Procedure

1. Log on to the portal.

2. Start the iView System Administration ® System Configuration ® Knowledge Management ® Content Management.

3. Choose Content Management ® Repository Managers.

4. Under Classes, choose BW Document Repository.

5. Create a new instance of the BW Document Repository and choose New.

6. Enter settings as required. For more information on what the individual parameters mean, see Repository Manager for BW Documents.

7. Choose OK to save the settings.

8. Under Classes, choose BW Metadata Repository.

9. Create a new instance of the BW Metadata Repository and choose New.

10. Enter settings as required. For more information on what the individual parameters mean, see Repository Manager for BW Metadata.

11. Choose OK to save the settings.

Check

Start the iView Content Administration ® KM Content. Open the Knowledge Management folder for the BW documents and the folder for the BW metadata. The names of the folders correspond to the prefixes entered above.

Exporting the Portal Certificate in BW

The portal certificate is needed for displaying content from SAP BW in the portal and has to be imported in the BW system (see Importing Portal Certificate).

Procedure

To export the portal certificate from the J2EE engine, follow these steps:

1. Start the SAP J2EE Engine Administrator with \admin\go.bat.

2. Connect to the portal server.

3. Choose /Server<…>/Services/Key storage from the tree.

4. Select the view TicketKeystore under Views.

5. If the SAPLogonTicketKeypair-cert is not available under Entries, generate a portal certificate using the following steps. Otherwise you can continue with the export under step 9.

6. Under Entry, choose Create.

Enter the following values in Key and Certificate Generation:

¡ Subject properties: Every key has to have a value under Value.

The value CN=Common Name is displayed as the owner in transaction STRUSTSSO2 and serves to identify the certificate. SAP recommends that you use from the portal server.

¡ Entry name: SAPLogonTicketKeypair (the entry SAPLogonTicketKeypair-cert is generated automatically)

¡ Store certificate: X

¡ Algorithm: DSA

7. Choose Generate to generate the certificate.

8. Highlight SAPLogonTicketKeypair-cert under Entries.

9. Under Entry, choose Export.

10. Export the portal certificate as _certificate.crt in file format X.509 Certificate (*.crt).

Result

The exported portal certificate can then be imported into the BW system. For more information, see Importing the Portal Certificate.

If you want to connect multiple portals with the same system ID to a BW system, you have to maintain the login.ticket_client parameter:

Configuring User Management in BW

You need to make several settings in user management of the portal to enable single sign-on between SAP BW 3.5 and SAP EP 6.0.

The SAP reference system is required for communication from the BEx tools in the portal. Maintenance of a SAP reference system is only necessary when the technical user names in SAP BW and SAP EP are different and user assignment is necessary. You can makes sure that the user names are identical using the central user management. For more information on the SAP EP side of this, see User Management Engine and UME Data Sources. On the SAP BW side, you can find more information about centralized user management at Directory Services (BC-SEC-DIR).

For more information, see Security.

Procedure

1. Log on to the portal.

2. Start the iView System Administration ® System Configuration ® Configuration for User Management.

3. Choose the Security Settings tab page.

4. Under SAP reference system, enter the standard system alias of the BW system (see Creating a BW System in the Portal).

5. Save your entries.


Only one system can be specified as the SAP reference system. The SAP reference system does not have to be the BW system. However, if it is not the BW system, the technical user name of the BW system has to be identical with the technical user name of the SAP reference system.

If you want to connect multiple portals with the same system ID to a BW system, you have to maintain the login.ticket_client parameter:

...

1. Log on to the portal.

2. Start the iView System Administration ® System Configuration ® Configuration for User Management.

3. Select the Direct Editing tab page.

4. Insert the following line: login.ticket_client=

5. Save your entries.


You can select any value between 000 and 999 as the . The client is necessary if several portals with identical portal SIDs are connected. The client has to be entered when you import the portal certificate into the BW system on future occasions.


After making changes to user management in SAP EP, you have to restart the J2EE Engine with SAP EP.

End of Content Area

Creating BW Systems in the Portal

The BW system must be set up in the portal so that content from SAP BW can be displayed in it. The system is entered into the Portal System Landscape Directory.

This setting is required for all integration scenarios (see Integration from the Viewpoint of Administrators and Authors).

Procedure

1. Log on to the portal.

2. Start the iView System Administration ® System Configuration ® System Landscape.


The systems are maintained with the Portal Content Studio. For more information about using the Portal Content Studio, see Integration Using the Portal Content Studio.

3. Choose New ® System in the context menu of the Portal Catalog.

4. Depending on the system landscape, choose either the R/3 with Load Balancing (SAP_R3_LoadBalancing) or Dedicated Application Server for R/3-System (SAP_R3_Dedicated) as a template.

5. Maintain the most important properties with the property category Display All.

¡ Logon method: SAPLOGONTICKET or UIDPW

¡ Type of user assignment: admin,user

¡ Logical system name: CLNT


This is the recommended convention for logical system names, consisting of the system ID and the client.

¡ Remote host type: 3

¡ SAP client:

¡ SAP system ID (SID) (R/3 name):

¡ System type: SAP_BW

¡ System name: CLNT

¡ WAS description:

¡ WAS host name: :

¡ WAS path: /sap/bw/bex

¡ WAS protocol: http or https


All system entries refer to the BW system.

You can determine the WAS hostname, WAS path and WAS protocol settings using function module RSBB_URL_PREFIX_GET (transaction code SE37).

To use Drag&Relate, maintain the following properties:

¡ Admin User-ID (DQE):

¡ Admin password (DQE):


The Distributed Query Engine (DQE) executes the requests to the BW system with the Admin User above.

If you are using R/3 with Load Balancing (SAP_R3_LoadBalancing), you must also maintain the following properties:

¡ Group:

¡ Message server:

¡ Server port:


The server port is frequently maintained by system administrators on the local PC in the c:\windows\system32\drivers\etc\services file. The server port of the system is entered into the file as sapms.

If you are using a Dedicated Application Server for R/3 System (SAP_R3_Dedicated), you must also maintain the following properties:

¡ Application host:

¡ Gateway host:

¡ Gateway service:

¡ SAP system number:


The report Maintaining Settings for Integration into SAP Enterprise Portal (RSPOR_SETUP) determines most of the mandatory values for the above properties automatically.

6. Maintain an alias for the system in the System Aliases view.

A system alias in the format CLNT must exist, where is the system ID and is the client for the system. CLNT is predefined. In addition to the system alias in the format above, you can also maintain other system aliases.


During integration of SAP BW 3.5 and SAP EP 6.0, the system alias in SAP 3.5 must be entered into the table Connected Portals (see Maintaining Portal Server Settings for EP 6.0).

In order to use the example role Business , an alias must be maintained in SAP_BW. Multiple system aliases can be defined for a BW system.

7. Save your entries.

Check

With the Connection Tests you can check the settings above. However, only the SAP Web AS Connection and the Connection Test for Connectors.

Importing the BW Certificate

The BW certificate must be imported into the portal so that content from the portal can be displayed in SAP BW, such as the portal roles in the BEx Web Application Designer, for example.

Prerequisites

Before the BW certificate can be imported into the portal, it has to be exported from the BW system. For more information, see Exporting the BW Certificate.

Procedure

Follow these steps to import the BW certificate into the J2EE engine:

1. Start the SAP J2EE Engine Administrator with %INSTALLATION_ROOT%\admin\go.

2. Connect to the portal server.

3. In the tree, choose /Server<…>/Services/Key Storage.

4. Select the view TicketKeystore under Views.

5. Under Entry, click Load.

6. Open the file _certificate.crt.

Perform the following steps so that the SAP J2EE Engine accepts the SAP Logon Tickets from the BW system as an external system.

...

1. Start the SAP J2EE Engine Administrator with %INSTALLATION_ROOT%\admin\go.

2. Connect to the portal server.

3. In the tree, choose /Server<…>/Services/Security Provider.

4. Choose Ticket as Component.

5. Choose the Authentication tab page.

6. Change the options for the com.sap.security.core.server.jaas.EvaluateTicketLoginModule parameter and insert the following values:

○ trustedsys=, (for example, BWP, 000)

○ trustediss= (for example, CN= BWP, OU=I0020114583, OU=SAP Web AS, O=SAP Trust Community, C=DE)

○ trusteddn= (for example, CN= BWP, OU=I0020114583, OU=SAP Web AS, O=SAP Trust Community, C=DE)


is a number for all three entries, but must be incremented by one for every external system.

and are the system ID and the client of the BW system.

and correspond to the Own Certificate value in the transaction Trust Manager for Single Sign-On with Logon Ticket (transaction code STRUSTSSO2). The value trustediss corresponds to the value Issuer; the value trusteddn corresponds to the value Owner.

As of SAP BW 3.5 SP 11 in SAP NetWeaver SP Stack 11, you have to perform the following steps to use the Send SAP Logon Ticket option (see Creating an RFC Destination for SAP EP 6.0):

...

1. Start the SAP J2EE Engine Administrator with %INSTALLATION_ROOT%\admin\go.

2. Connect to the portal server.

3. In the tree, choose /Server<…>/Services/Security Provider.

4. Choose evaluate_assertion_ticket as Component.

5. Choose the Authentication tab page.

6. Change the options for the com.sap.security.core.server.jaas.EvaluateAssertionTicketLoginModule parameter and insert the following values:

○ trustedsys=, (for example, BWP, 000)

○ trustediss= (for example, CN= BWP, OU=I0020114583, OU=SAP Web AS, O=SAP Trust Community, C=DE)

○ trusteddn= (for example, CN= BWP, OU=I0020114583, OU=SAP Web AS, O=SAP Trust Community, C=DE)


The values correspond to the above values under Component Ticket.

Exporting the BW Certificate

The BW certificate must be generated in and exported from the BW system so that it can be imported into the portal afterwards. The BW certificate is needed in the portal so that portal contents can be displayed in SAP BW.

The various scenarios are described in detail from a security viewpoint under Security.

Prerequisites

You have set up Single Sign-On. For more information, see Maintaining Single Sign-On.

Procedure

1. Start the transaction Trust Manager for Single Sign-On with Logon Ticket (transaction STRUSTSSO2).

2. Choose your certificate. Your own certificate is located in the System PSE area in the Own Certificate field. When you double click on the field value, the certificate is displayed in the Certificate area. You can proceed with step 3 once the certificate appears in that area.


If your own certificate is not available, generate a certificate using create in the context menu of system PSE and distribute it using PSE ® Distribute All to all application servers for the BW system. There may be a time delay when distributing the certificate. If necessary, check whether the certificate has been successfully distributed.

3. In the menu, choose Certificate ® Export.

4. Enter the file path _certificate.crt ( is the system ID of the BW system).

5. Choose Binary as the file format.

The file _certificate.crt is used for the step Import BW Certificate in the settings in SAP EP 6.0.

Check

You can look at the _certificate.crt file using Windows Explorer.

End of Content Area