SQL Compliance Manager

Improve Any SQL Server Audit

logo idera

KJØP VIDEO

SQL Compliance Manager er en omfattende revisjonsløsning som bruker policy-baserte algoritmer for å holde oversikten over endringer i SQL Server-objects og data. SQL Compliance Manager gir deg detaljert synlighet for å fastslå hvem som gjorde "hva", "når", "hvor" og "hvordan". uansett om hendelsen er initiert av brukere med rettigheter eller hackere. SQL Compliance Manager hjelper også til med å sikre overenstemmelse med lover og krav til datasikkerhet, slik som SOX, PCI, FERPA og HIPAA.

SQL Compliance Manager går ut over tradisjonelle revisjonsmetoder gjennom å gi sanntidskontroll, varslinger og gjennomgang av alle datatilkoblinger, oppdateringer, skjemaendringer og modifikasjonsregler for SQL Server.

 

Generellt

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.
 

Detaljer

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.

 

Tekniske Spesifikasjoner

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

Agent
-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

 

Sammenlikning

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


Lisensiering

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.