Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Hub 10.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Begin
  4. Pre-Installation Tasks
  5. Data Integration Hub Installation
  6. Post-Installation Tasks
  7. Upgrading Data Integration Hub
  8. Starting and Stopping Data Integration Hub
  9. Optional Data Integration Hub Configuration
  10. Installing and Configuring the Data Integration Hub Accelerator for Data Archive
  11. Troubleshooting the Data Integration Hub Installation
  12. Uninstallation

Installation and Configuration Guide

Installation and Configuration Guide

Back Next

Step 3. Configure Data Integration Hub Repositories

Step 3. Configure
Data Integration Hub
Repositories

  1. In the
    Metadata Repository
     section, enter the number for the metadata repository database configuration option or accept the default option:
    1- Create a Data Integration Hub repository
    Creates a repository in the database.
    2- Use an existing Data Integration Hub repository
    Uses the tables and data in an existing repository.
  2. Press
    Enter
    .
    The
    Metadata Repository Connection
     section appears.
  3. Enter one of the following numericals depending on the database you plan to use as the
    Data Integration Hub
     metadata repository database:
    • Enter
      1
       to use an Oracle database as the
      Data Integration Hub
       metadata repository database.
    • Enter
      2
       to use Microsoft SQL Server database as the
      Data Integration Hub
       metadata repository database.
  4. Enter the number for the metadata repository database connection type or accept the default connection type:
    1- Database URL
    Location of the database. If you select this option, enter values in the following fields:
    • Database Host Name
      . Host name of the machine where the database server is installed.
    • Database Port Number
      . Port number for the database. The default port number for Oracle is 1521. The default port for Microsoft SQL Server
      and Microsoft Azure SQL Database is
       1433.
    • Database SID
      . System identifier for the database.
    • Microsoft SQL Server database
      or
      Microsoft Azure SQL Database
      . Database name. Name of the database instance.
    2- Custom Connection String
    Connection string to the database. If you select this option, enter values in one of the following fields:
    • JDBC string. JDBC connection string to the metadata repository.
    • ODBC string. ODBC connection string to the metadata repository. Applicable if you install the PowerCenter client plug-in. The installer cannot verify the validity of the ODBC string.
    If you use a named Microsoft SQL Server database instance, you cannot connect to the database instance using the
    Database URL
     option. Use the
    Custom Connection String
     option.
    For example:
    jdbc:informatica:sqlserver://MYSQLSERVERCOMPUTERHOSTNAME\MYDBINSTANCENAME;DatabaseName=MYDATABASENAME;
  5. Enter values in the following fields:
    Database username
    Name of the database user account.
    Database user password
    The password for the database account for the database.
    Data Integration Hub
     stores the password as an encrypted string.
  6. Press
    Enter
    .
  7. Enter the number for the publication repository connection type or accept the default connection type.
    When using Microsoft SQL Server named instances, you must define a custom connection string.
    1- Database URL
    Location of the database. If you select this option, enter values in the following fields:
    • Database host name
      . Host name of the machine where the database server is installed.
    • Database port number.
       Port number for the database. The default port number for Oracle is 1521. The default port for Microsoft SQL Server
      or Microsoft Azure SQL Database
      .
    • Oracle database
      . Database SID. System identifier for the database.
    • Microsoft SQL Server database
      or
      Microsoft Azure SQL Database
      . Database name. Name of the database instance.
    2- Custom Connection String
    Connection string to the database. If you select this option, enter values in one of the following fields:
    • JDBC string
      . JDBC connection string to the publication repository.
    • ODBC string
      . Applicable if you install the PowerCenter client plug-in. ODBC connection string to the publication repository. The installer cannot verify the validity of the ODBC string.
    If you use a named Microsoft SQL Server database instance, you cannot connect to the database instance using the
    Database URL
     option. Use the
    Custom Connection String
     option.
    For example:
    jdbc:informatica:sqlserver://MYSQLSERVERCOMPUTERHOSTNAME\MYDBINSTANCENAME;DatabaseName=MYDATABASENAME;
  8. Press
    Enter
    .
  9. Enter values in the following fields:
    Database username
    Name of the database user account for the database.
    Database user password
    The password for the database account.
    Data Integration Hub
     stores the password as an encrypted string.
  10. Press
    Enter
    .
    If you selected to install the
    Data Integration Hub
     Dashboard and Reports component, the
    Operational Data Store
     section appears. If you did not select to install the Dashboard and Reports component, go to Step 5. Configure the Web Server.
Back to Top
0 COMMENTS
Back Next
We’d like to hear from you!