Query a remote table using ERP Canvas
-
- UpdatedAug 3, 2023
- 1 minute read
- Vancouver
- Building applications
The Vancouver release is no longer supported. As such, the product documentation and release notes are provided for informational purposes only, and will not be updated.
Query ERP (Enterprise Resource Planning) remote tables from a system of record directly from the All menu using ERP Canvas.
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 ERP models to work with ERP data.
Note: ERP Canvas doesn't replicate data into the Now Platform. It mirrors data that lives in the ERP system of record, and remains protected there.
Procedure
-
Query the remote table using Glide for SAP.
For example, you can 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 Now Platform searching, sorting, and filtering, such as the condition builder. For more information, see Condition builder.
Figure 1. View data from the system of record in a ServiceNow table 