ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Configure FDM with an Oracle TNS connection string

book

Article ID: 200541

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Is it possible to configure FDM with an Oracle TNS connection string similar to the one used in TNSNAMES.ORA
For example: 
net_service_name=
 (DESCRIPTION= 
  (ADDRESS_LIST=
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))
  (ADDRESS_LIST=
   (FAILOVER=on)
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521))
  (CONNECT_DATA=(SERVICE_NAME=sales.us.example.com)))

Environment

Release : 4.7 - 4.9

Component : CA Test Data Manager FDM

Resolution

A patch (FastDataMasker-4.9.103.0.zip (Windows version) and FastDataMasker-4.9.103.0.tar.gz (Linux version)) is available by opening a support case.

After installing the new version, create a new connection profile and select ORACLETNS as the database type. 
The profile needs username, password and default schema as other Oracle profiles but it also needs a directory where the TNSNAMES.ORA file is located and the net service name from this file which should be used.

Additional Information

Oracle SQL Developer can be used to verify the TNS connection and verify access to tables.
In SQL Developer configure a TNS Connection type and default role, using the same user as used in FDM
Run the following commands to check the list of tables that are available:
SELECT table_name, owner FROM all_tables WHERE owner = 'username';
SELECT table_name, owner FROM all_tables WHERE owner = 'schema';