Fast Data Integrity

Data Integrity Checks in a Fraction of the Time

Up to 0 x
Performance Gains

TaiRox Fast Data Integrity is a SQL Server specific utility that performs Sage 300 integrity checking in a fraction of the time taken by the standard Administrative Services function. 

Tests:

AP

Accounts
Payable

AR

Accounts
Receivable

AS

Admin
Services

Extensive checks for valid users have been added

BK

Bank
Options

CP

Canadian Payroll

CS

Common Services

GL

General Ledger

GP

G/L
Subledger Services

IC

Inventory Control

OE

Order
Entry

PO

Purchase Order

TX

Tax
Options

UP

US
Payroll

AP

Accounts
Payable

AR

Accounts
Receivable

AS

Admin
Services

Extensive checks for valid users have been added

BK

Bank
Options

CP

Canadian Payroll

CS

Common Services

GL

General Ledger

GP

G/L
Subledger Services

IC

Inventory Control

OE

Order
Entry

PO

Purchase Order

TX

Tax
Options

UP

US
Payroll

*Some cross-application checking is performed*

Fast Data Integrity

Designed to be run as a Windows Scheduled Task and can check multiple Sage 300 databases in one job. Sage 300 must be installed on the computer.

Fast Data Integrity Console

interactive and will (optionally) delete orphans that it detects. It is not necessary to install Sage 300 on the computer running the Console.

Features and Benefits

Checks data integrity of large databases 100x-1000x faster

Console will delete orphans that are detected

Eliminates noise from error log - old errors that will not be corrected

Helps insure that BI and Crystal reports are accurate