Show TOC

Creating an ODP Source SystemLocate this document in the navigation structure

Prerequisites

  1. You have made the following settings in Customizing, under Start of the navigation path SAP NetWeaver  Next navigation step Business Warehouse Next navigation step Links to Source Systems End of the navigation path:

    • General connection settings

    • Perform automatic workflow Customizing

  2. As a rule, system changes are not permitted in production systems. Connecting a system as a source system to a BW or connecting a BW to a new source system results in changes in terms of system change options however. Therefore, in the client used in the BW system, make sure that the following changes are permitted during the source system connection:

    • Cross-client Customizing and repository changes

      In Customizing, under Start of the navigation path SAP NetWeaver Next navigation step Business Warehouse Next navigation step Links to Source Systems Next navigation step General Connection Settings Next navigation step Assign Logical System to Client End of the navigation path, select the client in question and choose Start of the navigation path Goto Next navigation step Details End of the navigation path. In the Cross-Client Object Changes field, select Changes to Repository and Cross-Client Customizing Allowed.

    • Changes to the local developments and Business Information Warehouse software components

      You use transaction SE03 (Organizer Tools) to set the change options. Choose Start of the navigation path Organizer Tools Next navigation step Administration Next navigation step Set System Change Option End of the navigation path. Choose Execute. On the next screen, make the following settings:.

    • Changes to the customer name range

      You also use transaction SE03 to set the change option for the customer name range.

    • Changes to BW namespaces /BWC/ and /BW0/

      You also use transaction SE03 to set the change option for the BW namespaces.

  3. If you want to connect an SAP Business ByDesign system: Make sure that you have the required information and that the required settings have been made in the BW system.

    More information: Notes about transferring data from SAP Business ByDesign systems using ODP

  4. If you want to connect a source using SAP Landscape Transformation Replication Server (SLT), make sure that the connection to the data source has been set up on the SLT.

    More information: Transferring Data from SLT Using Operational Data Provisioning

Procedure

  1. In the source system tree in the Data Warehousing Workbench, choose Create in the context menu for the ODP folder.
  2. In the Logical System Name field, enter a technical name for the source system.
  3. Enter a description for the source system.
  4. Choose Continue (Continue).
  5. In the next dialog box, specify whether the connection should be made using RFC or HTTP/SOAP and configure the connection parameters accordingly. Communication with SAP HANA could be via RFC for example, while communication with SAP Business ByDesign could be via HTTP/SOAP.

    • RFC

      If you have selected RFC, the system displays the destination maintenance screen for connection type ABAP, where you can enter the destination parameters. If the background user already exists in the source, enter this user when configuring the destination. Save and test your destination and then go back.

      More information: Maintaining Remote Destinations

      Note

      If you want to connect a SAP HANA database to BW as the source system, enter the destination parameters here for the ABAP system that is running on the SAP HANA database.

      More information: Notes about transferring data from SAP HANA using ODP

    • HTTP/SOAP

      If you have selected HTTP/SOAP, another dialog box appears that guides you to the Web service configuration screen in SOA Manager (or lets you check whether a Web service configuration/logical port already exists).

      In the Web service configuration screen, you create and configure a logical port for the default consumer proxy CO_RSDSPX_ODP_IN. Check and save the consumer proxy and go back to the Data Warehousing Workbench.

      More information: Configuring the Consumer Proxy

      Note

      Note the special information about connecting a SAP Business ByDesign system.

      More information: Notes about transferring data from SAP Business ByDesign systems using ODP

  6. The source system is now displayed under the ODP folder in the Data Warehousing Workbench.
  7. Assign the appropriate context to the ODP source system.

    The context in the ODP framework describes a non-local SAP repository that maps its metadata in the ODP framework. The context can be compared with a schema in a database.

    The source determines which contexts are available. The following is a list of possible contexts:

    SAP Repository Context
    BW System (for Data Mart Scenario) BW
    SAP System with DataSources (Extractors) SAPI
    SAP HANA Database of an ABAP System HANA
    SAP System via SAP Landscape Transformation Replication Server SLT~<Queue Alias>
    SAP Business ByDesign BYD

    1. To assign the source system to a context, choose Select Context in the context menu for the source system.

      The system displays a list of available contexts for the source system.

    2. Select the relevant context and choose Apply.

  8. For HTTP/SOAP: Close the SOA Manager.

Results

You can now create DataSources for this source system.