Query a remote table using Zero Copy Connector for ERP

  • Release version: Zurich
  • Updated March 12, 2026
  • 1 minute to read

    • Query ERP (Enterprise Resource Planning) remote tables from a system of record directly from the All menu using Zero Copy Connector for ERP.

    Before you begin

    Role required: sn_erp_integration.erp_user

    About this task

    You can query the system of record to create an ERP model for your ERP processes. For more information, see Building and managing models to work with ERP data.

    Note:
    Zero Copy Connector for ERP doesn't replicate data into the ServiceNow AI Platform. It mirrors data that lives in the ERP system of record, and remains protected there.

    Procedure

    1. Navigate to All > Zero Copy Connector for ERP > Zero Copy Connector for ERP Home.
    2. Open the Remote tables page by selecting the remote tables icon in the side panel.
    3. Select the remote table in the Name column, such as SAP Country.
    4. Select Open remote table list.
    5. Query the remote table using Glide for SAP.

      For example, you can select and hold (or right-click) on a column, such as Storage location, and select Show Matching records.

      The SAP data is accessible for you to work with using standard ServiceNow AI Platform searching, sorting, and filtering, such as the condition builder. For more information, see Condition builder.