Kofax Capture - Manual (Page 19)

Installation
Kofax Reporting Administrator's Guide 19
Running MS SQL Database Installation Scripts
This section assumes that a compatible database server has been already installed. You need
to perform these steps twice: once for the staging database, once for the data warehouse.
1 Stop ETL agent.
2 Log on to the Microsoft SQL Server Management Studio as the database administrator.
3 Create the database.
4 Run the script to create database objects:
▪ kofax_analytics_staging.sql (staging database)
▪ kofax_analytics.sql (data warehouse).
5 Create an SQL Server user for the ETL agent. Alternatively, use two users, one for each
database. Assign the following role(s) to the user(s):
▪ kfx_staging (for staging database)
▪ kfx_etl, kfx_reader, kfx_advanced_reader (for data warehouse).
6 Start ETL agent.
Running Oracle Database Installation Scripts
This section assumes that a compatible database server has been already installed. You need
to perform these steps twice: once for the staging database, once for the data warehouse.
1 Stop ETL agent.
2 Log on to a database management tool, such as Oracle SQL Developer, as the sys user
(role SYSDBA).
3 Create a user, e.g. StagingUser or DwhUser.
4 Assign tablespace quota to this user, or grant it unlimited tablespace privilege.
5 Grant required privileges user created in step 2: GRANT CREATE TYPE, CREATE ANY
INDEX, DROP ANY INDEX, CREATE SESSION, CREATE PROCEDURE, CREATE
VIEW, ALTER SESSION, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER,
CREATE ROLE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE TO
;
6 Optionally, edit the script and uncomment the first paragraph to be prompted for
username and password.
▪ kofax_analytics_oracle_staging.sql (staging database)
▪ kofax_analytics_oracle.sql (data warehouse).
7 Run the script to create database objects. Sample sqlplus command:
sqlplus DwhUser/pwd@localhost @kofax_analytics_oracle.sql
8 Revoke the system privileges granted in step 4: REVOKE CREATE TYPE, CREATE ANY
INDEX, DROP ANY INDEX, CREATE SESSION, CREATE PROCEDURE, CREATE
VIEW, ALTER SESSION, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER,
CREATE ROLE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE FROM
;