TrustRadius: an HG Insights company

IDERA SQL Compliance Manager

Score9 out of 10

2 Reviews and Ratings

What is IDERA SQL Compliance Manager?

SQL Compliance Manager helps database administrators to monitor, audit, and alert on Microsoft SQL Server user activity and data changes. The vendor states it provides quick configuration of audit settings, a broad list of regulatory guideline templates for audit settings and reports, before and after data values for both regulatory compliance and forensic data investigations, differentiation of data access and between regular and privileged users and applications, easy specification of and reporting on sensitive data columns access and changes, and extensive customization of audit settings for databases and servers.

Media

SQL Compliance Manager: Monitor, audit, and alert on user activity and data change

Top Performing Features

  • User management

    Tools to help manage user and role administration

    Category average: 8.6

  • Database security

    Security maintenance such as authorization management, log analysis, database auditing

    Category average: 8.6

Areas for Improvement

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