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;
Configuration
update Configuration
set Configdata = NULL
where ConfigCode in (EXTERNALURL, LDAPBINDUSER,MOBILEAPPSTORELINK,SAVETODISKPATH,SMTP,SMTPPASSWORD,SMTPUSERNAME)
Event
Truncate Event
NOTE: If you need the event results, obviously don't truncate this.
EventArchive
Truncate EventArchive
IpClass
Set EmailLeft = 'EL'+IPID
Set EmaiRight = NULL
where IpId is not NULL
IpContact
Set emailaddress = 'email' + IPID + '@sanitized.com’
Where IpId is not NULL
Person
Set Firstname='FN'+IPID
Set Lastname='LN'+IPID
Set PreferredName='PN'+IPID
Set FullName='FLN'+IPID
Where IPID is not NULL
ReportBroadcastResult
truncate table reportbroadcastresult
ReportBroadcastRecipient
truncate reportbroadcastrecipient
ReportViewSource
Set Password=NULL
where SourceID is not NULL
If you are unsure about running the above, please reach out to the Yellowfin Support Team for further assistance.