Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Oracle Configuration Properties

Oracle Configuration Properties

Update the configuration properties when you create or edit an Oracle resource.
The following table describes the Oracle configuration properties:
Property
Description
User name
Name of the user account used to connect to the Oracle database.
Password
Password for the user account used to connect to the Oracle database.
JDBC connection URL
JDBC URL used to connect to the Oracle database. Metadata Manager uses this URL to verify connection information to the Oracle database.
If the Oracle database is not clustered, use the following syntax:
jdbc:informatica:oracle://[host name]:[port];SID=[sid]
You can enter the SID or edit the string to use the full service name. For example:
jdbc:informatica:oracle://[host name]:[port];ServiceName=[service name]
If the Oracle database is clustered, use the following syntax:
jdbc:informatica:oracle://[host1]:[port];ServiceName=[service name];AlternateServers = ([host2]:[port]);LoadBalancing=true
If the Oracle database uses the Advanced Security Option, use the following syntax:
jdbc:informatica:oracle://[host name]:[port];SID=[SID];EncryptionLevel=[encryption level];EncryptionTypes=[encryption types];DataIntegrityLevel=[data integrity level];DataIntegrityTypes=[data integrity types]
Secure JDBC parameters
Secure JDBC parameters that you want to append to the JDBC connection URL. Use this property to specify secure connection parameters such as passwords. Metadata Manager does not display secure parameters or parameter values in the resource configuration properties. Enter the parameters as name=value pairs separated by the delimiter character that the database driver requires. For example:
param1=value1;param2=value2
If secure communication is enabled for the database, enter the secure JDBC parameters in this property.
Connect string
Native connect string used to create a source connection to the database in the PowerCenter repository. The connect string is the same as the Oracle TNSNAMES entry on the machine where the associated Integration Service for Metadata Manager runs.
Use the following syntax:
<database name>.world
Encoding
Code page for the Oracle database.
Only code pages that are compatible with the code page of the Metadata Manager repository are displayed.
Incremental load
Enables incremental loading for the resource after the first successful resource load.
When you enable this option, Metadata Manager loads recent changes to the metadata instead of loading complete metadata. When you disable this option, Metadata Manager performs a full metadata load.
Default is disabled.

0 COMMENTS

We’d like to hear from you!