How to decrypt the PII Data when the data source is a SQL View

kimjohn

I have a table (entity) with a field marked as containing PII (Personally Identifiable Information) or encrypted data. Is there a way to display this field in a report when the data source is an SQL view (external DB connection)?

amershaik_Decisions

For this we can have the following suggestions:

First:-

1. Create a Data Structure with all the data fields used from different tables similar as in SQL view.
2. Edit the existing flows where you create the records of all different 20 tables, add the Create step of newly created Data Structure or Selective Update step of newly created Data Structure, so that you have the data of all different data fields from different tables.

Second:-

1. Create a Data Structure with all the data fields used from different tables similar as in SQL view.
2. Create a new flow with Create Step of new Data Structure where you create data from all different tables at once and populate them in the report.