This example illustrates how a connection is established from Sumatra 2025 to an Invantive UniversalSQL database on Invantive Cloud. Invantive UniversalSQL Server has been tested with Sumatra 2025 version 5.4.1169.0. ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud. - The IP address from which Sumatra 2025 connects is whitelisted. ## Login First step is to select the "Add database" button on the Sumatra 2025 WebManager: ![[20260424-uss-sumatra-log-on.png]] And after selecting "Create new credentials", the SQL Server compatible server name can be entered into the New credential window, together with the Invantive Cloud credentials: ![[20260422-uss-sumatra-log-on-credentials.png]] Use the credentials to create a database: ![[20260422-uss-sumatra-log-on-database.png]] And confirm that it is SQL Server: ![[20260422-uss-sumatra-log-on-sql-server.png]] Select a database schema and select "Finish": ![[20260422-uss-sumatra-log-on-schema-selection.png]] ## Tables and Views The table selector uses Microsoft SQL Server-specific statements that are mapped onto Invantive UniversalSQL operations to display the list of available tables and views: ![[20260422-uss-sumatra-tables.png]] ## Simple Query The table `GLAccountsBulk` in the data container `eol` (Exact Online database) can be queried using Sumatra Builder: ![[20260422-uss-sumatra-simple-query.png]] ## System Databases The system databases provide access to the service providers, such as `DataDictionary`. Here the data is queried from the Sumatra Data Model Editor: ![[20260422-uss-sumatra-data-dictionary-query.png]] ## Limitations As of release 26.0, the following are known limitations when used with Sumatra 2025: - There are no known limitations.