Store cache on your MS 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 Microsoft 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.

Some important info for the Microsoft SQL database setup:

• You must create the database. Note that sapio365 does not create the database. This usually requires some access level to the SQL server we should not have to handle. We let the customer do this, so he can set the proper security access on the database.

• The user set in the database must have the ability to create and delete tables, in addition to a full access to the records. Usually, our customers create a dedicated user in the database for sapio365.

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 a shared cache on a specific session

The steps are shown in the image that follows.

1. Go to the ‘back’ of the sapio365 main window.

2. Go to recent sessions and select a session (or more) for which you wish to set a shared cache on.

3. Click on the top-right button “Cache Options”.

4. Toggle to ‘Use SQL Server’ in the dialog to ‘Yes’'.

5. Fill in the settings.

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

If there is an error, check your credentials and the information you entered.

If the error persists, you can check the connection directly instead of through sapio365. There may be an issue with how how your database is setup.

Purge Database Option

You can delete an existing table to recreate a new one with this option (shown as 7 in image above).

Sometimes tables with large volumes of data may get corrupted, and you may want to recreate a new table.