Connecting Zero Copy Connector for ERP to ERP using OData

concept brazil Updated Aug 5, 2026 3 min read erp-canvas-use-odata-and-http-connection.md
Raw file servicenow.com

Extract data securely from ERP OData v2 APIs for use in remote tables and extraction tables.

Important:

OData v2 doesn't use snapshot isolation, so you might experience some data consistency issues when retrieving data from an external ERP source.

Providing OData access to users

You must have an ERP system enabled for OData connections.

To give users OData access, see the following instructions on the SAP help site: Back-End Server: Assign OData Service Authorization to Users.

Enabling download of XML files

The glide.attachment.extensions system property restricts the file types that can be downloaded. This property is empty by default. Check that the xml file extension hasn't been added to this property. For more information, see .

System properties

The following are properties related to OData.

Property

Type

Description

Create manually?

Role needed to edit property

sn_erp_integration.catalog_service_path

string

After the hostname and port, this path is used to connect with the SAP catalog service on every ERP system in the instance. The default is /sap/opu/odata/iwfnd/CATALOGSERVICE;v=2/ServiceCollection.

The value must be the address of the OData Service Catalog. This property applies to all ERP systems in the instance. You can't set a different catalog service path for each system. If an ERP system exposes its catalog service at a different path, its services aren't retrieved. To use those services, add them manually. For more information, see Add an OData service manually in Zero Copy Connector for ERP.

After creating the property and setting its value to the catalog service path, a list of all services is retrieved from SAP. The information is stored in an XML file and attached to the system record. The XML can be used later. For example, parse the XML while offline with no connection to SAP.

Note: To update the table catalog information after the catalog service changes, first remove the attachment displayed on the ERP Systems page. Then, run the retrieval process again to refresh the list.

Yes

admin

sn_erp_integration.odata_max_record_fetch_limit

integer

Limits the number of records fetched for GET calls by adding the $top parameter to the OData calls. This reduces the number of records read from the OData endpoint.

No

admin

sn_erp_integration.odata_service_path

string

After the hostname and port, this path is used to connect with any SAP OData service. Add a URL in Value to specify the OData service. The value is a single path, not a list of paths. The default is /sap/opu/odata/sap.

Yes

admin

sn_erp_integration.response_timeout

integer

Specifies the timeout value for OData response. If OData calls time out frequently, increase the timeout value. Specify the value in seconds. The default is 100 seconds. This value is used for responses both from external web and from a MID Server.

No

admin or sn_erp_integration.erp_admin

sn_erp_integration.use_cookies

true | false

Specifies whether to use cookies for an OData connection.

No

admin or sn_erp_integration.erp_admin

sn_erp_integration.use_csrf_token

true | false

Indicates whether a CSRF token is sent for OData calls in Zero Copy Connector for ERP operations.

No

admin or sn_erp_integration.erp_admin

**Note:** To add a property manually, verify that your scope is set to Zero Copy Connector for ERP, then navigate to sys\_properties.list and select **New**.

Heartbeat information

For an ERP system, there are separate heartbeat indicators for RFC and HTTP. When a system is established, the heartbeats are set to active and the status is updated, including any errors. If the heartbeat calls are successful, BAPI and OData retrieval is triggered in parallel and the status appears on the system record.

[Omitted image "erpc-system-heartbeats.png"] Alt text: System record with OData retrieval status of completed.

More information

For more information about using OData in Zero Copy Connector for ERP, see Create an OData connection in Zero Copy Connector for ERP and OData capabilities supported by Zero Copy Connector for ERP.

Keywords erpcanvaserp canvasmodelintegrationdata hubzerocopyconnectorsapodataconnection
Search documentation
Search document titles and file paths on the brazil branch