Is it possible to configure FDM with an Oracle TNS connection string similar to the one used in TNSNAMES.ORA
Release : 4.7 - 4.9
Component : CA Test Data Manager FDM
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.
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';