Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Take into account the following behaviours when using the Aggregation profile:

...

The contents of the buttons in the menu bar may change depending on which configuration type has been opened in the currently active tab. The Aggregation profile uses the standard buttons that are visible for all configurations, and these are described in Build View.

Session Tab

In the Session tab you can browse and select a Session UDR Type and configure the Storage selection settings.

...

SettingDescription

Profile

Select a Couchbase profile. This profile is used to access the primary storage for aggregation sessions.

Mirror Profile

Selecting this Couchbase profile is optional. It is used to access a secondary storage, providing read only access for aggregation sessions. Typically, the Mirror Profile is identically configured to a (primary) Profile, that is used by workflows on a different EC Group or other  system system. This is useful to minimize data loss in various failover scenarios. The read only sessions can be retrieved with APL commands. For more information and examples, see Aggregation Functions in the APL Reference Guide.

...

SettingDescription
Profile

Select an SQL profile. This profile is used to access the storage for aggregation sessions.

Note
titleNote!

Currently the SQL storage only supports PostgreSQL and SAP HANA databases.

Storage sharing functionality is currently not supported.


Index Fields

Click the Add button to select the UDR type.

Table SQL Script

This text box will generate the SQL statements for the selected UDRs' table schema and indexes for Id, TxId. The schema will be generated based on the number of UDRs in the UDR Type Mapping table.

Info
titleInfo!

Users will have to copy the SQL script generated in the text box to create the PostgreSQL and SAP HANA tables on their own in the database listed in the Database profile. The Aggregation profile will not automatically create the tables for you.


Note
titleNote!

The following table columns are mandatory when creating the database:

Column NameData Type

Id

VARCHAR(24)

TxId

BIGINT

Deleted

BOOLEAN

Timeout

BIGINT

Session

BYTEA



...