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.
Important: 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
The supported extractors process data using ServiceNow AI Platform tables.
| 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 |
Parent Topic:Exploring ERP Semantic Mining