Easily audit your data at record level, comply with SOX or any other

regulation... and avoid frauds!

Tango/04 Data Monitor for SQL Server is the new solution for auditing changes and ensure the integrity of the corporate data stored in Microsoft SQL Server tables, using a highly intuitive and easy to use graphic interface.

Sarbanes-Oxley, Basel II, 21 CFR Part 11, HIPAA.. Every day there are more regulations and laws pushing companies to guarantee the accuracy, integrity, and confidentiality of their data. These standards require auditing all changes to records in sensitive or specially protected tables, and maintaining an electronic record of these changes. In banking and insurance companies, for example, this audit trail functionality is also required to prevent internal fraud.

Tango/04 Data Monitor for SQL Server includes security utilities, visualization tools and an user friendly Reporting System.

With Visual Manager, the graphical interface of Tango/04 Data Monitor for SQL Server, it is very easy to configure auditing of changes to specific records on Microsoft SQL Server databases. Visual Manager manages and configures the objects to audit in a simple and intuitive manner.

Record Level Auditing in Real Time

Tango/04 Data Monitor for SQL Server helps you satisfy any regulatory or auditing requirements on data stored on Microsoft SQL Server database tables. It detects in real time attempts to illicitly or incorrectly access your data, in order to avoid fraud and accidental errors. Designed according to the best practices for data protection and auditing, Tango/04 Data Monitor for SQL Server meets the specifications of widely accepted international security standards, such as ISO-17799, CobiT or ITIL.

Who did what when?

Take absolute control of the use of your critical data without programming, without any changes to your applications, and without consuming excessive resources. Tango/04 Data Monitor for SQL Server is the most efficient and comprehensive data auditing solution for Microsoft SQL Server databases, offering the best ROI in the market today.

Benefits

• Prevent fraud
  
• Fulfill internal and external auditing requirements
  
• Get alerted in real time of any threat or suspicious activity affecting critical data
  
• Maintain a record of the changes made to any database record by an existing application, without modifying the application
  
• Comply with specific Sarbanes-Oxley (SOX) requirements and other international or industry regulations (such as Basel II for financial companies, 21 CFR Part 11 for the food and pharmaceutical industry, HIPAA, etc.)
  
• Perform security controls in different components to guarantee availability of data.
  
• Create advanced reports for rapid detection and resolution of inappropriate or illegal use
  
• Efficiently store changes to sensitive or critical data on secure systems (different from the original system if desired)
  
• Meet international security standards such as ISO 17799, adapt to security management recommendations by ITIL, CobiT and other industry best practices
  
• Count on a record of individual user activity to prove illegal behavior
  
• Dissuade employees from committing improper activities by implementing an advanced data monitoring system

The most complete solution for auditing SQL Server data

Tango/04 Data Monitor for SQL Server audits all insert, delete and update transactions of records in Microsoft SQL Server database tables.

Optionally it is possible to obtain a full audit of all the transactions executed. The auditing of executed transactions requires an additional module, available only for some platforms.

Detailed information for each transaction

Tango/04 Data Monitor for SQL Server can retrieve detailed information of every change, including domain, host name and application from which the transaction was executed, network user and SQL Server user that executed it, date, time and length of the transaction.

Flexible reports in real time or on demand

The most basic report for Tango/04 Data Monitor for SQL Server lists all changes in chronological order. It is easy to see the details of each transaction and the before and after data of each field.

Tango/04 Data Monitor for SQL Server can generate reports instantly and interactively, or schedule their creation at a later point in time. The Reporting System displays reports on-screen and exports them in many formats, including:

• Acrobat (PDF)
  
• Text (TXT)
  
• Comma Separated Values (CSV)
  
• Excel (XLS)
  
• dBase IV (DBF)
  
• Word (DOC, RTF)
  
• HTML
  
• XML
  
• And more

Reports can be sent automatically by e-mail, or fed to a corporate Web portal or a restricted area on the Intranet.

Custom selection of audited fields

The reports can extract information at field level. You can concentrate on the most critical events, audit only sensitive fields and records, and filter out less relevant information at the source.

Customized subreports

Each authorized user can easily create customized subreports based on the predefined reports included in the Reporting System. For example, they can insert logos, modify the appearance of lists, and use an intuitive graphical interface to create combinations of parameters and quickly respond to questions like:

• Who made changes to the file SALARIES accessing the file as user SMITH?
  
• Who modified INVOICES between 00:00 and 05:00?
  
• What changes (to any table) did user JONES make in the last month?
  
• What were all the changes made to the sensitive field DISCOUNTS in the last quarter?
  
• What changes were made to CUSTOMERS not using the authorized program?
  
• What changes were made via DFU?
  
• How many changes were made to the table PAYCHECK in the last year?
  
• What users that do not belong to the HR user group modified the table SALARIES?

Before and after image

If desired, the before and after values can be shown for every changed field. It is also possible to define the order in which the fields appear or to exclude one or more fields altogether.

Quick to start and easy to use

Tango/04 Data Monitor for SQL Server was designed to be put into production with minimal effort on the user's part and with a very low operating cost.

Obscuring confidential information

The most sensitive data can be monitored openly or "obscured". For example, it is possible to hide data such as an account balance, credit card numbers, phone numbers, and more. This data will appear in reports as ***Restricted***.

Complete integration with VISUAL Message Center

Tango/04 Data Monitor for SQL Server seamlessly integrates with VISUAL Message Center and VISUAL Security Suite, thereby taking full advantage of the power of the SmartConsole in generating early warnings, message escalation and automation of actions.