SAP ODP Connector

The ODP Connector provides connectivity to the SAP ODP framework, exposing data artifacts such as Extractors, CDS views and SAP HANA Information views.

Prerequisites

The following section describes the prerequisites for working with the SAP ODP connector.

General prerequisites

ODP API

The SAP ODP connector uses ODP API 2.0 which is available from the following SAP basis levels and above:

• PI_BASIS 730 SP 14 (part of SAP NetWeaver 7.30 SP 14)

• PI_BASIS 731 SP 16 (part of SAP NetWeaver 7.03 SP 16 and 7.31 SP 16)

• PI_BASIS 740 SP 11 (part of SAP NetWeaver 7.40 SP 11)

• SAP_BW 750 SP 0 (incl. former PI_BASIS packages)

For more information, see SAP Note 1931427.

For information on how to release extractors so that they are available for the ODP API, see SAP Note 2232584.

STXL Table support

To expose the table STXL for extraction using the SAP ODP connector, a custom extractor needs to be created in transaction RSO2 in SAP GUI. This extractor can then be called by the SAP ODP connector.

Setting up SLT on SAP

In order to replicate data, you must first define the parameters that SAP Landscape Transformation Replication Server will use to replicate data from a source system to a target system. You specify this information in a configuration. A configuration contains information about the source system, the target system, and the relevant connections.

You create a configuration in SAP Landscape Transformation Replication Server system. To create a configuration, open the SAP LT Replication Server Cockpit (transaction LTRC) and choose Create Configuration.

Creating a configuration involves the following steps:

1. In the Specify General Data tab, provide the following information:

   • Configuration Name: You must specify a name for the configuration. This name is used for the schema that is created automatically in the target system.

   • Description (Optional): Optionally, specify a description for the configuration.

2. In the Specify Source System tab, select the RFC Connection option and provide the following information:

   • RFC Destination: Enter NONE.
   • Allow Multiple Usage: Select this option.

3. In the Specify Target System tab, select the Other option and provide the following information:

   • Scenario: Select Operational Data Provisioning (ODP) from the drop-down list.
   • Queue Alias: Specify a name.

4. In the Specify Transfer Settings tab, specify transfer settings appropriate for your environment. Under Job Options, we recommend setting at least five Data Transfer, Initial Load, and Calculation Jobs.

5. In the Review and Create tab, review your settings and create the configuration.

6. Grant the SAP ODP Connector user configuration.

Supported objects

The SAP ODP connector supports the following Contexts:

• ABAP Core Data Services (CDS) views: The context of the CDS views. This is the default ODP context.

• SAP NetWeaver Business Warehouse: The context of the BW

  Information noteHierarchies are not supported.

• SAP DataSources / Extractors: The context of data sources and extractors.

• SAP HANA Information Views: The context of HANA views.
• SAP LT Replication (SLT): Required to work with a SAP Landscape Transformation Replication Server.