Cloud Explorer

Cloud Explorer offers deep integration with popular cloud service providers. As of the latest version, it supports Amazon Web Services (AWS), Google Cloud Platform (GCP), and Microsoft Entra ID (Azure).

With Cloud Explorer, you can set up your cloud access once and then browse, connect, and manage your cloud databases. It saves you from manually configuring each database connection, as it reads all database endpoint information directly from the cloud provider.

Authentication is centralized. You can use your cloud account to access your cloud databases. Before you start using Cloud Explorer, you need to set up your identity provider access. This setup includes access credentials, availability zones for database search, and other cloud-specific settings.

Tip

Cloud Explorer supports Pass-Through Authentication - once you log in with your identity provider, no additional credentials are needed to access cloud databases. For more details, see Pass-Through Authentication.

Tip

Use Cloud Storage to manage files and work with .sql scripts in your cloud provider.

Supported databases

The Cloud Explorer allows you to connect with and manage various databases:

Providers	Databases
Amazon Web Services	PostgreSQL
	MySQL
	Oracle
	Amazon Redshift
	Amazon Athena
	Amazon DocumentDB
	Amazon DynamoDB
	Amazon Keyspaces
	Amazon ElastiCache (Redis)
	Amazon Timestream
	Amazon Neptune
Google Cloud Platform	AlloyDB for PostgreSQL
	Microsoft SQL Server
	PostgreSQL
	MySQL
	Spanner
	Firestore
	BigQuery
	Bigtable
Microsoft Entra ID (Azure)	Microsoft SQL Server
	PostgreSQL
	MySQL
	Azure Cosmos DB for MongoDB
	Azure Cosmos DB for Cassandra
	Azure Cosmos DB for NoSQL

Cloud configuration

1. As an administrator, go to Settings -> Administration -> Server Configuration.
2. In the Configuration section, enable the cloud providers you need: Cloud (AWS), Cloud (Azure), or Cloud (Google).
3. Save the changes.

Amazon Web Services

To use Cloud Explorer with AWS, make sure:

• An AWS-compatible Identity Provider is configured. For available options, see Authentication Methods.
• The AWS regions where your databases are located are selected AWS Settings.

Tip

Cloud Explorer only discovers databases in the regions you've enabled. If a database isn't showing up, check your region list in AWS Settings.

Google Cloud Platform

To use Cloud Explorer with GCP, configure Google as an Identity Provider.

Info

For setup instructions, see Google authentication.

Microsoft Azure

To use Cloud Explorer with Azure, configure Microsoft Entra ID as an Identity Provider.

Info

For setup instructions, see Microsoft Entra ID authentication.

Cloud Explorer

Once you have configured your identity provider, open the Cloud Explorer window to add database connections to your Database Navigator.

1. Navigate to Connection -> Cloud Explorer.

   

2. In the center of the dialog, you will see cloud databases displayed in a hierarchical view. All databases are grouped by database/service type. When you expand one of the top elements, Team Edition will search for cloud databases in the configured availability zones/regions.

   

3. Select the cloud service provider. Depending on the type of authentication configured, you may need to log in using the appropriate identity provider in the opened window.

   

4. After authentication, select the database you want to add.

   

   Tip

   If you have a large number of databases in your cloud, you can search for them using the search bar located above the Cloud Explorer.

5. Click on the Create button located in the bottom right corner of the Cloud Explorer dialog. Your database will then appear in the Database Navigator.

Database cloud information

You can access your cloud database configuration directly from the Database Navigator. To do this, click on the menu button next to the database you are interested in and select Edit Connection. This action opens a special tab in the connection settings dialog. The information displayed in this tab is specific to the cloud and database type of the selected database.