Cloud explorer
Overview
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 Azure.
With Cloud Explorer, you can set up your cloud access once and then easily 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 use your cloud account to access your cloud databases. Before you start using Cloud Explorer, you need to set up your cloud provider access. This setup includes access credentials, availability zones for database search, and other cloud-specific settings.
Supported Databases
The Cloud Explorer allows you to easily connect with and manage various databases. Here is the list of databases it supports:
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 Azure | Microsoft SQL Server |
PostgreSQL | |
MySQL | |
CosmosDB (MongoDB) | |
CosmosDB (Cassandra) |
Cloud configuration
To start configuring, click the Cloud Explorer button
in the Toolbar.
First-time setup
If this is your first time, the Create Cloud Configuration dialog opens automatically. Use it to:
- Enter your access credentials.
- Specify availability zones for database search.
- Adjust cloud-specific settings.
Once completed, Cloud Explorer will display your cloud databases.
Note
Cloud configuration steps differ for each cloud provider.
Add a new configuration
To create an additional setup, click the New button
in the Cloud Explorer dialog.
Amazon Web Services
Name | Description | Additional article |
---|---|---|
Default Credentials | Allows AWS to determine credentials using the standard credential providers. | AWS Default credentials |
AWS Profile | Allows you to choose which credentials profile you want to use. | AWS Profile |
Access/Secret Key | Allows you to choose which credentials profile you want to use. If you have an AWS Secret set up, enter it in the Connection settings. | AWS Access/Secret Key |
Single Sign-On (SSO) | Allows access to AWS resources without explicitly specifying user credentials in Team Edition connections configuration. | AWS SSO guide |
Tip
For more details, see how to connect an AWS database using Cloud Explorer. About permissions, read AWS managed policies article.
Google Cloud Platform
Name | Description | Additional article |
---|---|---|
Default Credentials | Allows GCP to determine credentials using the standard credential providers. | GCP Default credentials |
Web browser or SSO | Allows you to authorize your connection through your Google account without needing a service or user-based key file. | GCP SSO |
Access key file | Allows you to provide the path to your service or user credentials files. | GCP Access key |
Tip
For more details, see how to connect Google database using Cloud Explorer.
Microsoft Azure
There are several environment variables available for Microsoft Entra ID. For detailed information on Entra ID authentication, see Authentication Microsoft Entra ID.
Tip
For more details, see how to connect Azure database using Cloud Explorer.
Configuring SSH Tunnels
Team Edition supports SSH tunnel connections for enhanced security when accessing cloud databases. Detailed instructions for setting up SSH tunnels in Team Edition are available in the SSH Tunnel Configuration article.
Explorer
Once you've configured your cloud provider access, open the Cloud Explorer dialog and add database
connections. In the top drop-down of the explorer dialog, you can select the active cloud configuration or click
Edit button to change the cloud configuration.
You can see cloud databases in the center of the dialog in a hierarchical view. All databases are grouped by database/service type. When you expand one of the top elements, Team Edition will search cloud databases in configured availability zones/regions.
If you have a large number of databases in your cloud, you can search or filter them using filter text above the cloud navigator.
You can drag-and-drop cloud databases directly to database navigator view
or projects view. You can also add any number of databases to your project directly from the Cloud
Explorer. To do this, click on the database you want to add. Once selected, click on the Add to Project button
located in the bottom right corner of the
Cloud Explorer dialog, or right-click on the database and select Add to Project from the context menu.
This will add the selected database to your project, making it easier to manage and navigate your databases within specific projects.
Database cloud information
You can access your cloud database configuration directly from the Database Navigator. To do this, right-click on 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.