How ERP Semantic Mining extracts and processes data
ERP Semantic Mining retrieves data from the ERP (Enterprise Resource Planning) system using extractors and processes it before the data is available on the ServiceNow AI Platform.
중요사항:
Starting with the Zurich release, ERP Semantic Mining is being prepared for future deprecation. It will be hidden and no longer activated on new instances but will continue to be supported.
Use an SAP extractor to analyze the ERP data sources and validate the syntax. The following extractors are available to retrieve data from the ERP system:
- APPstats
- COMPHIER
- SQLM
| Extractor | Full name | Description | ServiceNow AI Platform processing tables | Populated ServiceNow AI Platform tables |
|---|---|---|---|---|
| APPstats | Application Statistics | Collects and analyzes system-level statistics and performance metrics from the ERP application. | sn_erp_mining_erp_appstat_data_staging sn_erp_mining_erp_appstat_data_aggr |
sn_erp_mining_erp_application sn_erp_mining_erp_user |
| COMPHIER | Component Hierarchy | Analyzes the hierarchy and relationships among different components at SAP, including business processes and module configurations. | sn_erp_mining_erp_comp_hier_data_staging sn_erp_mining_erp_comp_hier_data_aggr |
sn_erp_mining_erp_application sn_erp_mining_erp_module |
| SQLM | SQL Monitor | Enables the monitoring of all SQL statements and operations that are executed by running ABAP applications. The data collected by SQLM provides aggregated performance indicators (such as the number of executions, execution time, or number of effected rows) for all executed database operations. | sn_erp_mining_erp_sqlm_data_staging sn_erp_mining_erp_sqlm_data_aggr |
sn_erp_mining_erp_application sn_erp_mining_erp_table sn_erp_mining_erp_application_table sn_erp_mining_erp_application_usage |