We have operational data store where database is structured with multiple schemas. Means, there is no master or global schemas where all tables can be browsed. To implement masking, multiple connections to be made with different schemas and multiple masking jobs to be built for same database.
But, product doesn't allow to map multiple masking jobs while creating VDB from dSource. Is anyone come across this situation and solution to handle?
So far, I was busy with profiling data and mapping masking rules. Reached a stage where I need to start putting some code together.
It would be great help if you have any sample script that you have coded.
True, this approach can work for manual. the whole idea is to bring delphix as self service for development and testing communities. Earlier, I thought 1-2 databases have multiple schemas, but I was wrong and there are many to handle. So, automation is the need for us.