Installation for PowerCenter and Data Quality

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

Back Next

Create the PowerCenter Repository Service

Use the service creation wizard in the Administrator tool to create the service.

In the Administrator tool, click the

Manage

tab.

Click

Actions

New

PowerCenter Repository Service

The

New PowerCenter Repository Service

dialog box appears.

On the

New PowerCenter Repository Service - Step 1 of 2

page, enter the following properties:

Property	Description
Name	Name of the service. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > \| ! ( ) ] [
Description	Description of the service. The description cannot exceed 765 characters.
Location	Domain and folder where the service is created. Click Browse to choose a different folder. You can move the service after you create it.
License	License object that allows use of the service.
Node	Node on which the service runs.
Primary Node	If your license includes high availability, node on which the service runs by default. Required if you select a license that includes high availability.
Backup Nodes	If your license includes high availability, nodes on which the service can run if the primary node is unavailable.

Click

The

New PowerCenter Repository Service - Step 2 of 2

page appears.

Enter the following properties for the PowerCenter repository database:

Property	Description
Database Type	The type of the repository database.
Username	The database user name for the repository.
Password	Password for the PowerCenter repository database user. Must be in 7-bit ASCII.
Connection String	Native connection string the PowerCenter Repository Service uses to access the repository database. Use the following native connect string syntax for each supported database: servername@databasename for Microsoft SQL Server and Sybase. databasename.world for Oracle. databasename for IBM DB2.
Code Page	Repository database code page. The PowerCenter Repository Service uses the character set encoded in the database code page to write data. You cannot change the code page in the PowerCenter Repository Service properties after you create the PowerCenter Repository Service.
Tablespace Name	Name of the tablespace in which to create all the repository database tables. You cannot use spaces in the tablespace name. Available for IBM DB2 and Sybase databases. To improve repository performance on IBM DB2 EEE repositories, specify a tablespace name with one node.

Select

No content exists under specified connection string. Create new content.

Optionally, choose to create a global repository.

After you create the service, you can promote a local repository to a global repository, but you cannot change a global repository to a local repository.

If your license has the team-based development option, you can optionally enable version control of the repository.

After you create the service, you can convert a non-versioned repository to a versioned repository, but you cannot convert a versioned repository to a non-versioned repository.

Click

Finish

The domain creates the PowerCenter Repository Service, starts the service, and creates content for the PowerCenter repository.

After you create the service through the wizard, you can edit the properties or configure other properties.

Rename Saved Search

Table of Contents

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Create the PowerCenter Repository Service

Create the PowerCenter Repository Service