Requirements for installing ERP Data Hub

  • Release version: Xanadu
  • Updated August 1, 2024
  • 3 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Requirements for installing ERP Data Hub

    Before installing ERP Data Hub, ServiceNow customers must complete essential configurations on both their ERP system and the ServiceNow AI Platform. Proper licensing, platform plugins, MID Server setup, SAP authorizations, and integration with SAP components are critical prerequisites to ensure a successful installation and operation.

    Show full answer Show less

    Key Requirements

    • Licensing: A valid license and entitlement for ERP Data Hub are mandatory before installation.
    • ServiceNow AI Platform Plugins:
      • Integration Hub plugin (request access as needed)
      • Remote Tables plugin (activate before installation)
      • MID Server configured with specific roles and capabilities for ERP Data Hub communication
    • MID Server Configuration:
      • Ensure the MID Server supports ERP Data Hub application and capabilities.
      • Assign the snerpintegration.erpmidserver role to the miduser to enable use of the ImportSet API for data transfer.
      • The MID Server must have a valid connection and credentials matching the ERP system service user.
    • SAP System Support and Authorizations:
      • Supported SAP systems: ECC (minimum SAP Netweaver 7.31) and all versions of S/4HANA.
      • Use an SAP service user account with required SAP authorization objects and activities, differing slightly between development, test, and production environments.
      • Authorizations include execution rights for specific function modules and display rights for necessary SAP tables.
    • Spoke Integration Files:
      • Obtain SAP proprietary JAR files and attach them as records in the MID Server JAR Files section.
      • Include sapjco3.dll for Windows MID Servers, libsapjco3.so for Linux, and sapjco3.jar for both platforms.
      • Note that the MID Server will restart multiple times during this process.
    • SAP Configuration:
      • Configure the SAP JCO connector as per SAP documentation before installing ERP Data Hub.
      • Add the DuckDB JDBC driver jar to the MID Server jars for database connectivity.
      • Ensure the SAP environment includes SAP ECC (Netweaver 7.31 or higher), SAP S/4HANA, and the SAP Java Connector.

    Practical Implications

    Following these requirements enables ServiceNow customers to establish a secure, authorized, and fully integrated connection between their SAP ERP systems and the ServiceNow AI Platform. Proper setup ensures data can be securely imported and processed through the ERP Data Hub, supporting operational analytics and automation workflows.

    Customers should coordinate with their SAP administrators to secure necessary user credentials, authorizations, and JAR files, and validate MID Server configurations to meet these prerequisites before proceeding with ERP Data Hub installation.

    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:

    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.

      MID server record related lists with capabilities tab displayed showing ERP Data Hub and all.

    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