Requirements for installing Zero Copy Connector for ERP
Summarize
Summary of Requirements for installing Zero Copy Connector for ERP
The Zero Copy Connector for ERP enables integration between your ERP system and the ServiceNow AI Platform to support data connectivity and semantic mining capabilities. Before installation, specific configurations and prerequisites must be met on both the ERP system and ServiceNow environment to ensure smooth operation and secure communication.
Show less
Key Requirements
- Licensing: A valid license and entitlement for Zero Copy Connector for ERP is mandatory.
- ServiceNow Plugins: Integration Hub and Financial Services Remote Tables plugins must be installed.
- MID Server Setup: Required for on-premises ERP systems but not for cloud ERP solutions (e.g., S/4HANA Cloud, SuccessFactors).
- The MID Server must have Zero Copy Connector for ERP added in Supported Applications and Capabilities tabs.
- The
miduseraccount must be assigned thesnerpintegration.erpmidserverrole to enable data import via ImportSet API.
- Supported ERP Systems: ECC (SAP Netweaver 7.31 or higher) and SAP S/4HANA systems.
- SAP User Credentials and Authorizations:
- Use an SAP service-type user with specific authorizations depending on the environment (development vs. production/test), including permissions for RFC function modules and table display rights.
- SAP Proprietary Files: SAP JCo connectors (sapjco3.dll for Windows, libsapjco3.so for Linux, and sapjco3.jar) must be uploaded as MID Server JAR file records to enable SAP connectivity.
- SAP Configuration:
- Install and configure the SAP Java Connector (JCo) per SAP guidelines.
- Add the DuckDB JDBC driver JAR to the MID Server for database connectivity.
Practical Considerations for ServiceNow Customers
- Ensure all required ServiceNow plugins and MID Server roles are correctly assigned before installation.
- Validate that SAP user accounts used for integration have the appropriate authorizations to access required function modules and tables safely.
- Prepare and upload all necessary SAP proprietary connector files to the MID Server to avoid connectivity issues.
- If using cloud ERP solutions, you can skip the MID Server setup, simplifying deployment.
- Following these requirements ensures a secure, compliant, and efficient deployment of Zero Copy Connector for ERP, enabling enhanced ERP data integration and semantic mining capabilities within ServiceNow.
Before you install Zero Copy Connector for ERP (Enterprise Resource Planning), you must complete several configurations, on both the ERP system and on the ServiceNow AI Platform.
Licensing
You must have a license and get entitlement to Zero Copy Connector for ERP for installation. For more information, see .
ServiceNow AI Platform plugins
- Integration Hub plugin (for more information, see Request Integration Hub)
- Financial Services Remote Tables plugin (for more information, see )
MID Server requirements
Zero Copy Connector for ERP and ERP Semantic Mining currently support ECC (minimum SAP Netweaver 7.31) and SAP S/4HANA systems.
- In the Supported applications tab, edit the list to include Zero Copy Connector for ERP.
- In the Capabilities tab, add Zero Copy Connector for ERP.
- Navigate to .
- Find and select the mid_user.
- Select the Roles tab.
- Select Edit.
- Find and assign the sn_erp_integration.erp_mid_server role.
Required SAP authorizations in development system
For the credentials, use an SAP service type user account in your system of record that requires the following SAP authorization objects:
- S_RFC with Activity = 16 (Execute) for the following Function Modules:
- RFCPING
- BAPI_MONITOR_GETLIST
- RFC_METADATA_GET
- RFC_GET_FUNCTION_INTERFACE
- RFC_READ_TABLE
- DDIF_FIELDINFO_GET
- S_TABU_NAM with Activity 03 (Display) for the following tables:
- DD01L
- DD02L
- DD02T
- DD03L
- DD04L
- DD04T
- DD12L
- DD17S
- DD40L
- S_DEVELOP with Activity 03 (Display)
Required SAP authorizations in production and test system
For the credentials, use an SAP service type user account in your system of record that requires the following SAP authorization objects:
- S_RFC with Activity = 16 (Execute) for the following Function Modules:
- RFCPING
- BAPI_TRANSACTION_COMMIT
- BAPI_TRANSACTION_ROLLBACK
- RFC_METADATA_GET
- RFC_GET_FUNCTION_INTERFACE
- RFC_READ_TABLE
- S_TABU_NAM with Activity 03 (Display) for the tables you have used in models.
SAP proprietary files
- Create a record called "SAP Jco Dll" and attach sapjco3.dll. Use this file if your MID Server is installed on a Windows server.
- Create a record called "SAP Jco so" and attach libsapjco3.so. Use this file if your MID Server is installed on a Linux server.
- Create a record called "SAP Eco Jar" and attach sapjco3.jar. Use this file for both Windows and Linux.
The MID Server restarts multiple times during this process.
For details about these files, see SAP ECC RFC Spoke.
SAP configuration
You must configure the JCO connector before you install Zero Copy Connector for ERP. For more information, see Installing the SAP Java Connection (JCo) on the SAP Help Portal.
You must add the DuckDB JDBC jar as a MID Server jar. For more information and to download, see DuckDB JDBC Driver 1.1.1 on the Maven website.
- SAP ECC (minimum SAP Netweaver 7.31)
- SAP S/4HANA (all versions supported)
- SAP Java Connector