Monitor, audit, and alert
on user activity and data change for airtight database security
Your databases contain your most valuable business assets, making data security a critical business function. Idera SQL Compliance Manager protects those assets — and your peace of mind — with robust alerting features and audit reporting tools. What's more, SQL Compliance Manager helps you address your industry’s tough regulatory compliance requirements with confidence, and ensure your SQL Server is HIPAA-compliant, GDPR-compliant, and more.
Monitor, alert, and log access to databases and servers
Scan your databases to identify personal data and other sensitive data
Create trustworthy audit records and reports of security events
Validate that the audit trail repository has not been tampered with
- Customize regulatory guideline templates
Apply the right SQL Server auditing settings to your servers and databases for PCI DSS, DISA STIG, NERC, CIS, FERPA, SOX, GDPR, and HIPAA regulations.
- Apply fine-grained filtering
Quickly compare your customized or modified audit configuration against the regulation guidelines to verify that your settings are compliant.
- Use default configuration settings
Reduce data collection, transmission, and storage overhead with powerful filtering capabilities that enable you to collect only the data that is important for audit and compliance.
- Generate reports
Define and apply default configuration settings at the server or database level, view any differences from default settings, and add new databases to the auditing list automatically.
- Audit SQL Server access
Perform comprehensive auditing of SQL Server data changes and database events, including trace events, extended events, and audit logs.
- Capture before and after data
Discover sensitive data that needs to be audited using the integrated sensitive column search, then audit any combination of columns and be alerted when they are accessed.
- Audit sensitive data
Compare before/after data (BAD) values resulting from inserts, updates, and deletions on any table.
- Run tamper-proof audits
Audit privileged users to ensure all SQL Server database accesses are tracked and reported, or designate a Server Level Trusted User to reduce data collection for that user.
- Customize alerting
Define rules to receive immediate notification, with customizable alerts for more than 200 specific SQL Server Event types that can be stored in the audit repository, emailed directly to a user, or written to an event log.
- Alert on thresholds
Filter, alert on, and audit user-defined events, for full tracking and reporting of privileged user database activity.
- Customize auditing
Configure multiple event threshold levels, and set system alerts (via email, event log, or SNMP) when they are exceeded.
- Alert to specific data
Issue alerts based on defined rules for events, status, or data for sensitive columns or before/after data (BAD) changes.
- Audit at the enterprise level
Easily manage and track SQL Server audit activity over a large number of servers with real-time monitoring of agent activity and the audit data stream.
- Support availability groups
Guarantee the integrity of audit data with an immutable repository that automatically detects attempts to change or tamper with data.
- Setup tamper-proof auditing
Avoid losing SQL Server audit data trail in the event of failure—automatically switch auditing from primary to the secondary replica in the event of failure, and fallback to primary when it comes back online.
- Provide read-only access
Grant users read-only auditor privileges, to support report and query execution as well as self-audit, integrity reporting, and configuration and data collection parameter change alerts.
IDERA Dashboard services requirements
You need to comply with the following requirements to install the IDERA Dashboard:
Microsoft .NET Framework version
4.0 or later
Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies.
The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft SQL Server 2016 Feature Pack
(choose the ENU\x64\SQL_AS_OLEDB.msi installer).
- Windows Server 2008 R2 (86-bit)
- Windows Server 2008 R2 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2016 (64-bit)
- Windows 10 (64-bit)
- Windows 2019 (64-bit)
IDERA Dashboard repository requirements
The IDERA Dashboard supports any of the following versions for hosting its repositories:
- SQL Server 2008 R2 - All Editions
- SQL Server 2012 R2 - All Editions
- SQL Server 2014 - All Editions
- SQL Server 2016 - All Editions
- SQL Server 2017
- SQL Server 2019
The IDERA Dashboard user interface can be accessed via web with the following browsers:
- Internet Explorer IE 10.x+
- Google Chrome
- Mozilla Firefox
- Microsoft Edge
The IDERA Dashboard uses the following ports by default:
- Idera Dashboard Core Services port: 9292
- Idera Dashboard Web Application Service port: 9290
- Idera Dashboard Web Application Monitor port: 9094
- Idera Dashboard Web Application SSL port: 9291