Table of Contents

Search

  1. Installation Overview
  2. Before You Install the Services
  3. Service Installation
  4. After You Install the Services
  5. Client Installation
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases from Windows
  9. Connecting to Databases from UNIX
  10. Updating the DynamicSections Parameter of a DB2 Database
  11. Installation and Configuration Checklist
  12. Split Domain Configuration for Metadata Manager

Installation and Configuration Guide

Installation and Configuration Guide

Microsoft Azure SQL Database Requirements

Microsoft Azure SQL Database Requirements

Use the following guidelines when you set up the repository on Microsoft SQL Server:
  • 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.