2.4.3 Setting up a SQL Database

By default, Thinfinity® Workspace utilizes a shared local database powered by Absolute Database, a Delphi-based engine known for its compact size, high performance, and reliability.

In case you want to work instead with a SQL database, follow the steps presented below.

1

Install SQL Server

Download the appropriate driver for the installed SQL version from Microsoft's website. The driver must then be added to ODBC Data Sources (either 64-bit or 32-bit, depending on the system).

Starting with Thinfinity Workspace 8.0.X, the product will be compatible with SQL ODBC Driver 18.

We recommend using ODBC Driver 18 due to the following improvements:

• Security: Implements a stricter security approach. The most notable change is that encryption is now required by default for all connections.

• TLS Version Compatibility: Provides enhanced support for TLS (Transport Layer Security) versions, including newer versions such as TLS 1.2 and TLS 1.3.

• Connection String Control: Requires greater control and specification in connection strings, particularly with the TrustServerCertificate parameter.

• SQL Server Feature Compatibility: Both drivers support the same SQL Server versions (including SQL Server 2022), but ODBC Driver 18 has been optimized for better performance.

2

Configure Thinfinity Workspace to work with the installed database

Note

When using an external database, Thinfinity Workspace must be installed on the same network as the database.

Open Thinfinity Configuration Manager, and go to the Database tab.

If the database is hosted locally on the same device as Thinfinity Workspace, select the Local database option. Otherwise, click the [+] button and fill out the form with the database IP address, name, username, and password.

Thinfinity Workspace allows you to set a dedicated database for each feature or component of the ecosystem—for example, Access and Authentication Profiles or the Enterprise Logger. For details, see Database Tab.