SAP ABAP IMG Activity BW_UDI_SYSTEM (Create Connector System in the Portal)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-WHM (Application Component) Warehouse Management
     RSIMG (Package) IMG Texts and Release Notes
IMG Activity
ID BW_UDI_SYSTEM Create Connector System in the Portal  
Transaction Code S_BR9_97000026   (empty) 
Created on 20050720    
Customizing Attributes BW_UDI_SYSTEM   Create Connector System in the Portal 
Customizing Activity    
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name BW_UDI_SYSTEM    

Use

In this activity, you can create a connector system in the portal. The system is entered in the Portal System Landscape Directory.

Requirements

Standard settings

Activities

To create the connector system in the portal, execute the following steps:

Create system:

  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.
  3. Choose New -> System (from Template) -> System in the context menu of the portal content. Choose com.sap.portal.systemy.BIUDI.
  4. Choose the relevant system as the portal component
  5. Enter a name, ID, and prefix.
  6. Choose Next and Exit.

Maintenance of the system properties

You have to maintain different properties depending on the type of connector system.

For BI JDBC systems:

  1. Open the object so you can edit its properties.
  2. Under Connection Properties, enter the connection URL of the database with the database name (for example: jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind) and enter the driver class name.
  3. Under Type of User Assignment, enter admin,user.
  4. Enter a system alias in the system alias editor.
  5. Save your entries.

For BI SAP query systems:

  1. Open the object so you can edit its properties.
  2. Under Connection Properties, enter the application server, the message server, the client, and the system number.
  3. Under Query Area, specify where the data comes from. X means cross-client, and no X means client-specific.
  4. Under Info, enter a description and a name.
  5. Under Type of User Assignment, enter admin,user.
  6. Enter a system alias in the system alias editor.
  7. Save your entries.

For BI ODBO systems:

  1. Open the object so you can edit its properties.
  2. Under Connection Properties, enter the connection string.
  3. Under type of User Assignment, enteradmin,user.
  4. Enter a system alias in the system alias editor.
  5. Save your entries.

For BI XMLA systems:

Prerequisite: First of all, specify the connection URL of the XMLA service.

  1. Go to the ICM monitor.
  2. Choose HTTP or HTTPS as the service.
  3. Assemble the first part of the URL from the protocol, host name and port.
  4. Call transaction SICF.
  5. Display the XMLA service. The path of the service is displayed. Take the part of the path after /default_host/ and attach it to the first part of the URL.
  6. Add xmla to the end of the URL to complete it (for example: http://iwdf9484.wdf.sap.corp:54080/sap/bw/xml/soap/xmla)

Editing the properties:

  1. Open the object so you can edit its properties.
  2. Under Connection Properties, enter the URL that you specified as a prerequisite as the server URL.
  3. Under Type of User Assignment, enter admin,user.
  4. Enter a system alias in the system alias editor.
  5. Save your entries.

Example

Business Attributes
ASAP Roadmap ID 262   Technical and Graphical Settings 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG BW_UDI_SYSTEM 0 ARS0000025 SAP Business Information Warehouse 
Maintenance Objects
Maintenance object type    
History
Last changed by/on SAP  20050720 
SAP Release Created in 700