SAP Odata Setup Guide In Dev
Follow our setup guide to connect SAP Odata to your destination using the Fivetran connector.
Prerequisites
To connect your SAP OData API to Fivetran, you need:
- An SAP Communication or System user with the permissions and authorizations specified in the Configure SAP user section
- The hostname or IP address of your SAP application server
- The HTTPS port configured on your SAP system
- The username and password associated with the SAP user
- The exposed OData services (based on CDS views) that you want to extract data from
Setup instructions
Configure SAP user
This section lists the authorizations that you must assign to an SAP Communication or System user to access SAP Gateway services and extract data from Core Data Services (CDS) views. These authorizations cover:
- OData services
- Batch jobs
- Fivetran connectivity
- CDS views
- Business Warehouse (BW) extractors
- OData catalog
To access SAP Gateway services, you need the authorization object S_SERVICE. This object contains two fields, SRV_NAME and SRV_TYPE, which you must configure with encoded values. Locate and reference the encoded values for these fields using the SAP standard dialog (TADIR entries).
For troubleshooting, use the USOBHASH table to identify missing authorizations.
Authorization for OData services
Assign the following authorizations to allow user access to OData endpoints:
| Authorization Object | Authorization Field | Authorization Value |
|---|---|---|
| S_SERVICE | Program ID | R3TR |
| Object Type | IWSG | |
| Object Name | <Service Group Name> | |
| S_SERVICE | Program ID | R3TR |
| Object Type | IWSV | |
| Object Name | <Service Name> |
Authorization for batch jobs
SAP data extraction runs as background jobs. Assign the following authorizations to enable the creation and release of these jobs:
| Authorization Object | Authorization Field | Authorization Value |
|---|---|---|
| S_BTCH_ADM | BTCADMIN | Y |
| S_BTCH_JOB | JOBACTION | RELE |
| JOBGROUP | * |
Authorization for Fivetran connectivity
Fivetran requires access to the service group ZGWSAMPLE_BASIC to verify connectivity. Assign the following authorizations:
| Authorization Object | Authorization Field | Authorization Value |
|---|---|---|
| S_SERVICE | Program ID | R3TR |
| Object Type | IWSG | |
| Object Name | ZGWSAMPLE_BASIC_0001 |
Authorization for data extraction
Assign the following authorizations to extract data from CDS views:
| Authorization Object | Authorization Field | Authorization Value |
|---|---|---|
| S_DHCDCSTP | DHCDCSBTYP | ODP |
| ACTVT | 03 |
Authorization for OData catalog
Assign the following authorizations to access the OData catalog service:
| Authorization Object | Authorization Field | Authorization Value |
|---|---|---|
| S_START | AUTHPGMID | R3TR |
| AUTHOBJTYP | G4BA | |
| AUTHOBJNAM | /IWFND/CONFIG |
Finish Fivetran configuration
In the connector setup form, enter the Destination schema name of your choice.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
In the SAP OData Username field, enter your SAP system username.
In the SAP OData Password field, enter the password associated with your SAP system username.
In the SAP OData Hostname field, enter your SAP system hostname.
In the SAP OData Port field, enter your SAP system port number.
Click Save & Test. Fivetran will take it from here and sync your SAP OData data.