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
  • Multidomain MDM 10.3 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Pre-Installation Tasks
  4. Hub Store Installation
  5. Hub Store Post-Installation Tasks
  6. Hub Server Installation
  7. Hub Server Post-Installation Tasks
  8. Process Server Installation
  9. Process Server Post-Installation Tasks
  10. ActiveVOS Post-Installation Tasks for the Application Server
  11. ActiveVOS Post-Installation Tasks for the Business Entity Adapter
  12. Resource Kit Installation
  13. Resource Kit Post-Installation Tasks
  14. Troubleshooting the MDM Hub
  15. Uninstallation

Installation Guide for Oracle Database with IBM WebSphere

Installation Guide for Oracle Database with IBM WebSphere

Back Next

Step 2. Create an MDM Hub Master Database Data Source

Step 2. Create an MDM Hub Master Database Data Source

After you install the JDBC driver, on the Process Server machine, create a data source for the MDM Hub Master Database.
  1. Start the WebSphere Application Server Administrative Console.
  2. Specify the location of the driver libraries.
    1. Expand
      Environment
       in the console navigation tree.
    2. Click the
      WebSphere Variables
       link.
    3. Update the JDBC variable to point to the following JDBC driver directory:
      <
      WebSphere installation directory
      >/lib
  3. Create the security account that the MDM Hub Master Database data source will use.
    1. Expand
      Security
       in the console navigation tree.
    2. Click the
      Secure administration, applications, and infrastructure
       link.
    3. Under
      Authentication
      , expand
      Java Authentication and Authorization Service
      , and click
      J2C Authentication Data
      .
    4. Click
      New
      , and specify the following properties:
      Property
      Description
      Alias
      Name of the MDM Hub Master Database.
      User ID
      User name to connect to the MDM Hub Master Database.
      Password
      Password to access the MDM Hub Master Database.
    5. Click
      OK
      .
  4. Create the JDBC Provider.
    1. Expand
      Resources
      JDBC
      , and then click
      JDBC Providers
      .
      The
      JDBC Provider
       page appears.
    2. Select the scope for applications to use the data source.
    3. Click
      New
      , and specify the following properties:
      Property
      Description
      Database type
      Type of database.
      Select
      Oracle.
      Provider type
      Type of JDBC provider.
      Select
      Oracle JDBC Driver
      .
      Implementation type
      Data source implementation type.
      Select
      XA data source
      .
      Name
      Name of the JDBC provider.
      Change the name to
      Informatica MDM Oracle JDBC Provider (XA)
      .
    4. Click
      Next
      , and then click
      Finish
      .
  5. Create the MDM Hub Master Database data source.
    1. Click the JDBC provider that you created.
      The
      Configuration
       page appears.
    2. Under
      Additional Properties
      , click
      Data sources
      .
      The
      Data Sources
       page appears.
    3. Click
      New
      .
    4. Specify the following data source properties:
      Property
      Description
      Name
      Data source name. Specify
      MDM Master Data Source
      .
      JNDI Name
      JNDI path to where the JDBC data source will be bound. Specify
      jdbc/siperian-cmx_system-ds
      .
      The JNDI name must be in lower case.
      Component-managed Authentication Alias
      Authentication alias of the Master Database data source. Select
      <host name>/cmx_system
      .
    5. Click
      Next
      , and then click
      Finish
      .
0 COMMENTS
We’d like to hear from you!