Overview
Replicate Preview provides support for OData services as both source and target endpoints in replication workspaces, currently limited to Snapshot (Refresh) replication mode. This article covers how to create OData datastores, add entities, and configure OData datastores as sources and targets at a high-level.
Supported Databases
Replicate Preview supports:
SAP S/4HANA Public Edition
OData services on any database that supports read/write operations
Prerequisites
Before creating a refresh replication for both source and target using an OData endpoint, ensure that you complete the following configurations:
OData Datastore and Connection: An OData datastore and connection needs to be created in the required system in the Catalog module. Refer to Create a Connection and Connecting Via OData for more information on how to create a datastore connection for OData.
Note
Selecting an OData connection disables the database and schema fields, and the schema defaults to OData.
Add OData Entities as Tables: Currently, the Syniti Knowledge Platform (SKP) requires you to manually add OData entities as tables. Use the Service URL of the required entity to add tables to the OData datastore. Refer to the Add Tables to a OData Datastore section for more information.
Note
After adding entities (tables), a metadata scan is automatically triggered, importing all objects and their metadata into the datastore.
OData Endpoint as a Source
In Replicate Preview, create a source datastore using the OData datastore connection for the required target datastore in a replication workspace. Refer to the Creating Source Datastores section for more information.
Create the required replications either by using the Source Table Selection dialog box or by adding them manually.
OData Endpoint as a Target
Note
Entities (tables) must be added to the OData Datastore, as Replicate Preview cannot automatically create them.
In Replicate Preview, create a target datastore using the OData datastore connection in a replication workspace. Refer to the Creating Target Datastores section for more information.
Syniti recommends creating replications manually so you can choose to which OData entity you want to move data from a source table.
