Integrity Ultra

Targets complex MS Access applications that are critical to the efficient functioning of the business and/or support regulated processes subject to Sarbanes-Oxley, MHRA/FDA and the like.

Integrity Ultra meets the strictest audit and regulatory requirements while still allowing business users the flexibility they currently enjoy. Integrity Ultra requires no specialist skills, other than Access, to implement. It reduces staff workload by automating the import, processing and export of data. It allows for data validation and conversion on import and full traceability of numbers, even when they are summarized. Unauthorized users can not gain access. All changes to data are logged. Lowest level transactions are traceable no matter how many times they were summarized. Each step of every process is logged to aid process understanding and documentation. Information is logged for every rule showing the number of records selected and the number changed.

 
Benefits
  • Reduces staff workload by automating import, processing and export of data
  • Requires no specialist skills, other than Access, to implement
  • Imports and exports a variety of file formats
  • Allows for data validation and conversion on import
  • Import and export definition is point and click
  • Allows for full traceability of numbers, even when they are summarized
  • Uses NT/domain security as well as Access security
How It Works - Two Easy Steps
  1. Select the database to be converted, or create new database.
  2. Import database schema and data, if desired.
  3. Run query conversion tool to convert queries to Integrity rules.
  4. Define import(s) by point and click
  5. Define export(s) by point and click.
  6. Define process sequence and dependencies.
  7. Relate rules to processes.
  8. Create process forms.
  9. Define access rights by point and click.
  10. Click "Create".

The target database is now ready to test.

Results
  • Users can only gain access to forms and functions in which they've been authorized.
  • Unauthorized users cannot gain access.
  • All changes to imports, exports, forms, functions, rules, schema and data are logged.
  • Lowest level transactions are traceable no matter how many times they are summarized.
  • Summary numbers are traceable back to their lowest level transactions.
  • Imports and exports run unattended at whatever time or frequency is defined.
  • Each step of every process is logged to aid process understanding and documentation.
  • Information is logged for every rule showing the number of records selected and the number changed.
Download Discover