Before running discovery or masking operations, ensure that the target database is properly prepared for access by DCT Compliance.
Preparing the database involves configuring user permissions and ensuring that the database allows the required discovery and masking operations.
DCT Compliance accesses data sources through connectors and executes operations through compliance nodes associated with a Job Orchestrator. The database must allow connections from these nodes and provide the required privileges for reading and updating data.
Database preparation typically includes:
-
Creating or identifying a database user for masking operations
-
Granting required permissions to access tables and metadata
-
Configuring network access between the database and compliance nodes
-
Verifying that the database supports the required operations
The required configuration may vary depending on the database platform.
Refer to the following topics for database-specific preparation instructions.
Prepare Oracle database for discovery and masking
Prepare SQL server database for discovery and masking
Prepare Sybase database for discovery and masking
Preparing Db2 database for discovery and masking