Abstract
Supported Versions
How to Implement PowerCenter on Microsoft Azure

How to Implement PowerCenter on Microsoft Azure

Back Next

Step 2. Create Users for Repositories and Domain in SQL Server

You need to create the users for repositories and domain in the Microsoft SQL Server.

To create a Microsoft SQL Server schema, enter the following command:

CREATE LOGIN "<username>" WITH PASSWORD = '<password>'
CREATE USER "<username>" FOR LOGIN "<username>" WITH 
DEFAULT_SCHEMA = "<username>"
CREATE SCHEMA "<username>" AUTHORIZATION "<username>"

Ensure that you create two schemas, one for the domain repository and the other for the PowerCenter repository.

Migrate On-Premises PowerCenter Domain to Azure

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

How to Implement PowerCenter on Microsoft Azure

How to Implement PowerCenter on Microsoft Azure

Step 2. Create Users for Repositories and Domain in SQL Server

Step 2. Create Users for Repositories and Domain in SQL Server