search cancel

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

Download a version of FastDataMasker after 4.9.103 from
Test Data Manager FDM patches

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';