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 Repository Repositories

Step 3. Configure
B2B Data Exchange
Repository
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 B2B Data Exchange repository
    Creates a repository in the database.
    1- Create a Data Integration Hub repository
    Creates a repository in the database.
    2- Use an existing B2B Data Exchange repository
    Uses the tables and data in an existing repository.
    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
    1
     to use an Oracle database as the
    B2B Data Exchange
     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 is 1433.
    • Database SID. System identifier for the database.
    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 for the Oracle database or the Microsoft SQL Server database.
    Database user password
    The password for the database account for the Oracle database or the Microsoft SQL Server database.
    B2B Data Exchange
     stores the password as an encrypted string.
  6. Press
    Enter
    .
    If you selected to install the
    B2B Data Exchange
     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 Configure the Web Server and Port Numbers.
  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 is 1433.
    • Oracle database: Database SID. System identifier for the database.
    • Microsoft SQL Server 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 Oracle database or the Microsoft SQL Server database.
    Database user password
    The password for the database account for the Oracle database or the Microsoft SQL Server database.
    B2B Data Exchange
     stores the password as an encrypted string.
  10. Press
    Enter
    .
    If you selected to install the
    B2B Data Exchange
     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 Configure the Web Server and Port Numbers.
0 COMMENTS
We’d like to hear from you!