Configuring the Schema/Database for Data Archive

For data archival, you must create a separate schema (Oracle, PostgreSQL) or database (Microsoft SQL Server, MySQL).

Note:
The archive schema created for Oracle or PostgreSQL should be in the same database that hosts the production schema.

Install the ActiveTransferArchive component in the archive schema or database using Database Component Configurator (DCC). The ActiveTransferArchive component contains stored procedures required for the archival process. The component also creates a table for logging the execution history of the archival process. The ActiveTransferArchive component automatically installs the ActiveTransfer database component as well. The table structure in the archive schema or database is a mirror of the production schema or database.

The archive schema or database should have SELECT and DELETE permissions for the following tables that store runtime or transaction data in the production schema or database:

MFTTRANSACTION

MFTEVENTLOG

MFTACTIVITYLOG

MFTACTIVITYLOGMESSAGE

MFTACTIVITYDETAILS

MFTAGENTEVENTLOG

MFTAGENTACTIVITY

MFTAGENTACTIVITYDETAILS

The archive schema or database should have SELECT permissions for the following tables that store asset information such as actions, agents, and so on in the production schema or database:

SCHEDULEDACTIONS

POSTPROCESSEVENTS

MONITORFOLDERACTION

INSTANCECONFIG

SERVERCONFIG

PARTNERMAPPING

MFTAGENT

MFTAGENTEVENTS

The PostgreSQL archive and production schema should have the following list of GRANT, ALTER permissions:

GRANT CONNECT ON DATABASE postgres_db TO archive_user;

GRANT USAGE, CREATE ON SCHEMA archive_schema_name TO archive_user;

GRANT USAGE, CREATE ON SCHEMA production_schema_name TO archive_user;

GRANT ALL ON SCHEMA archive_schema_nameTO archive_user;

GRANT ALL ON SCHEMA production_schema_name TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA archive_schema_name GRANT ALL ON TABLES TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA archive_schema_name GRANT ALL ON SEQUENCES TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA archive_schema_name GRANT ALL ON FUNCTIONS TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA archive_schema_name GRANT ALL ON TYPES TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA production_schema_name GRANT ALL ON TABLES TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA production_schema_name GRANT ALL ON SEQUENCES TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA production_schema_name GRANT ALL ON FUNCTIONS TO archive_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA production_schema_name GRANT ALL ON TYPES TO archive_user;

GRANT ALL ON ALL TABLES IN SCHEMA production_schema_name TO archive_user;

GRANT ALL ON ALL SEQUENCES IN SCHEMA production_schema_name TO archive_user;

GRANT ALL ON ALL FUNCTIONS IN SCHEMA production_schema_name TO archive_user;