The Yellowfin Repositorty DB used to store meta data for content (e.g. SQL generated) , configuration settings (e.g. Email, Scheduler), and also user login information. If wanting to obfuscate such rows, the following queries can help.
Please ensure you have a full backup prior to running any of these queries, and that some of these queries may need to be translated to your DBMS of choice;
set Configdata = NULL
where ConfigCode in (EXTERNALURL, LDAPBINDUSER,MOBILEAPPSTORELINK,SAVETODISKPATH,SMTP,SMTPPASSWORD,SMTPUSERNAME)
NOTE: If you need the event results, obviously don't truncate this.
Set EmailLeft = 'EL'+IPID
Set EmaiRight = NULL
where IpId is not NULL
Set emailaddress = 'email' + IPID + '@sanitized.com’
Where IpId is not NULL
Where IPID is not NULL
truncate table reportbroadcastresult
where SourceID is not NULL
If you are unsure about running the above, please reach out to the Yellowfin Support Team for further assistance.