This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Does SharePlex provide any data masking/scrubbing capabilities built into it?

Does SharePlex provide any data masking/scrubbing capabilities built into it? 

Use Case : If we plan to use SharePlex to replicate data from Oracle Standby to a lower environment and we would like to scrub/mask data on the lower environment, does Share plex provide any capabilities?

Thank You

Parents
  • Hello!  I'm assuming you're doing Oracle to Oracle replication here; It might be best to schedule a call with one of our Account Managers and Systems Engineers to to discuss this.   The "short answer" is yes, we can do this several ways in SharePlex.  First and simplest, you can simply choose not to replicate the columns you want to protect.   Another option would be to create a database trigger on the target system (for each table involved) that would actually perform the masking.   Also, SharePlex, rather than simply "posting" the captured data from the source on the target, can call a PL/SQL stored procedure (on the target) that could be coded to perform the masking and then write the masked data.

  • Thanks Clay.

    In this case, our lower environment is in SQL Server (As this is a part of Data Migration Project we are working from).

    Thank you for noting out the options which can be pursued in this case. If I need further help, I will reach out to your team.

    Thanks

Reply
  • Thanks Clay.

    In this case, our lower environment is in SQL Server (As this is a part of Data Migration Project we are working from).

    Thank you for noting out the options which can be pursued in this case. If I need further help, I will reach out to your team.

    Thanks

Children
No Data