Defining an SAP OData Connector job

Learn how to design the SAP OData Connector job to extract data from the supported SAP On-Premise and S/4HANA Cloud application.

Defining a connection to SAP
Define the SAP Gateway details of the SAP system with which data need to be extracted through its exposed OData services.
Defining an SAP OData service and entity for extract or load
Define the SAP OData Service and entity set for which you want to extract or load data from SAP system. For extracting multiple related entities, use the Join stage as described in technote 0958299.
Defining columns metadata
You must ensure that for the metadata for the selected OData Service and its associated entity-set(s) for which data need to be extracted, has been imported into DataStage staging area.
Defining input data for deep insert
You must ensure to define input data for the deep insert function.
Compile and run the job
You compile SAP OData connector jobs into executable scripts that you can schedule and run.
Enabling additional logging
Starting from Pack version 8.2.0.4, you can make use of the environment variable, CC_MSG_LEVEL in OData Connector stage to produce additional level of logs for troubleshooting purpose.

Parent topic: SAP OData Connector stage