Zero Copy Connector for ERP system properties
Use these system properties to configure Zero Copy Connector for ERP behavior, including debug logging, OData connections, and ETL extraction settings.
Configure the following properties in the System Properties [sys_properties] table to control Zero Copy Connector for ERP behavior.
Note: To open the System Properties [sys_properties] table, enter sys_properties.list in the navigation filter.
| Property | Type | Description |
|---|---|---|
| com.snc.uib.sn\_erp\_integration.debug.level | integer | Debug log level. - 0 is inactive - 1 is least level of detail - 9 is highest level of detail Logging is done in class ERPIntegrationLog. |
| glide.ui.sn\_erp\_integration\_etl\_extraction\_source\_activity.fields | string | Extraction tables activity fields. |
| glide.ui.sn\_erp\_integration\_model\_activity.fields | string | ERP Model activity formatter fields. |
| glide.ui.sn\_erp\_integration\_remote\_table\_activity.fields | string | Remote table activity formatter fields. |
| glide.ui.sn\_erp\_integration\_scheduled\_extraction\_activity.fields | string | ETL Scheduled Extraction formatter fields. |
| sn\_erp\_integration.catalog\_service\_path \(this property must be created manually\) | string | After the hostname and port, this path is used to connect with any SAP catalog service. The default is: /sap/opu/odata/iwfnd/CATALOGSERVICE;v=2/ServiceCollection. After creating the property and setting it to true, 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: If there's an update in the catalog service and you want to update the table catalog information, first remove the attachment displayed on the ERP Systems page. Then, run the retrieval process again to refresh the list. |
| sn\_erp\_integration.db\_memory\_limit\_mb | integer | Database memory limit in megabyte per request. When limit is reached, data is written to disk. |
| sn\_erp\_integration.debug.sapresponse.size | integer | Number of bytes of the reply from SAP probe to output from step that calls SAP. |
| sn\_erp\_integration.enableModelModification | true \| false | Enables cloning and changes of models in Zero Copy Connector for ERP application. |
| sn\_erp\_integration.heartbeat\_enabled | true \| false | Turns heartbeat feature on/off. |
| sn\_erp\_integration.keep\_pages\_on\_mid\_on\_error | true \| false | Do not delete data on mid server when errors occur. |
| sn\_erp\_integration.max\_in\_loaded\_state | integer | Maximum pages in loaded state per process. When more pages are in loaded state, ETl process waits until less pages are in loaded state before sending next batch. |
| 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. |
| sn\_erp\_integration.odata\_service\_path \(this property must be created manually\) | 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 default is: /sap/opu/odata/sap. |
| sn\_erp\_integration.probe.paging.tech | choice list | Paging technology. |
| sn\_erp\_integration.response\_timeout | integer | Specifies the timeout value for OData response. If OData calls are timed 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. |
| sn\_erp\_integration.result\_page\_size | integer | Number of records to retrieve from the external system. The default global property for all extractions is set to 50. To override the global property, specify an extraction source specific page size with the sn\_erp\_integration\_result\_page\_size system property. |
| sn\_erp\_integration.sap\_output\_pagesize | integer | Page size of output from MID Server. |
| sn\_erp\_integration.sap\_pagesize | integer | Page size for database requests from MID Server to SAP. |
| sn\_erp\_integration.save\_erp\_attachment | true \| false | Set this property to true to save the latest response from your ERP system as an attachment on the ERP remote table. Updating the attachment setting on the ERP remote table to "use attachment" skips the request to the ERP system and shows the data stored in attachment. Requires the sn\_erp\_integration.erp\_admin role to change. |
| sn\_erp\_integration.storage\_pagesize | integer | Size of each batch insert to storage after response from SAP. |
| sn\_erp\_integration.use\_cookies | true \| false | Specifies if cookies must be used for OData connection. |
| sn\_erp\_integration.use\_csrf\_token | true \| false | Indicates if CSRF token should be sent for OData calls in Zero Copy Connector for ERP operations. |
Parent Topic:Zero Copy Connector for ERP reference