TDM FDM: In-Flight Masking - *.dmp Files

Document ID : KB000077178
Last Modified Date : 01/11/2018
Show Technical Document Details
Introduction:
With the requirement to import masked data into a different server, the question arose:
Is it necessary to move the *.dmp files manually or is possible change the destination directory and save the *.dmp files in the remote server like a normal subset.

All this because, extracting the files brings processes at the business level as extra permissions among others.
Question:
[Question]
Do we need import the data in a different server, is necessary move the *.dmp files manually or is possible change the destination directory and save the *.dmp files in the remote server like a normal subset?
Environment:
TDM 4.x
    Subset
Oracle
Answer:
This is a limitation of the Oracle Datapump utility.
Basically, the files have to be created on the same machine as the database itself, they cannot be on a network. Datapump uses an Oracle directory, which is a pointer to a physical directory.
So you cannot run the export/import from a client machine when the datapump directory is pointing to a directory on the client machine, the datapump directory has to be local to the database itself. For the import, the files have to be copied to the target server for the same reason.
Additional Information:
[Reference material]
--> https://docops.ca.com/ca-test-data-manager/4-4/en/provisioning-test-data/mask-production-data/fast-data-masker-and-transformation-maps
--> https://comm.support.ca.com/kb/how-to-run-inflight-masking-scripts-on-a-remote-server/kb000010138
 

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of ARD by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html