Additional informations

For this we refer to the Microsoft documentation:

If you have installed an MS SQL Server with a default sort that is not Case Insensitive, you must set the collection to „SQL_Latin1_General_CP1_CI_AS" when you create the database:

Figure 18. SQL CaseSensitive

An Identity Provider is required to use Active Directory link via SAML 2.0. For example, a possible Identity Provider could be AD FS (Active Directory Federation Services)

To avoid performance bottlenecks on SQL Server side, the AutoGrowth settings of the database should be set to higher values. This improves especially import tasks. This value can be also set in the Web.config.

Figure 19. SQL DB Size

The performance of database queries in Celonis Process Management can be improved on SQL Server side by rebuilding the indices of each table in a database frequently, e.g. nightly after creation of the database backup. Until version 5.9 it's also recommended to rebuild these indices after larger import tasks (500 MB) once a backup was created before.