---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Create OData connection

# Create an OData connection in Zero Copy Connector for ERP {#ariaid-title1}

Release version: Brazil  
Updated October 23, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 4 minutes to read  
Create an OData v2 connection to link to an ERP system so data can be extracted for use in remote tables and extraction tables.

## Before you begin

Role required: admin

For information about OData connections in Zero Copy Connector for ERP, see [Connecting Zero Copy Connector for ERP to ERP using OData](https://www.servicenow.com/docs/C0C3pkOHtzpbMS~Zk0uuAg "Extract data securely from ERP OData v2 APIs for use in remote tables and extraction tables.") and [OData capabilities supported by Zero Copy Connector for ERP](https://www.servicenow.com/docs/XIGBOJors1Sz~PDzEBl79g "Zero Copy Connector for ERP (Enterprise Resource Planning) supports the $select, $filter, and $orderby OData v2 query capabilities.").

## 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.

* The property must be enabled on the correct scope.
* After enabling the property, Zero Copy Connector for ERP 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. (Enabling the property on a production instance can create metadata records when new models and fields are added in Zero Copy Connector for ERP.)
* System properties are maintained in the System Property table \[sys_properties\], which you can access by entering <kbd class="ph userinput">sys_properties.list</kbd> directly in the Navigator Filter.

## 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.  
   For credentials, you can use Basic Auth, OAuth, or API Key.  
   For more information, see:
   * [Basic authentication credentials](https://www.servicenow.com/docs/access?context=r_BasicAuthCredentialsForm&version=brazil&pubname=brazil-platform-security&ft:locale=en-US)
   * [OAuth 2.0 credentials](https://www.servicenow.com/docs/access?context=oauth-2-credentials&version=brazil&pubname=brazil-platform-security&ft:locale=en-US)
   * [API key credentials](https://www.servicenow.com/docs/access?context=API-key-credential-form&version=brazil&pubname=brazil-platform-security&ft:locale=en-US)
   * [Create a Connection \& Credential alias](https://www.servicenow.com/docs/access?context=connection-alias&version=brazil&pubname=brazil-platform-security&ft:locale=en-US)
3. Create a connection and associate it with the new alias.
4. Create a system with the connection.  
   For more information, see [Create an ERP system in Zero Copy Connector for ERP](https://www.servicenow.com/docs/1pQChQJAkKqV6WvnIRkBZQ "Configure an ERP system in Zero Copy Connector for ERP to register your ERP connection so that models and tables can use it as a data source.").
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 [Create a model](https://www.servicenow.com/docs/3qabiHbBp6AV63fGAAhtxA "Add a model in Zero Copy Connector for ERP (Enterprise Resource Planning) to create a dataset containing tables from the ERP system 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.catalog_service_path and set the value. This property applies to all ERP systems in the instance.

       If you can't find the service you need, see [Add an OData service manually in Zero Copy Connector for ERP](https://www.servicenow.com/docs/5molMEjqYYvFMdbk2nyl9Q "When adding an entity to a model using OData, if the service you need isn't listed, add the service manually in Zero Copy Connector for ERP (Enterprise Resource Planning).").
    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 a model operation](https://www.servicenow.com/docs/4DNzaxElU5xueoVp1xJTJA "Specify how fields on the ERP (Enterprise Resource Planning) system map to input parameters and their values. Mapping defines the inputs for an operation that reads, creates, or updates the ERP system from Zero Copy Connector for ERP.").
12. Select Choose output to check the information and edit as needed.  
    For more information, see [Choose output parameters for a model](https://www.servicenow.com/docs/O7jI9elC8QwfGvKGRNGetg "Specify output parameters for a model operation in Zero Copy Connector for ERP to define which ERP fields map to the ServiceNow AI Platform and how the returned data is stored.").
13. Open the ERP systems list by selecting the systems icon ![]() in the side panel.
14. Select the system.
15. Check the heartbeat and retrieval status until they're successful.  
16. Create a model.
    1. Open the ERP models page by selecting the models 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. In Select service, specify a service, 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}
{#create-an-odata-connection__steps_l5r_5hw_cdc}

## What to do next

Test the connection using one of the following methods.

* Use scriptable API. For detailed information, see [sn_erp_integration API - Scoped, Global](https://www.servicenow.com/docs/access?context=sn_erp_integrationBothAPI&version=brazil&pubname=brazil-api-reference&ft:locale=en-US).
* Use Workflow Studio.
  1. Navigate to AllWorkflow Studio.
  2. On the home page, 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.

*[\>]: and then


