Skip to main content

Content Parameters for an EA4IT model

Navigate to Models > [Model name] > Content Parameters.

Here you can configure various content parameters for the EA4IT model (real-time model).

General Settings

Setting

Description

Log level

The log level determines the activities that are logged to file. The default level is Info. The following levels are available:

  • Off: No activities are logged.

  • Error: Logs critical errors only, when the system is in distress. Examples of distress are not being able to connect to the database, not being able to execute an angle, etc.

  • Warning: Logs unexpected technical events, such as a broken and restored database connection.

  • Info: Logs all basic user interaction, like new queries, change of settings, etc.

  • Debug: Logs all available details. This includes Web API requests and responses.

Max size of enumerated sets

Specifies the max number of possible values for a lookup (set) field. When a lookup-type-field has more rows in the lookup table than the number specified here, it will be represented as a regular string field and the lookup functionality will not be enabled.

Caution:

Setting this number too high will negatively impact the performance of the application.

The default value is 10,000.

Database Manager

Setting

Description

DBMS

Select one of the following supported DBMS types:

  • SAP HANA

    SAP HANA versions 1 and 2 are supported. Keep in mind that you will always need to install driver version 2.0.74.0 64-bit.

  • Microsoft SQL Server

    MS SQL versions 2012, 2014 and 2016 are supported. Other versions might work but are not formally supported.

  • Redshift

    Redshift 64-bit ODBC driver version 1.4.27 is supported. Other versions might work but are not formally supported.

Connection String

The connection details in order to connect to the DBMS. Please check the Installation Manual for requirements and/or the documentation from the DBMS vendor for full details.

  • For SAP HANA: Server=[Host]:30015;Current Schema="[Schema]";UserName=[UserName];Password=[Password];Pooling=true;Max Pool Size=100;Min Pool Size=5

    If an SAP HANA database is encrypted, the following addition to the connection string is required:

    ;Encrypt=true;sslValidateCertificate=false

  • For MS SQL: Server=[Host];Database=[Database];User Id=[UserName];Password=[Password];MultipleActiveResultSets=true

  • For Redshift: Driver={Amazon Redshift (x64)};Server=[Host];Database=[Database];UID=[UserName];PWD=[Password];Port=[Port];Pooling=true;Max Pool Size=1024;Min Pool Size=5

  • For MYSQL: Server=[Host];Port=[Port];Database=[Database];User Id=[UserName];Password=[Password]

  • For NPGSQL: Server=[Host];Port=[Port];User Id=[UserName];Password=[Password]

An encrypted connection requires DMBS specific actions. Please check the documentation from the DBMS vendor.

Max query size

The maximum SQL query size in bytes.

Query statements larger than the default value of 10485760 (10MB) will be rejected by the Real-time Model Server. The default value leaves plenty of room for very complex SQL queries.

Query Manager

Setting

Description

Maximum concurrent running queries

The maximum number of queries that are allowed to run at the same time on the DBMS. The default value is 1000. Use a smaller number to limit the load on the DMBS. When this threshold is met, the most recent queries will wait until some older queries are finished.

Maximum query preparation queue size

The size of the first internal waiting queue in the Real-time Model Server. The default value is 1000 queries. There is no need to lower this value. Use a larger value when users experience error messages that mention the preparation queue.

Maximum query execution queue size

The size of the second internal waiting queue in the Real-time Model Server. The default value is 1000 queries. There is no need to lower this value. Use a larger value when users experience error messages that mention the execution queue.

Default paging size

The default number of rows that is fetched when no page size is specified by the Application Server. You can leave this at its default value of 30.

Sorting Limit

This setting is used to limit the number of result rows that can be sorted by the Model Server, to avoid slowdowns.

Enter 0 to disable the limitation. The default sorting limit is 1000000.

Authorization Manager

Setting

Description

Clear expired profile interval in minutes

If an authorization profile is not used for the configured amount of time, in minutes, then a background task in the Real-time Model Server will remove the profile. The Application Server will take care of re-creating the profile when needed. This setting will not impact users.

This setting enables a basic cleanup of the system which is necessary to provide a 24/7 service. You can enter any value between 1 minute and 24 hours. We recommend you to use the default value of 30 minutes.

Was this article helpful?

We're sorry to hear that.