# Process Mining SAP ERP R/3 extractor (Python)
This project implements some connectors for the mainstream processes in SAP ERP R/3.
### Install
The project is available as a Python package in Pypi. It can be installed under a Python >=3.6 using:
pip install -U sapextractor
### Included resources
The root folder of the project includes a SQLIte dump of a SAP IDES instance, which can be used to test the extraction.
### Basic usage (command line interface)
The project can be easily used from the command line:
import sapextractor
sapextractor.cli()
The command line interface asks to insert the connection parameters to the database, and the details about the extraction.
### Supported processes
We support different processes, and modalities of extraction:
##### Order to Cash
For the Order-to-Cash process, we can extract a dataframe (that can be stored in CSV/Parquet files), a XES log, and object-centric logs (in the MDL and JMD formats).
The two classic log modalities asks for a central document type (for each document of the type, a case is created with all the operations on the connected documents).
##### Accounting
For the processes related to the accounting (such as the Accounts-Payable and the Accounts-Receivable processes), we offer different extraction possibilities: * Dataframe (Parquet/CSV) containing a case per document. Each case contains all the transactions that are executed on the document. * XES log containing a case per document. Each case contains all the transactions that are executed on the document. * Document Flow: given a central document type, provide as many cases as many documents of such type. Each case contains, as events, the connected documents to the ‘central’ document of the case. It is possible to extract both a dataframe (Parquet/CSV) and a XES log. * Transactions for the documents in a Document Flow: given a central document type, provide as many cases as many documents of such type. Each case contains, as events, the transactions executed on the connected documents to the ‘central’ document of the case. It is possible to extract both a dataframe (Parquet/CSV) and a XES log. * Object-Centric event logs (in the MDL and JMD formats).
##### Procurement
For the procurement, we can extract a dataframe (that can be stored in CSV/Parquet files), a XES log, and object-centric logs (in the MDL and JMD formats).
The two classic log modalities asks for a central document type (for each document of the type, a case is created with all the operations on the connected documents).
### Supported databases
The extraction happens directly at the database level. We provide support for the extraction from the following databases: * SQLite (as we provide a SAP IDES database dump in that format). * Oracle (throught the cx_Oracle package).
1 maintainer
Metadata
1 maintainer
Release files for sapextractor 0.0.22
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| sapextractor-0.0.22.tar.gz | 28.2 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sapextractor-0.0.22-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 94.3 kB
Release files / sapextractor-0.0.22.tar.gz
| Download URL | sapextractor-0.0.22.tar.gz |
|---|---|
| Size | 28.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
228e002a8375b97023d0686da8a845025e0cd4b9a3938ce8298a3fa46b53f8ea
|
|
BLAKE2b-256 checksum How to use checksums |
4b624c8ded5f991d1991409fc96997617664d106e7cfb451060868d267d7c9ca
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.3.0 pkginfo/1.6.1 requests/2.25.1 setuptools/54.1.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.8.5
|
Release files / sapextractor-0.0.22-py3-none-any.whl
| Download URL | sapextractor-0.0.22-py3-none-any.whl |
|---|---|
| Size | 66.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
16b6761118825ac2d57d45214bc82814024295889d241588d7d166d479eb39e1
|
|
BLAKE2b-256 checksum How to use checksums |
ff922fe9bf533cc0c6d1253ee350527ca197bb8fecbb0b9492e400681c19f2d1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.3.0 pkginfo/1.6.1 requests/2.25.1 setuptools/54.1.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.8.5
|
Security for sapextractor 0.0.22
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
