SQL Compliance Manager

Monitor, audit and alert on SQL Server user activity and data changes

logo idera

This email address is being protected from spambots. You need JavaScript enabled to view it. VIDEO

SQL Compliance Manager is a comprehensive auditing solution that uses policy-based algorithms to track changes to your SQL Server objects and data. SQL Compliance Manager gives you detailed visibility to determine who did “what”, “when”, “where”, and “how”, whether the event is initiated by privileged users or hackers. SQL Compliance Manager also helps ensure compliance with regulatory and data security requirements
such as SOX, PCI, FERPA, and HIPAA.

SQL Compliance Manager goes beyond traditional auditing approaches by providing real-time monitoring, alerting, and auditing of all data access, selects, updates, schema modifications and permission changes to SQL Server databases.



SQL Compliance Manager Audit SQL Database Screenshot

Audit sensitive data
Comply with regulatory standards by auditing the most sensitive data contained in your databases, right down to the column level. Determine where sensitive data resides with the integrated column search, and add this data and columns to the audit wizard.

Stop potential threats
Track access and changes to databases, alert on failed log-ins, and customize alerts to notify of activities that could cause harm to your SQL Server environment.

Pass audits with ease
Templates for PCI, SOX, HIPAA, and FERPA help you meet compliance requirements. A simple wizard helps add these compliance regulations to your audited SQL Server objects with preset auditing settings aligned to over 16 regulatory citations.

Generate reports
Design and export views from the web dashboard to easily create custom reports and choose from over 25 pre-defined compliance reports for detailed auditing. Pre-defined reports were developed in partnership with auditing experts to address critical security auditing & compliance reporting requirements. The Microsoft Reporting Services reports are available in the Console or can be easily deployed to SQL Reporting Services and customized if needed.

Minimal Overhead
Keeping an eye on SQL servers shouldn’t bring down your SQL enterprise. Using SQL Compliance Manager maintains a watchful eye on SQL servers without performance impact implications.

Web-based Dashboard
The web dashboard provides easy access to audit and compliance information from any web browser. Explore audited SQL Servers, configure and manage alerts and event filters, view and search activity and change logs, access audit reports, import and export audit settings, and more. The activity report card and audited instances widgets provide at-a-glance summaries of top audit activities and concerns.


Customizable Templates
Easily apply the right auditing settings to your servers and databases for Payment Card Industry (PCI), Family Educational Rights and Privacy Act (FERPA), Sarbanes Oxley Act (SOX), and Health Insurance Portability and Accountability Act (HIPAA) regulations. Extensive research is no longer required as you can simply define the objects and apply the (out-of-the-box) customizable templates.

Sensitive Column Search
Discover the location of sensitive data that needs to be audited using the integrated sensitive column search. The data search parameters are based on a user-selectable combination of pre-populated and custom defined search strings.

Sensitive Column Auditing & Alerting
Audit any combination of columns and track who has issued “SELECT” statements against any table whether they are end-users or privileged users. Additionally, you can be alerted when any combination of columns are accessed.

Data Auditing
Audit data changes on any table so you can compare before and after data values resulting from inserts, updates and deletions.

Extended Events Auditing
Monitor and audit SQL Server Extended Events (XEvents) for SELECT and DML events, to enable more efficient processing of large numbers of events and event types.

Audit Privileged Users
Allows you to include user-defined events (custom SQL Server event types) selected from a list in audited activities. You can audit, alert on, and filter user-defined events. Privileged user auditing is key to ensure all access to databases can be tracked and reported.

Low-overhead Data Collection
A lightweight agent captures data from the SQL Server extended events files and extracts the selected events for auditing. The data collected is saved to the repository in scheduled batches.

Tamper-proof Audit Data Repository
Guarantees the integrity of audit data by providing an immutable repository – any attempts at changing or tampering with the audit data can be detected.


Tech Specs

System Requirements

Management Console
-Windows 7 SP1+, Windows 8, Windows 8.1, Windows 10, Windows Server 2008 SP1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2016
-Microsoft .NET 4.0

Collection Server and Data Repository
-Windows 7 SP1+, Windows 8, Windows 8.1, Windows 10, Windows Server 2008 SP1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2016

Microsoft .NET 4.0
-Repository: SQL Server 2008 SP1+, SQL Server 2008 R2 SP1+, SQL Server 2012 SP1, SQL Server 2014, SQL Server 2016

-Windows 7 SP1+, Windows 8, Windows 8.1, Windows 10, Windows Server 2008 SP1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2016
-Microsoft .NET 4.0

Supported SQL Server Environments
-SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 SP1, SQL Server 2014, SQL Server 2016

Browser Support
-Internet Explorer 9+, Chrome, Firefox, Microsoft Edge



Compare the Top SQL Auditing Tools

IDERA relentlessly delivers the industry's most complete solution for 24x7 SQL server performance monitoring, alerting, and diagnostics and tirelessly supports the SQL community with 100% free tools and expert advice.

Compare, side by side, the features and functionalities of the best SQL auditing tools the market has to offer.

ComplianceManager Comparison


SQL Compliance Manager is offered per instance. A license is needed for each (per) SQL Server instance that is being monitored.

Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.

Download a free 30 days trial.