> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Integrate Azure Data Studio with Tiger Cloud

> Query and manage your database with a cross-platform data analytics tool

export const PG = 'Postgres';

export const CLOUD_LONG = 'Tiger Cloud';

export const SERVICE_LONG = 'Tiger Cloud service';

export const SELF_LONG = 'self-hosted TimescaleDB';

[Azure Data Studio][azure-data-studio] is an open-source, cross-platform hybrid data analytics tool designed to simplify the data landscape.

This page explains how to integrate Azure Data Studio with {CLOUD_LONG}.

## Prerequisites

To follow the steps on this page:

* Create a target [{SERVICE_LONG}][create-service] with Real-time analytics enabled.<p />

  You need [your connection details][connection-info]. This procedure also
  works for [{SELF_LONG}][enable-timescaledb].

[create-service]: /deploy-and-operate/tiger-cloud/get-started/create-services

[enable-timescaledb]: /deploy-and-operate/self-hosted/install-and-update/install-self-hosted

[connection-info]: /integrations/find-connection-details

* Download and install [Azure Data Studio][ms-azure-data-studio].
* Install the [{PG} extension for Azure Data Studio][postgresql-azure-data-studio].

## Connect to your service with Azure Data Studio

To connect to {CLOUD_LONG}:

1. **Start `Azure Data Studio`**

2. **In the `SERVERS` page, click `New Connection`**

3. **Configure the connection**
   1. Select `PostgreSQL` for `Connection type`.

   2. Configure the server name, database, username, port, and password using your [connection details][connection-info].

   3. Click `Advanced`.

      If you configured your {SERVICE_LONG} to connect using [stricter SSL mode][ssl-mode], set `SSL mode` to the
      configured mode, then type the location of your SSL root CA certificate in `SSL root certificate filename`.

   4. In the `Port` field, type the port number and click `OK`.

4. **Click `Connect`**

You have successfully integrated Azure Data Studio with {CLOUD_LONG}.

[azure-data-studio]: https://azure.microsoft.com/en-us/products/data-studio

[connection-info]: /integrations/find-connection-details

[ms-azure-data-studio]: https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?view=sql-server-ver16#install-azure-data-studio

[postgresql-azure-data-studio]: https://learn.microsoft.com/en-us/azure-data-studio/extensions/postgres-extension?view=sql-server-ver16

[ssl-mode]: /deploy-and-operate/tiger-cloud/secure-access/connect-to-a-service-with-stricter-ssl
