A great and handy tool
Use Cases and Deployment Scope
IDERA SQL Compliance Manager is a very handy tool it will audit the SQL Logins, using the HIPAA and PCI DSS compliance for the payment card industry as well. When the auditor asks DBA which transactions have been performed we can check it easily. A compliance manager is more than an auditing tool that can track the changes which you need to check at the database level.
Pros
- Audit Logins
- DML Activities
- DDL Activities
- Queries Reporting
Cons
- Should have a compression algorithm to compress the audited logs, as it will take a lot of space.
- Can not audit all the DML and DDL activities as it will take a lot of space, should have a compression algo.
Most Important Features
- Query reporting
- Audit logs
Return on Investment
- Audit reports are a hectic job for a DBA it made them easy.
Alternatives Considered
Microsoft SQL Server
Other Software Used
IDERA SQL Diagnostic Manager for SQL Server, Microsoft SQL Server, Microsoft Power BI, MS SharePoint / SQL, Microsoft SharePoint, Azure DevOps Server, Microsoft Power BI Embedded

