Limitations and considerations

When using SAP ODP as a source endpoint in a Replicate task, be aware of the following limitations and considerations:

• The Replicate SAP OData endpoint supports services generated with SAP Gateway Service Builder for Extracting ODP Data via OData. Other types of service should meet the requirements for services generated with SAP Gateway Service Builder for Extracting ODP Data via OData.

  For more information, see Generating a Service for Extracting ODP Data via OData.

• OData Version 2.0 (V2) is supported only.
• An OData service with a single entity is supported. DeltaLinksOf<EntitySet> is supported for a delta enabled service.
• Service version 1.0 is supported only.
• Metadata changes are not supported. Any changes to the service metadata requires reloading the task.
• Each ODP subscription in the SAP system can be used for a unique service name and username. In other words, it is not possible to have multiple subscriptions for the same service and username. Any new task for the service and username will cancel the existing subscription and start a new one.

• Current data is the only supported mode, when the actual change operation (INSERT, UPDATE, or DELETE) is performed on the target.

  Information note

  • Changes operations are determined by the ODP source. Some operations might not be supported by the target.
  • We recommend manually setting a Primary Key for ODP sources that do not use the default Primary Key.

  • Some INSERTs are received as UPDATEs. Therefore, to prevent conflicts on the target, set the No record found for applying an UPDATE Apply Conflicts handling policy to INSERT the missing target record.

    For more information on this setting, see Apply Conflicts.

• GZIP compression requires HTTP 1.1 or later (HTTP/1.1)
• HTTPS is only supported with a host name. If there is no DNS name, add the IP address and host name to the local hosts file.
• For currency and unit of measure, the SAP NetWeaver Gateway framework always uses the type conversions (methods for outbound and inbound flow of CL_GDT_CONVERSION). Unit of measure and currency conversion always use the ISO code, as opposed to the desired unit or currency.For more information, see SAP notes 1893788 and 3082462.

• Due to the OData specification, each entity must have at least one primary key. If the source ODP entity has no primary keys, all columns in the service model will be generated as primary keys. You can set primary keys for a table (entity) as described in Using the Transform tab.

• The "Start from timestamp" and "Start from position" options for running tasks are not supported.
• The Allow unlimited LOB size" and "Optimize handling when LOB size is less than LOB handling options are not supported.
• Source lookup is not supported.

• The SAP OData endpoint uses the metadata of the OData service. Therefore, the target tables will be created with ODP-provided columns.

• Hierarchy objects and columns are not supported.

• When using the SAP ODP endpoint in a Log Stream configuration, Full Load replication is not supported.

SAP notes

If you encounter any of the issues listed below, make sure to upgrade your system to the SAP version that resolves the issue.