Solution for PII (sensitive) columns in Visual Paradigm's ERD

How To
,
1

Hello,

What is the suggested way to define a column in Visual Paradigm’s (VP) ERD as a sensitive(PII) column. These kind of columns are important for an organisation as you can guess and should be able to be integrated (via API or else) with other platforms (such as Data Catalog, DB etc). Is it possible in VP?

Is it possible in VP to reengineer Google Big Query tables to VP? If not is there a plan to support Big Query?

Best Regards
seyhmus

2

Dear Seyhmus,

Thank you for your post. Currently, we do not support defining PII column. However, you can add a custom attribute to store this information, by using the tagged value feature. To do this:

  1. Right-click on a column and select Open Specification from the popup menu.
  2. At the top right of the specification window, click on the tiny triangle icon and select “Tagged Values” from the drop down menu.
    image
  3. Click Add near the bottom of the window and select Boolean from the popup menu.
    image
  4. Enter PII as the name of column.
    image
  5. You can see the value to be True to define a PII column.
    image

Alternatively, define a stereotype ‘PII’ and add it to PII columns.

  1. Click on the tiny triangle at the top of the Column Specification window and select Stereotype.
    image
  2. Click Edit Stereotypes… at the bottom left.
  3. This opens the Manage Steretyoes window. Keep Column (ERD) selected on the left and click Add… on the right.
    image
  4. Enter PII as the name of stereotype and click OK.
    image
    image486×503 7.34 KB
  5. Click OK again in the Manage Stereotypes window.
  6. Select PII and click > to add it to the column.
    image
  7. Repeat this step on any PII column.

Finally, we do not support reengineering Google Big Query tables. I will forward your post to our development team for further feasibility studies.

Best regards,
Jick Yeung

1 Like
3

@Jick thank you very much that helped a lot :ok_hand:. Is it also possible to read or export tagged values by API in order to integrate them to outside tech?

4

Hi Seyhmus,

Thank you for your reply. Yes, you can read and edit tagged values via our OpenAPI. The article below shows you an example about removing tagged value with the API.

Best regards,
Jick Yeung

1 Like