Who is this article for?

Administrators considering implementation of Ideagen Quality Management 7.7.1.

No elevated permissions are required.

Ideagen Quality Management 7.7 is a product update that includes several feature enhancements and fixes.

1. Features

Migration from MSSQL to Postgres Database

Starting with this version, we offer the option to switch to PostgreSQL as the database, replacing the current use of Microsoft SQL Server (MSSQL). Migrating from MSSQL to PostgreSQL involves transferring databases, tables, data, stored procedures, and other schema objects to PostgreSQL.

The key benefits of using PostgreSQL include:

• Cross-platform support across various operating systems
• Greater flexibility and extensibility for customisation
• Enhanced support for modern data types
• Vibrant and active open-source community

These advantages make PostgreSQL a strong choice for a flexible and scalable, and cost-effective relational database management system.

Switching to a PostgreSQL database will require storing attachment files in AWS S3.

Migration from blob storage to AWS S3

Currently, the system stores blob data (such as documents, images, and videos) in the application database. Starting from this version, a new option is available to store blob attachments in AWS S3 instead.

Using AWS S3 (Simple Storage Service) to store blob data offers several advantages over storing these objects directly in an application database (e.g. MSSQL, PostgreSQL).

Some key benefits of using AWS S3 for blob storage include:

• Scalability to handle large volumes of data
• Optimised performance for fast file uploads and downloads
• Clear separation by using dedicated storage for blobs
• High durability and availability with features like replication and encryption
• Simplified backup and disaster recovery
• Global accessibility and easy integration with other AWS services

In contrast, storing blobs in an application database can lead to performance bottlenecks, higher storage costs, and increased complexity in backup, security, and management.

2. Known issues

There is a known issue preventing the deletion of newly created Draft/Active Document records in the Postgres database.

This is scheduled to be fixed in the next release.

3. Fixes

Further reading

• Ideagen Quality Management Release Notes list
• Confirming what version of Ideagen Quality Management (Professional) you are using