Installation for PowerCenter and Data Quality

10.5.2
- 10.5.6
- 10.5.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Microsoft SQL Server Database Requirements

Use the following guidelines when you set up the repository:

Specify the database schema name when you use Microsoft SQL Server as the Model Repository database.

Set the allow snapshot isolation and read committed isolation level to ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to minimize locking contention.

To set the isolation level for the database, run the following commands:

ALTER DATABASE DatabaseName
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE DatabaseName
SET READ_COMMITTED_SNAPSHOT ON

To verify that the isolation level for the database is correct, run the following commands:

SELECT snapshot_isolation_state FROM sys.databases WHERE name=[DatabaseName]

SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name = DatabaseName

The database user account must have the CONNECT, CREATE TABLE, and CREATE VIEW privileges.

The guidelines to set up the repositories for Microsoft Azure SQL Database and Azure SQL Database with Active Directory authentication is the same.

Rename Saved Search

Table of Contents

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Microsoft SQL Server Database Requirements

Microsoft SQL Server Database Requirements