What are the challenges you face when working across database platforms? Take the survey
Options

Can i export detail of each masked field?

Hi at all,

i am new to Data Masker tool and i need to export a report for each masked filed that can summarize which tyoe of masking rules are applied, for example:
_____________________________________________________

FIELD                |     RULES APPLIED                             |
_____________________________________________________

CUST.ID            |    SUBSTITUTION, SHUFFLE                |
CUST. NAME     |    SUBSTITUTION, TABLE TO TABLE    |

.....                   |    .....                                                |


It is possible? Can you help me?

Tagged:

Answers

  • Options
    Good Morning @Fausto thank you for your post.
    You can generate something similar with Data Masker if you go to the Tools tab and hit "Rule Structure Report"
    If you generate a full structure report it should include a similar list to the one you're looking at creating.
    Let me know if this works and if you have any additional questions - happy to help!
    Thank you very much.
  • Options
    FaustoFausto Posts: 2 New member

    @dOCTOClone thanks for your answer, that report fit my core needs.


    If i want to show data in more familiar way, are these data also available in specific tables that i can access and from where i can extract data via ETL (Pentaho, Kingsway, etc..)

    Thanks a lot

    Regards

    Fausto

  • Options
    Hi @Fausto
    There are tables generated at run-time, the DMS Stats tables for Rules and for Tables - these tell you how the rules ran and how many rows/columns etc. on the various tables were masked.
    Unfortunately, these don't provide detail down to the column level like the report generator in the tools tab, but could be utilised and somehow pulled out to give a better overall idea of the masking in other tools, if that helps?
    Thank you very much - let me know if you have any other questions!
Sign In or Register to comment.