Scheduled jobs to fetch primary data
You can schedule on-demand jobs to be run at specific intervals of time to fetch primary data from different ERP sources into ServiceNow.
Before you start the ERP integration, you must configure the integration services record for target ERP source using the sn_fcms_intg_service table. The sn_fcms_intg_service table is a mapping table between sub flows and target ERP source. For more information on creating a integration service record, see Create Integration Service record.
Scheduled jobs are configured for entities using scripts. Example: Fetch cost center from ERP systems. For more information on configuring scheduled jobs using scripts, see . The script invokes subflow which is associated with an entity as shown in the figure below. The subflow queries the active entities or ERP source configuration (optional) listed in the integration service table.
- Cost center
- Payment terms
- Legal entity
- Plant/address
- GL account
- Purchasing org
- Product category/Product model (Material group/Material number)
- Currency
- Department
- Supplier
- FX currency rate