gilta03

Tech Tip: Can you use linked databases with Subset?

Discussion created by gilta03 Champion on Mar 2, 2018

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?

 

To see the answer to this question, please visit https://comm.support.ca.com/kb/can-you-use-linked-databases-with-subset/kb000072357  

Outcomes