Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Configuring the Oracle Target Database Example

Configuring the Oracle Target Database Example

The target database configuration defines the connection parameters that the Dynamic Data Masking service uses to connect to the database. The easiest way to identify the correct database connection settings is to use the information from
tnsnames.ora
. The following example shows how you can use the database parameters from
tnsnames.ora
to configure a database in the Database Editor.
The following entry is from
tnsnames.ora
:
ORA11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11g) ) )
The following table shows how the parameters in
tnsnames.ora
correspond to the parameters in the Management Console:
Parameter Value in tnsnames.ora
Parameter Name in the Database Editor
ORA11G
Instance Name
localhost
Listener Address
1521
Listener Port
ora11g
Service Name

0 COMMENTS

We’d like to hear from you!