Kofax Capture Manual do Utilizador descarregar pdf (Página 19)

Installation

Kofax Reporting Administrator's Guide

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.

Stop ETL agent.

Log on to the Microsoft SQL Server Management Studio as the database administrator.

Create the database.

Run the script to create database objects:

▪ kofax_analytics_staging.sql (staging database)

▪ kofax_analytics.sql (data warehouse).

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).

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.

Stop ETL agent.

Log on to a database management tool, such as Oracle SQL Developer, as the sys user

(role SYSDBA).

Create a user, e.g. StagingUser or DwhUser.

Assign tablespace quota to this user, or grant it unlimited tablespace privilege.

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

<user_name>;

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).

Run the script to create database objects. Sample sqlplus command:

sqlplus DwhUser/pwd@localhost @kofax_analytics_oracle.sql

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

<user_name>;

1 2 ... 14 15 16 17 18 19 20 21 22 23 24 ... 43 44

Sem comentários

Kofax Capture Manual do Utilizador Página 19