{"id":37343,"date":"2025-02-20T16:55:44","date_gmt":"2025-02-20T15:55:44","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=37343"},"modified":"2025-02-21T12:27:23","modified_gmt":"2025-02-21T11:27:23","slug":"delphix-data-virtualization-and-masking","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/delphix-data-virtualization-and-masking\/","title":{"rendered":"Delphix Data Virtualization and Masking"},"content":{"rendered":"\n

After successfully completing several customer projects involving Delphix products, Data Virtualization <\/strong> and Data Masking<\/strong>, I decided to set up a complete infrastructure internally to test the combination of both products.<\/p>\n\n\n\n

Delphix Data Virtualization<\/a><\/strong> Creates only a virtual copy of your database blocks instead of a full physical copy. For example this allows making a new big database available only in a few seconds.<\/p>\n\n\n\n

Delphix Data Masking<\/a><\/strong> Protects sensitive data by replacing it with realistic but non-sensitive<\/strong> values, ensuring compliance with privacy regulations<\/strong> while maintaining data usability for development, testing, and analytics. For reference, dbi-services has developed Swiss masking rules for customers to apply all their specific needs.<\/p>\n\n\n\n

Setup<\/strong><\/h3>\n\n\n\n

As always, setting up the prerequisites took some time, but once the environment was built, it was truly rewarding to demonstrate the combined power of these tools to my colleagues. It’s a real pleasure, like a game, building database environments in a flash, where the data is directly masked.<\/p>\n\n\n\n

This allows you to rapidly provision databases to your internal or external developers, without taking any risk of a data phishing attack!<\/p>\n\n\n\n

Watch this video! It’s only a minute-long and you’ll see how easy it is! to create a new masked Oracle pluggable database VPDB2_masked on another server (These tasks can also be fully automated in a pipeline using an API)<\/p>\n\n\n\n

Relevant outcomes<\/strong> <\/h3>\n\n\n\n

The Delphix pricing model is based on the size of your databases, thus you can apply the same Virtualization and Masking capabilities at least for PostgreSQL, SQL Server, and Sybase at no additional cost. Are you interested in making your database development environments fully secure? Don\u2019t wait, dbi services has your solution!<\/p>\n\n\n\n

For those who are interested in more details <\/strong><\/h3>\n\n\n\n

1. Table data from the source database PDB1<\/p>\n\n\n\n

\"Original<\/figure>\n\n\n\n

2. Table data in the new created and masked virtual database VPDB2_Masked <\/p>\n\n\n\n

\"masked<\/figure>\n\n\n\n

3. Output of the masking job<\/p>\n\n\n\n

\"output<\/figure>\n\n\n\n