To run and use Scheer PAS Process Mining you need a database to store the collected statistical and tracing data. Process Mining can be connected to a MySQL, an Oracle, or an SQLServer database. To set up the analytic database, you need a valid installation of one of these three.
When preparing the database installation, please consider the following: The Process Mining database contains analytic data for statistical analysis and can reach a considerable size. But, in contrast to databases that store application data, it does not need to be highly available and fulfill strict recovery requirements.
This may lead to the fact that a point in time recovery is not possible, but this will not cause problems as lost data can be simply reloaded from the BRIDGE logs. |
The analytical database is composed of two parts:
To use a MySQL database, you need to
SELECT
privileges on table mysql.proc.
GRANT SELECT ON 'mysql'.'proc' TO '<user>'@'<mysql server>'; |
|
All tables and procedures will be created by the TrxLogsETL service at startup.
With MySQL you cannot use Bulk Upload. |
To use an SQLServer database, you only need to create an empty schema. All tables and procedures will be created by the TrxLogsETL service at startup.
If you want to use Bulk Upload with SQLServer, you need to provide the database user that is associated with the TrxLogsETL with permissions to administer bulk operations, like e.g.
GRANT ADMINISTER BULK OPERATIONS TO <database user>; |
To use an Oracle database with ETL by inserts, you need to create an empty schema. All tables and procedures will be created by the TrxLogsETL service at startup.
The Oracle database user need to be granted the following minimum privileges for Process Mining to work:
GRANT CONNECT, RESOURCE TO <database user the process mining services will use> CONTAINER=CURRENT; |
Open an SQLPlus command shell and connect to the Oracle database with an administration account.
Make the directory created in step 1 known to Oracle. Create a reference using:
CREATE DIRECTORY oracleWork AS '<path to folder>'; GRANT READ ON DIRECTORY oracleWork TO <database user the process mining services will use>; |
The name of the work directory must be oracleWork. |
All tables and procedures will be created by the TrxLogsETL service at startup.
For both setup scenarios the database administrator needs to grant access to package sys.dbms_crypto to the Process Mining database user:
GRANT EXECUTE ON SYS.DBMS_CRYPTO TO <database user the process mining services will use>; |