Requirements for installing ERP Data Hub

Before you install ERP Data Hub, you must complete several configurations, on both the ERP (Enterprise Resource Planning) system and on the ServiceNow AI Platform.

Licensing

You must have a license and get entitlement to ERP Data Hub for installation. For more information, see Licensing.

ServiceNow AI Platform plugins

The following plugins and servers are required for installing ERP Data Hub:

• Integration Hub plugin (for more information, see Request Integration Hub)
• Remote Tables plugin (for more information, see Activate the remote tables plugin)
• MID Server: The MID Server must be configured to install ERP Data Hub. See the following section for more information.

MID Server requirements

Communicating with the system of record through a MID Server requires a valid connection and credential alias.

Note:

The credentials you specify for the ERP Data Hub connection must match the service user credentials in the system of record.

ERP Data Hub and ERP-CM currently support ECC (minimum SAP Netweaver 7.31) and S/4HANA SAP systems.

Find your MID Server on the ServiceNow AI Platform in All > MID Server > Servers. Select it and add the following:

1. In the Supported applications tab, edit the list to include ERP Data Hub.
2. In the Capabilities tab, in addition to ALL, edit the list to include ERP Data Hub.

   

For more information, see MID Server.

Assign the mid_user user the sn_erp_integration.erp_mid_server role. The role enables the MID Server to use the ImportSet API to send data to the ServiceNow instance.

1. Navigate to All > User Administration > Users
2. Find and select the mid_user.
3. Select the Roles tab.
4. Select Edit.
5. 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.

Spoke integration

For required spokes, contact the admin of your SAP ECC RFC account to obtain the following SAP proprietary JARs and other required 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.

Note:

Create the records at All > MID Server > JAR Files. For more information about creating JAR files and adding attachments, see Synchronize a JAR file to MID Servers.

The MID Server restarts multiple times during this process.

For more information on spoke integration, see SAP ECC RFC Spoke.

SAP configuration

You must configure the JCO connector before you install ERP Data Hub. See the SAP documentation for more information.

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 web site.

Additionally, you need the following on your ERP system:

• SAP ECC (minimum SAP Netweaver 7.31)
• SAP S/4HANA (all versions supported)
• SAP Java Connector