Invantive UniversalSQL Server can run in one of three possible modes: - Demo mode: pre-defined sample database available to a single demo user. - Local (on-premises) mode: local databases available to a pre-defined list of users. - Invantive Cloud mode: database available on Invantive Cloud to Invantive Cloud user. The mode is set in the [[Invantive UniversalSQL Server/Configuration/Configuration|Configuration]] file. ## Demo Mode In demo mode, Invantive UniversalSQL Server allows connections by the demo user, as defined in [[Demo Configuration]]. The only database available is the Sample database, based on the Dummy provider. Demo mode is typically used to quickly set up a testing ground to experience Invantive UniversalSQL Server before deploying in local (on-premises) mode. Demo mode is limited in terms of security, since authentication is done by a single user, whose credentials are visible in the configuration file. This requires hardening of the deployment platform. ## Local (on-premises) Mode In on-premises mode, Invantive UniversalSQL Server runs within a user controlled environment. Each user as defined in [[Users Configuration]] has access to all databases defined in the [[Local Configuration]]. Local (on-premises) mode is typically chosen when: - the data volume might exceed fair use policies on Invantive Cloud; - the connected platform is only available within the user controlled environment (such as AccountView); - the data confidentiality requires a direct connection from the user controlled environment to the connected platform. Local (on-premises) mode is limited in terms of security, since authentication is done by user credentials, which are visible in the configuration file. Also, each user has access to the same set of databases. This requires hardening of the deployment platform. ## Invantive Cloud Mode In Invantive Cloud mode, Invantive UniversalSQL Server runs as an integrated part of the Invantive Cloud environment (or OEM-variant). Each user must be registered on the Invantive Cloud as defined by the [[Invantive Cloud API Connection Configuration|connection]] to the environment. A user has access to the same databases as on when logged on to Invantive Cloud. Invantive Cloud mode is the choice for most scenarios, unless for instance the criteria of demo mode or local mode apply. Invantive Cloud mode shares the security features with the rest of Invantive Cloud. Users only have access to databases available in their organization, and the authentication details are managed by Invantive Cloud.