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 3
  • All Products

Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Appendix A: Troubleshooting the Upgrade Process
  16. Appendix B: Frequently Asked Questions
  17. Appendix C: Processing Existing ActiveVOS Tasks
  18. Appendix D: Configuring Metadata Caching

Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Back Next

Step 3. Create an Operational Reference Store Data Source

Step 3. Create an Operational Reference Store Data Source

After you install the JDBC driver, on the Process Server machine, create a data source for each Operational Reference Store.
  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 Operational Reference Store 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 set the following properties:
      Property
      Description
      Alias
      Name of the Operational Reference Store.
      User ID
      User name to connect to the Operational Reference Store.
      Password
      Password to access the Operational Reference Store.
    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 Operational Reference Store 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 ORS Data Source
      .
      JNDI Name
      JNDI path to where the JDBC data source will be bound. Specify
      jdbc/siperian-<Oracle host name>-<Oracle SID>-<Operational Reference Store name>-ds
      jdbc/siperian-<IBM DB2 host name>-<IBM DB2 database name>-<Operational Reference Store name>-ds
      jdbc/siperian-<Microsoft SQL Server host name>-<Operational Reference Store name>-ds
      .
      The JNDI name must be in lower case.
      Component-managed Authentication Alias
      Authentication alias of the Master Database data source. Select
      <host name>/<Operational Reference Store name>
      .
      Driver Class Name
      JDBC driver class. Set to
      com.microsoft.sqlserver.jdbc.SQLServerXADataSource
      .
    5. Click
      Next
      , and then click
      Finish
      .
0 COMMENTS
We’d like to hear from you!