ERP Integration Framework
Summarize
Summary of ERP Integration Framework
The Source-to-Pay (S2P) ERP Integration Framework enables seamless data exchange between ServiceNow and third-party ERP systems. It supports integration of primary data, transactional data (purchase orders, receipts, invoices), fixed assets, and tax information across multiple ERP instances. This framework provides a consistent and flexible approach to synchronize data and workflows between ServiceNow and ERP backends.
Show less
Key Features
- User-defined primary data: Customizable to meet organizational needs and mapped to legal entities for clear data governance.
- Bidirectional data flow: Primary data and transactional data are associated with target ERP systems to enable two-way synchronization.
- Multiple ERP sources support: Organizations can configure multiple ERP instances (ERP Sources), each mapped to a legal entity, accommodating complex organizational structures.
- Integration architecture: Provides an abstraction layer between Source-to-Pay workflows and backend ERP systems, protecting workflows from backend-specific complexities.
- Transactional data handling: Imports selected inbound transactional data such as purchase orders shared across all Source-to-Pay Operations products.
ERP Source Configuration and Responsibilities
- Each legal entity must have at least one ERP source configured per target ERP instance.
- ERP sources are linked to specific ERP systems and define the system of record responsibilities.
- Third-party ERP systems serve as the system of record for primary data entities.
- Source-to-Pay acts as the system of record for purchase orders and receipts.
- Invoices can originate either manually in Source-to-Pay or via external supplier portals.
Technical Requirements
- Required application: Finance – ERP Integration store application must be installed on ServiceNow.
- MID Server: Required for ERP integrations using SOAP services to connect to ERP servers; not required for REST-based integrations.
User Roles and Permissions
- Administrator (snfcmsintg.admin): Manage integration applications, system-wide settings, and integration infrastructure.
- Procurement Specialist (snshop.procurementspecialist): Define and manage ERP sources, configure parameters, and manage integration workflows.
- FCA Integration user (snfcmsintg.integrationuser): Configure ERP source settings, web service authorizations, user and role mappings, and execute integration processes.
- Additional granular roles: Include importtransformer for data transformations and SOAP for SOAP-based web service integrations.
Granular permissions govern read/write access to key system properties related to purchase orders, invoice creation, and goods receipts, ensuring secure and controlled integration management.
The Source-to-Pay (S2P) ERP Integration Framework enables seamless data exchange between ServiceNow and third-party Enterprise Resource Planning (ERP) systems. This framework supports comprehensive integration of primary data, transactional data (purchase orders, receipts, invoices), fixed assets, and tax information across multiple ERP instances.
Key Features
- User-defined primary data that can be customized to organizational needs.
- Mapped to organizational legal entities for clear data governance.
- Associated with target ERP systems for bidirectional data flow.
- Flexible configuration enabling multiple sources for an organization.
ERP Sources
An ERP Source represents a specific ERP instance from which data is imported and to which data is exported. Organizations typically maintain multiple ERP instances as systems of record, with each ERP source mapped to a legal entity within the organization.
ERP Integration Requirements
- At least one ERP source must be configured for each legal entity within every target instance.
- Each ERP source should be associated with a specific target ERP system.
- Organizations can create as many ERP sources as needed to support their structure.
The integration framework clearly defines the system of record responsibilities:
- Third-party ERP: System of record for primary data entities
- Source-to-Pay: System of record for purchase orders and receipts
- Either system: Invoices can be created manually in Source-to-Pay or through external supplier portals
Integration Architecture
The ERP Integration Framework application loads primary data into Source-to-Pay Operations, enabling various ServiceNow workflows. It also imports selected inbound transactional data objects such as purchase order data that are shared across all Source-to-Pay Operations products.
Both the ERP Integration Framework and Source-to-Pay Integration Framework applications provide an abstraction layer between the Source-to-Pay application and backend systems. This design shields Source-to-Pay workflows and data models from backend-specific integration components and data structures.
The integration requires the Finance – ERP Integration store application to be installed.
MID Server Requirement
A MID Server is required for ERP integrations using SOAP services. The MID Server must be installed and configured to connect to the ERP system server. See Installing the MID Server for details.
User Roles and Permissions
| Role name | Capabilities |
|---|---|
| Administrator (sn_fcms_intg.admin) |
|
| Procurement Specialist (sn_shop.procurement_specialist) |
|
| FCA Integration user (sn_fcms_intg.integration_user) |
|
- Import_transformer: For data transformation operations
- SOAP: For SOAP-based web service integrations
sn_fcms_intg.admin) are granted read and write permissions for these system properties. This access aligns with the granular role modifications as per the new directives.| Property Name | Read role | Write role |
|---|---|---|
| sn_fcms_intg.status_for_purchase_order | sn_shop.shopper, sn_shop.procurement_common_reader, sn_fcms_intg.admin | sn_fcms_intg.admin |
| sn_fcms_intg.status_for_invoice_creation | sn_fcms_intg.admin, sn_ap_apm.accounts_payable_specialist | sn_fcms_intg.admin |
| sn_fcms_intg.status_for_goods_receipt | sn_shop.shopper, sn_shop.procurement_common_reader, sn_fcms_intg.admin | sn_fcms_intg.admin |