PA Configuration database table
QPR ProcessAnalyzer database has a configuration table PA_Configuration containing settings listed in the tables below. You need SQL Server Management Studio to edit the settings in the configuration table. QPR ProcessAnalyzer Server needs to be restarted (e.g. IIS application pool recycled) for the changes to take effect.
Name | Default value | Description |
---|---|---|
SessionIdleTimeout | 3600 | Idle user session expiration timeout in seconds. User session expires if the session hasn't been used after this amount of time. This time should be set same as QPR UI session expiration timeout. |
SessionMaximumDuration | 86400 | Maximum duration for a user session in seconds. Even if a session is used so that the SessionIdleTimeout is not reached, the session is expired after this amount of time. |
SandboxDatabaseConnectionString | Connection string to scripting sandbox database (ETL). If not defined, ETL scripts cannot be run. Connection string for the scripting sandbox database is similar to the QPR ProcessAnalyzer database connection string. | |
StartupModelLoadingMaxParallelism | 2 | Maximum number of QPR ProcessAnalyzer models that are loaded into memory simultaneously by the Automatic Loading on Server Startup. If there are more models to be loaded on the server startup than this setting, loading for the rest of the models is started one by one when previous model loadings are completed. If this setting is not defined, 2 is used as a default value.
Loading more models at the same time will speed up the whole model loading process, but on the other hand, it causes more load on the system, which affects the system responsiveness for users. Model loading consists of (1) transferring data from the datasource to QPR ProcessAnalyzer and (2) loaded data preprocessing into a model. The former uses mainly network bandwidth (if datasource is in a different server) and the latter uses mainly processor capacity in the QPR ProcessAnalyzer server. This setting affects only the model loading during the server startup and it doesn't restrict models loadings initiated by users. |
AllowNonTemporaryETLTargetTable | false | Defined whether ETL scripts are allowed to create global temporary database tables (tables starting with ##). |
DeleteModelsInRecycleBinOnStartup | 0 | When set to 1, deleted QPR ProcessAnalyzer models in the recycle bin are permanently deleted when restarting the QPR ProcessAnalyzer Server. After restarting, the DeleteModelsInRecycleBinOnStartup is automatically set back to 0, so the recycle bin is not emptied every time the server is started. |
DatabaseBulkCopyTimeout | 600 | BulkCopyTimeout given for QPR ProcessAnalyzer database SqlBulkCopy operations. |
DatabaseBulkCopyBatchSize | 5000 | BulkCopyBatchSize given for QPR ProcessAnalyzer database SqlBulkCopy operations. |
SandboxDatabaseBulkCopyTimeout | 600 | BulkCopyTimeout given for sandbox SqlBulkCopy operations. |
SandboxDatabaseBulkCopyBatchSize | 5000 | BulkCopyBatchSize given for sandbox SqlBulkCopy operations. |
DatabaseAvailabilityMode | 0 |
One of the following options:
|
SAML 2.0 Federated Authentication Settings
Name | Description |
---|---|
SamlMetadataUrl | The metadata URL of the identity provider. Check that the metadata can be opened using the configured link. The metadata is an XML document, so it should start <?xml version="1.0" encoding="UTF-8"?> followed by an EntityDescriptor tag. The metadata URL might look something like https://your.federated.identity.provider.com/saml/metadata. |
SamlConsumerUrl | Url that the identity provider uses when redirecting back to QPR ProcessAnalyzer. Use url with following form: <Location of your QPR ProcessAnalyzer installation>/EnticeServices/rest/authenticate/saml, e.g. http://SERVERNAME/EnticeServices/rest/authenticate/saml. This setting is mandatory for the federated authentication to work. |
SamlUserIdAttribute | The name of the SAML attribute in the assertion that will be used as the user's login name. If this field is not given or is empty, the saml:Assertion > saml:Subject > saml:NameID attribute is used in the assertion. If this field is given, one of the saml:Assertion > saml:AttributeStatement > saml:Attribute elements in the assertion is used (the Name attribute in the saml:Attribute element is used for matching). Please note that the first mentioned saml:NameID element is different than the usual SAML attributes that are defined using saml:Attribute elements. |
LDAP Authentication Settings
Name | Description |
---|---|
AuthenticationMethod | Authentication related settings, see detailed information in LDAP/AD Authentication. |
LDAPConnectionString | |
LDAPUserFilter | |
LDAPUserSearchBase | |
LDAPUserIdAttributeName | |
LDAPServerUserName | |
LDAPServerPassword |
Readonly Information
Name | Description |
---|---|
DatabaseId | Unique identifier for the database. Unless the database has been copied from another database, there shouldn't be two databases with the same database id. |
DatabaseVersion | Database schema version. It will be updated automatically when a QPR ProcessAnalyzer Server of a newer version connects to the database and performs migration for the database. |
InitializationScriptDatabaseVersion | Database version that was when the database was initialized when the software was installed. Do not change this setting. |
MinimumDatabaseVersion | Minimum allowed database version for QPR ProcessAnalyzer Server connecting to the database. This is a legacy setting and it should not be used. |