Create an OData connection in Zero Copy Connector for ERP

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 and OData capabilities supported by Zero Copy Connector for ERP.

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 sys_properties.list directly in the Navigator Filter.

Procedure

Confirm that you have an SAP system that has been enabled to make an OData connection.
Create a connection and credential alias.

For credentials, you can use Basic Auth, OAuth, or API Key.

For more information, see:
- Basic authentication credentials
- OAuth 2.0 credentials
- API key credentials
- Create a Connection & Credential alias
Create a connection and associate it with the new alias.
Create a system with the connection.

For more information, see Create an ERP system in Zero Copy Connector for ERP.
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.
Create a model and, after saving, open the model record.

For more information, see Create a model.
Select Manage model.
Select Add model operation.
1. Choose a Select type.
2. Select Save and Continue.
Select the new operation.
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.
3. In Select the endpoints, search for and select an endpoint, for example A_BusinessPartnerType.
  
  [Omitted image "erp-create-odata-conn1.png"] Alt text: Add entity modal with OData service and endpoint specified.
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.
Select Specify inputs to check the information and edit as needed.

For more information, see Manage input parameters for a model operation.
Select Choose output to check the information and edit as needed.

For more information, see Choose output parameters for a model.
Open the ERP systems list by selecting the systems icon [Omitted image "erp-systems-icon-sidebar.png"] Alt text: in the side panel.
Select the system.
Check the heartbeat and retrieval status until they're successful.

[Omitted image "erp-create-odata-conn2.png"] Alt text: ERP system record with HTTP heartbeat status and OData retrieval status highlighted.
Create a model.
1. Open the ERP models page by selecting the models icon [Omitted image "erpc-data-model-icon.png"] Alt text: 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.
Select the new operation.
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.
  
  [Omitted image "erp-create-odata-conn3.png"] Alt text: Add entity form with type, service, and endpoint specified.
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.
Select Choose output.
1. Select + New output.
2. Select fields, for example BusinessPartnerName and Full Name.
3. Select Save.

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.
Use Workflow Studio.
1. Navigate to All > Workflow Studio.
2. On the home page, select Actions.
3. In the Name column, filter for contains Value and type Use ERP.
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.

title	Create an OData connection in Zero Copy Connector for ERP
description	Create an OData v2 connection to link to an ERP system so data can be extracted for use in remote tables and extraction tables.
locale	en-US
canonical_url	https://www.servicenow.com/docs/r/australia/integrate-applications/erp-integration-framework/create-an-odata-connection.html
release	australia
product	ERP Integration Framework
classification	erp-integration-framework
topic_type	task
last_updated	2026-10-23
reading_time_minutes	5
keywords	erpcanvaserp canvasintegrationdata hubzerocopyconnectorsapodataconnectionhttp
breadcrumb	ODataConnecting Zero Copy Connector for ERP to SAP ECC and SAP S/4HANAConfiguringZero Copy Connector for ERPWorkflow Data Fabric