SQL Aggregation Storage

Owned by Jenni Wallin
Last updated: May 26, 2023 by Former user (Deleted)
Case IDInternal IDComponentPackage Name

MZ-37970
MZ-37965

Aggregation
Database Profile

aggregation_8.3.0.0.mzp
sql_aggregation_client_8.3.0.0.mzp
sql_aggregation_storage_8.3.0.0.mzp
docweb_8.3.0.0.mzp

Aggregation will now support storage of aggregation sessions in PostgreSQL and SAP HANA.  The Aggregation sessions storage are verified with PostgreSQL version 14 and SAP HANA version 2.0. 

A Database Profile will be used to establish the JDBC connection to the database. The Aggregation profile is used to generate an SQL table script for you to create a table and indexes for the Aggregation session data in the database of your choice. The Aggregation agent will upload all the sessions per batch into the database table created for the session.


The Aggregation session inspector will also be updated to allow you to access your aggregation sessions from the database.

For further information on the SQL storage see 9.3.4 Aggregation Profile in the Desktop User's Guide.
For further information on the session inspector see 9.2.8 Aggregation Session Inspector in the Desktop User's Guide.