---
sourceDocument: Yokohama Build or modify applications
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/application-development

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Create an OData connection in ERP Canvas

# Create an OData connection in ERP Canvas {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

Create an OData v2 connection to link to SAP via HTTP so data can be extracted for use in remote tables and extraction tables.

## Before you begin

Role required: sn_erp_integration.erp_admin

For information about OData connections in ERP Canvas, see [Connect ERP Canvas to SAP using OData and HTTP](https://www.servicenow.com/docs/uIRHJSTlNNYPJ0Kds1FUVg "Extract data securely from ERP OData v2 APIs using ETL for use in remote tables and extraction tables. OData connects to SAP via HTTP.") and [OData capabilities supported by ERP Canvas](https://www.servicenow.com/docs/hWaxy_VMZOzwsM3B~CzhaA "Details about the OData v2 query capabilities supported in ERP Canvas.").

## About this task

An admin or a user with the sn_erp_integration.erp_admin role must enable the sn_erp_integration.enableModelModification property for you to edit, customize, and clone ERP models and tables. After enabling the sn_erp_integration.enableModelModification property, ERP Canvas retrieves all tables and BAPIs (Business Application Programming Interface) to use when managing models. The property must be configured for either a non-production or production state. System properties are maintained in the System Property table \[sys_properties\], which you can access using the module navigator, or directly typing <kbd class="ph userinput">sys_properties.list</kbd> in the Navigator Filter.  
Note:  
You must enable the sn_erp_integration.enableModelModification property on the correct scope. Enabling the sn_erp_integration.enableModelModification on a production instance can create new metadata records when new models and fields are added in ERP Canvas.

## Procedure

1. Confirm that you have an SAP system that has been enabled to make an OData connection.
2. Create a connection and credential alias, specifying HTTP as the Connection type.  
   For more information, see [Create a Connection \& Credential alias](https://www.servicenow.com/docs/access?context=connection-alias&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US).
3. Create an HTTP connection and associate it with the new alias.  
   Note:  
   For more information, see [Create an HTTP(s) connection](https://www.servicenow.com/docs/access?context=create-https-connection&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US). If you choose to use a MID Server, users with access to the services can use the same credential for RFC and HTTP.
4. Create a system with the HTTP connection.  
   For more information, see [Create an ERP system in ERP Canvas](https://www.servicenow.com/docs/7eKnkhO8VoKszalkV6Djgg "Configure an ERP (Enterprise Resource Planning) system in ERP Canvas to organize your connections to the system of record.").
5. On the system record, confirm that the heartbeats are successful and the retrieval status is complete.  
   If any have failed, select Restart data retrieval. Any data retrieval that failed (BAPI, OData, or tables) is fetched again.
6. Create a model and, after saving, open the model record.  
   For more information, see [Add a new ERP model](https://www.servicenow.com/docs/I4WAwkecVJVxLCvzIwWTSw "Add an ERP (Enterprise Resource Planning) model in ERP Canvas to create a data set that contains ERP tables from the system of record, and enables you to read and send updates to the ERP system.").
7. Select Manage model.
8. Select Add model operation.
   1. Choose a Select type.
   2. Select Save and Continue.
   {#create-an-odata-connection__substeps_xvc_d3w_cdc}
9. Select the new operation.
10. Select Select entity.
    1. In Select type, choose OData.
    2. In Select service, search for and select a service, for example API_BUSINESS_PARTNER (Remote API for business partner) in the OData service catalog.  
       When you specify the service, a call is made to the SAP service to read its metadata. The default service is /sap/opu/odata/iwfnd/CATALOGSERVICE;v=2/ServiceCollection. If you must change the service, create a property named sn_erp_integration.odata_service_path and set the value.
    3. In Select the endpoints, search for and select an endpoint, for example A_BusinessPartnerType.
    4. Select Add entity.  

       The flow named GET SAP BAPIs and tables when system becomes active runs to retrieve the data. The BAPI, table, and catalog tables are populated.
    {#create-an-odata-connection__substeps_p21_23w_cdc}
11. Select Specify inputs to check the information and edit as needed.  

    For more information, see [Manage input parameters for an ERP Canvas model operation](https://www.servicenow.com/docs/8F4AIpMBTqhyaUWPuO8XEA "Specify how fields on the ERP (Enterprise Resource Planning) system map to input parameters and their values to define the inputs for an operation that reads or updates the system of record from ERP Canvas.").
12. Select Choose output to check the information and edit as needed.  
    For more information, see [Choose output parameters for an ERP model](https://www.servicenow.com/docs/OX_LJNB6x0Te4D7FgWIe_g "Specify output parameters for an ERP (Enterprise Resource Planning) system read or update operation in ERP Canvas to define how fields and parameters are mapped from the ERP system to the ServiceNow AI Platform. Output parameters also define how returned data is stored on the ServiceNow AI Platform.").
13. Open the ERP systems list by selecting the systems icon (![ERP systems icon]()) in the side panel.
14. Select the system.
15. Check the heartbeat and retrieval status until they are successful.  
16. Create a model.
    1. Open the ERP models page by selecting the ERP models icon (![ERP model icon]()) in the side panel.
    2. Select New.
    3. Add an ERP model name, ERP module, and ERP system, and select Save.
    4. Select the new model in the list.
    5. Select Manage model.
    6. Select Add model operation.
    7. Select a Select type.
    8. Select Save and Continue.
    {#create-an-odata-connection__substeps_dmf_wyw_cdc}
17. Select the new operation.
18. Select Select entity.
    1. In Select type, select OData.
    2. Select a Select entity, select an entity, for example API_BUSINESS_PARTNER (Remote API for Business Partner) OData service catalog.
    3. In Select the endpoints, search for and select an endpoint, for example A_BusinessPartnerType Entity Name: Business Partner --- Return Type: Business Partner.
    4. Select Add entity and wait for retrieval to complete.  
    {#create-an-odata-connection__substeps_dh1_x3w_cdc}
19. Select Specify inputs to check the information and edit as needed.
    1. If there are required fields, select Select mandatory fields.
    2. Select any mandatory inputs listed and select OK.
    3. Select Save.
    {#create-an-odata-connection__substeps_zym_1jw_cdc}
20. Select Choose output.
    1. Select + New output.
    2. Select fields, for example BusinessPartnerName and Full Name.
    3. Select Save.
    {#create-an-odata-connection__substeps_f1q_cjw_cdc}
21. Test with Workflow Studio.
    1. Navigate to AllWorkflow Studio.
    2. On the homepage, select Actions.
    3. In the Name column, filter for contains Value and type <kbd class="ph userinput">Use ERP</kbd>.
    4. Select Apply.
    5. Select Use ERP data.
    6. Select Test.
    7. Specify the ModelName, ModelOperation, Mandatory fields (provide a value for the mandatory field if necessary), select a System, and select Run Test.
    8. When complete, select the link Your test has finished running. View the Action execution details.
    9. View and check the output, for example, in Output Data, select the Response to view the output.
    {#create-an-odata-connection__substeps_nyd_2jw_cdc}
{#create-an-odata-connection__steps_l5r_5hw_cdc}

*[\>]: and then