Store cache on your SQL server

sapio365 creates a local cache for the lists of users, groups and sites for each installation.

An option to centralize the cache is to store it in a SQL database within your network.

Benefits:

• The cache can be updated in one location. This update be scheduled.

• All sapio365 users will always have access to fresh data.

Here’s what you need to do to enable this.

1. Ask your database administrator to create a single database that can be accessed for a specific user. This user must to be able to create tables in the database.

2. Set up the connection in sapio365 for a specific session or directly, or for a delegated RBAC role when setting up credentials.

3. Set SQL Server Protocol (OLEDB or ODBC) in Preferences ->Global.

Note that this requires that everyone access the SQL Server on the same port 1433 (or any other port you choose to use).

The cache is stored by tenant. So the first user on a given tenant who connects to the SQL cache for the first time or after a database purge will re-build the cache (this may take some time). Users who connect afterwards will be able to only do a refresh of the data.

Set on a specific session

1. Select a session and from the right-click menu, ‘Set Cache Options’.

2. Set ‘Use SQL Server’ to True and fill in the settings.

3. You can test the connection by clicking on the Test icon.