This example illustrates how a connection is established from Azure Data Studio to an Invantive UniversalSQL database on Invantive Cloud. Invantive UniversalSQL Server has been tested with Azure Data Studio 1.47.1. Please note that Azure Data Studio has been retired as of February 28, 2026. ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud. - The IP address from which Azure Data 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-ads-log-on.png]] ## Tables The Server list uses Microsoft SQL Server-specific statements that are mapped onto Invantive UniversalSQL operations to display the list of available tables: ![[20260422-ads-tables.png]] ## Views Similarly, the Server list displays the list of available views: ![[20260422-ads-views.png]] ## Stored Logic Similarly, the Server list displays the list of available stored logic such as the procedure `get_partitions` from the package `dcr_metadata`: ![[20260422-ads-stored-procedures.png]] ## Simple Query The table `Projects` in the data container `dmy` (Sample database) can be queried using standard Invantive UniversalSQL syntax: ![[20260422-ads-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-ads-concat-query.png]] ## System Databases The system databases provide access to the service providers, such as `DataDictionary`: ![[20260422-ads-data-dictionary-query.png]] ## Limitations As of release 26.0, the following are known limitations when used with Azure Data Studio: - No columns list in Server list for views (no issue registered).