ERP Canvas enables you to connect to the ERP (Enterprise Resource Planning) system and extract data to remote tables and extraction tables for use on the Now Platform.

Overview of ERP Canvas

ERP Canvas functions as a platform within ServiceNow, offering a unified data model for ERP systems. ERP Canvas enables you to manage tables that contain both standard and custom fields grouped within ERP models. You can then extract data from those ERP tables and store it in a remote table or an extraction table, depending on the size of data sets and refresh needs.
  • Remote tables get their records from running an associated script against an external data source, and have a limit of 1,000 records.
  • Extraction tables retrieve large amounts of data once a day using a scheduled query, and use transform tables to process data for use on the Now Platform.

The unified data model of the Now Platform ensures seamless integration of ERP data into the Now Platform, enabling users to access and use business data with efficiency and ease. ERP Canvas streamlines ERP data management, making it accessible and actionable within the Now Platform and ServiceNow instances.

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.

For a list of remote tables available in ERP Canvas, see Standard remote tables for ERP Canvas.

ERP Canvas workflow

  1. Have your administrator use the Connections and Credentials app to configure credentials to connect to the ERP system of record. For more information, see Connections and Credentials.
  2. Create an ERP system in ERP Canvas using the connection and credentials alias that you configured. For more information, see Create an ERP system in ERP Canvas.
    Note: The rest of the workflow steps are in ERP Canvas. Build your ERP systems, ERP models, and tables in a development instance, and then promote them to a production instance when you're ready. For more information, see Managing app deployments using Pipelines and Deployments.
  3. Create or clone an ERP model that scans the specified ERP module in the system of record for available tables and fields. Note the tables and fields in the ERP model for use in extraction and remote tables. For more information, see Clone an ERP model in ERP Canvas.
  4. Add new tables, fields, and join conditions to include additional data in the ERP model. For more information, see:
  5. Work with remote tables to make them available for use as a data source, such as when building apps in App Engine Studio. For more information, see:
  6. Work with ETL extraction tables to regularly scan the system of record and extract data to a staging table.
    • Create as many separate extraction tables as needed, such as one for each supported country. For more information, see Extracting and transforming data in ERP Canvas.
    • You must first create the table transform map that connects the source table (on the system of record) to a Glide table on the Now Platform. For more information on creating table transform maps, see Create a transform map.
    • Extraction processes are configured in the ServiceNow app that uses them. For example Flow Designer.
    • After the extraction process is run, use import sets to map imported data into Now Platform tables. For more information, see Import sets.
  7. Move the ERP systems, ERP models, and tables to a production environment when they are ready. For more information, see Managing ERP development pipelines in ERP Canvas.
  8. Use the ERP data that is now available as the data source when building apps on the Now Platform, such as:

Benefits of ERP Canvas

Additional resources for ERP Canvas

Learn more about ERP Canvas ServiceNow resources
ERP Canvas is a ServiceNow app that enables you to simplify the use of ERP data from the system of record, such as SAP.

ERP Clean Core with App Engine Overview on Now Learning

Note: You must log in to Now Learning to access this resource.

ServiceNow Community site

Video: Unlock the full potential of your ERP system