Database Validation Tool
We're run into multiple issues in the past that we were unable to resolve as we do not have a deep understanding of the Yellowfin DB structure. Rather than try to understand the DB, can we have a tool that can validate the Yellowfin DB health? This would check for;
-Orphaned records (records where parent records are deleted/changed)
-NULL values where there shouldn't be. E.g. a NULL value in one particular row could cause UI export issues.
-Key Generator Tables and ID's. We had a case where a DB was migrated, though the key generator tables were not re-created so the new DB was overriding existing data.
-Disconnected Fields on views. While we have queries to identify this, this should be included in the overall DB health check.
-Table indexes. We know indexes get created as part of the install, though would be good to check that all indexes are present based on latest release.