Is it possible to use SQL Server or Oracle linked servers/databases for masking or subsetting?
I am referring to creating a linked server for MS SQL and Oracle. For MS SQL, it would be like this: https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-in-sql-server-management-studio/
In our scenario, we have the TDM Scramble database installed and linked to our Source database. Datamaker is running on the Scramble database. We first create the view on the Scramble database and then the created view is referenced to the Source database. Would this be possible?
CA Test Data Manager- Datamaker & Subset
SQL Server, Oracle, and MySQL are supported for subsetting and masking. You can refer to this documentation here for supported data sources: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/supported-data-sources.
We support database links for the SQL in masked inserts, but this just joins the tables in source and target. We do not support links to reference masking objects or views; this would be an enhancement request.
If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html.