Page History
...
All tables and procedures will be created by the TrxLogsETL analytics-etl-service at startup.
...
.
Setting up an SQLServer Database
To use an SQLServer database, you only need to create an empty schema. All tables and procedures will be created by the TrxLogsETL analytics-etl-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.
Code Block |
---|
GRANT ADMINISTER BULK OPERATIONS TO <database user>; |
Setting up an Oracle Database
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 analytics-etl-service at startup.
The Oracle database user need to be granted the following minimum privileges for Process Mining to work:
Code Block |
---|
GRANT CONNECT, RESOURCE TO <database user the process mining services will use> CONTAINER=CURRENT; |
Setup for ETL by Bulk Upload
...
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:
Code Block | ||
---|---|---|
| ||
CREATE DIRECTORY oracleWork AS '<path to folder>';
GRANT READ ON DIRECTORY oracleWork TO <database user the process mining services will use>; |
Note |
---|
The name of the work directory must be oracleWork. |
...
Access to sys.dbms_crypto
...