This example illustrates how a connection is established from JetBrains DataGrip to an Invantive UniversalSQL database on Invantive Cloud. Invantive UniversalSQL Server has been tested with JetBrains DataGrip 2026.1.2. ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud. - The IP address from which Microsoft SQL Server Management Studio connects is whitelisted. ## Login The SQL Server compatible server name is entered into the SQL Server login window, together with the Invantive Cloud credentials. Encryption is activated, since Invantive Cloud uses Invantive UniversalSQL Server with a certificate: ![[20260422-datagrip-log-on.png]] DataGrip is based on JDBC; the JDBC connection string used is: ``` jdbc:sqlserver://invantive-dummy.database.invantive.com:1433;database=dmy ``` ## Simple Query The table `Projects` in the data container `dmy` (Sample database) can be queried using standard Invantive UniversalSQL syntax: ![[20260422-datagrip-simple-query.png]] ## Non-SQL Server Syntax The use of the pipe symbols instead of `concat` illustrates that all Invantive UniversalSQL syntax is available, not only Microsoft SQL Server compatible elements: ![[20260422-datagrip-concat-query.png]] ## System Databases The system databases provide access to the service providers, such as `DataDictionary`: ![[20260422-datagrip-data-dictionary-query.png]] ## Limitations As of release 26.0, the following are known limitations when used with JetBrains DataGrip: - No elements in Database Explorer (issue 6587).