Identifier configuration for PostgreSQL connections

With proper configuration, you can now run audit reports against PostgreSQL databases.

Data modeling supports a single standardized audit package across all databases, including PostgreSQL. However, audit sample models use uppercase table and column names, when PostgreSQL handles identifiers in a case-sensitive manner. To successfully run audit reports against PostgreSQL connections, you must go to your data server configuration and set the ibmcognos.identifier.format parameter to lower or nodelimiter value, for example:

ibmcognos.identifier.format=lower
ibmcognos.identifier.format=nodelimiter

With this configuration, the single audit package works across all supported databases.

For more information, see Setting up sample audit reports.