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
  • B2B Data Exchange 10.2
  • All Products

Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Begin
  4. Pre-Installation Tasks
  5. B2B Data Exchange Installation
  6. Post-Installation Tasks
  7. Installing the Partners Portal on Non-B2B Data Exchange Nodes
  8. Upgrading B2B Data Exchange
  9. Starting and Stopping B2B Data Exchange
  10. Optional B2B Data Exchange Configuration
  11. Installing and Configuring the B2B Data Exchange Accelerator for Data Archive
  12. Uninstallation

Installation and Configuration Guide

Installation and Configuration Guide

Back Next

Step 3. Configure B2B Data Exchange Repositories Repository

Step 3. Configure
B2B Data Exchange
Repositories
Repository

  1. On the
    Metadata Repository
     page, select one of the following options:
    • Create a B2B Data Exchange repository
      . Creates a repository in the database.
    • Create a Data Integration Hub repository
      . Creates a repository in the database.
    • Use an existing B2B Data Exchange repository
      . Uses the tables and data in an existing
      B2B Data Exchange
       repository and upgrades the repository.
    • Use an existing Data Integration Hub repository
      . Uses the tables and data in an existing
      B2B Data Exchange
       repository and upgrades the repository.
  2. Click
    Next
    .
    The
    Metadata Repository Connection
     page appears.
  3. Enter values in the following fields:
    Database type
    Type of database to use for the
    B2B Data Exchange
     metadata repository. You can choose one of the following options:
    • Oracle
    • Microsoft SQL Server
    Database URL
    Location of the database.
    If you select this option, enter the values in the following fields:
    • Database host name
      . Host name of the machine where the database server is installed.
    • Database port
      . Port number for the database. The default port number for Oracle is 1521. The default port number for Microsoft SQL Server is 1433.
    • Database SID
      . System identifier for the database if the database is Oracle. Enter either a fully qualified ServiceName or a fully qualified SID.
      It is recommended that you enter a ServiceName in this field.
    • Microsoft SQL Server database
      . Database name.
    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. Available 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;
    Use Windows Authentication
    Instructs
    B2B Data Exchange
     to authenticate user names against the Microsoft Windows authentication mechanism. Available when you select a Microsoft SQL Server database.
    Database username
    Name of the database user account for the Oracle database or Microsoft SQL Server database where you do not use Windows authentication.
    Database user password
    Password for the database account for the Oracle database or Microsoft SQL Server database where you do not use Windows authentication.
    B2B Data Exchange
     stores the password as an encrypted string.
  4. Click
    Next
    .
    The
    Publication Repository Connection
     page appears.
  5. Enter values in the following fields:
    Database type
    Type of database to use for the publication repository. The database type must match the
    B2B Data Exchange
     metadata repository database type and appears in read-only mode.
    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
      . Port number for the database. The default port number for Oracle is 1521. The default port for Microsoft SQL Server is 1433.
    • Database SID
      . System identifier for the database if the database is Oracle. Enter either a fully qualified ServiceName or a fully qualified SID.
      It is recommended that you enter a ServiceName in this field.
    • Microsoft SQL Server database: Database name
      . Name of the database instance.
    Custom Connection String
    JDBC connection string to the database.
    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.
    Use Windows Authentication
    Instructs
    B2B Data Exchange
     to authenticate user names against the Microsoft Windows authentication mechanism. Available when you select a Microsoft SQL Server database.
    Database username
    Name of the database user account for the Oracle database or Microsoft SQL Server database where you do not use Windows authentication.
    Database user password
    Password of the database account for the Oracle database or Microsoft SQL Server database where you do not use Windows authentication.
    B2B Data Exchange
     stores the password as an encrypted string.
  6. Click
    Next
    .
    If you selected the
    B2B Data Exchange Dashboard and Reports
    Data Integration Hub Dashboard and Reports
     component, the
    Operational Data Store
     page appears. If you did not select the Dashboard and Reports component, go to Step 5. Configure Document Store and Web Server.
0 COMMENTS
We’d like to hear from you!