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. In the client used in the BW system, you have therefore made 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 of the Data Warehousing Workbench, select the ODP folder for the required context.

    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 following folders are available:

    ODP Folder Context
    ODP - BW BW
    ODP - SAP (Extractors) SAPI
    ODP - SAP HANA Information View HANA
    ODP - SLT Queue SLT~<Queue Alias>
    ODP - ABAP CDS View ABAP_CDS
    ODP - SAP Business ByDesign BYD
  2. In the folder context menu, choose Create.
  3. A dialog box opens. Enter a technical name and a description for the source system under Logical System Name.
  4. Press Continue.
  5. A dialog box opens where you can configure the connection parameters. For most of the ODP contexts, RFC is used for the connection. For SAP Business ByDesign systems, HTTP/SOAP is used for the connection.

    • RFC

      The destination maintenance screen for connection type ABAP opens. Specify 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

      Another dialog box opens 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.

      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 dialog box ODP Source System <Logical System Name> opens. Here you can make the following entries:
    • The system displays the context selected previously under ODP Context. Here you can change the context again if required. The source determines which contexts are available.

      For SAP Landscape Transformation Replication Server (SLT), select the context for the required queue alias. The queue alias describes the source configuration for data provisioning in SLT.

    • Under Removed Tree, you can specify for specific sources, which deliver a hierarchical grouping of source objects (tree), whether the grouping should be copied to the DataSource tree for the source system. If you do not copy the tree from the source or the source does not deliver a hierarchical grouping, then the application components defined for the non-replicated source systems are used as the grouping for the DataSource tree.
    • Under BW Background User and User Password enter a background user and set a password. If the user already exists in the source system, enter the corresponding password.

      The user is required for verification. The system uses the user name to create a destination with the naming convention <BW system ID>CLNT<client of BW system>. When settings are saved, the destination checks whether the source system only delivers data to one BW system or to multiple BW systems with the same name. if the source system delivers data to multiple BW systems with the same name, this can cause problems during a system copy.

  7. Press Save (save settings).
    The system now checks the source system to find out whether the BW system is a unique subscriber. If this is not the case, an error message is displayed.
  8. The source system is now displayed under the relevant ODP folder in the Data Warehousing Workbench.
  9. For HTTP/SOAP: Close the SOA Manager.

Results

You can now create DataSources for this source system.