Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

Create the PowerCenter Repository Service

Create the PowerCenter Repository Service

Use the service creation wizard in the Administrator tool to create the service.
  1. In the Administrator tool, click the
    Manage
    tab.
  2. Click
    Actions
    New
    PowerCenter Repository Service
    .
    The
    New PowerCenter Repository Service
    dialog box appears.
  3. 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.
  4. Click
    Next
    .
    The
    New PowerCenter Repository Service - Step 2 of 2
    page appears.
  5. 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.
  6. Select
    No content exists under specified connection string. Create new content.
  7. 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.
  8. 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.
  9. 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.

0 COMMENTS

We’d like to hear from you!