Skip to content

AWS Overview

dbeaver-devops edited this page Oct 10, 2024 · 18 revisions

Table of contents

Overview

CloudBeaver AWS is a multi-user web tool for managing databases, built to work with Amazon Web Services (AWS). It allows teams to collaborate easily and take advantage of AWS infrastructure. This edition is especially useful for teams and organizations using AWS cloud environments. It provides a shared, web-based platform for managing databases, making it easier to collaborate, access, and manage data while using AWS infrastructure.

CloudBeaver AWS key features

The CloudBeaver AWS Edition provides a powerful set of features tailored for database management within the AWS ecosystem. These features focus on seamless integration with AWS services, scalability, security, and collaboration.

  • AWS Services

    • Cloud Explorer: A tool for managing and connecting cloud-hosted databases. Learn more.
    • Amazon S3 support: Manage cloud storage directly from CloudBeaver by integrating with Amazon S3. Learn more.
  • Secure access

    • Access management: CloudBeaver AWS integrates IAM, SAML, OpenID, and various security identity providers to provide secure access. Learn more.
    • User management: Centralize access control with admin tools. Import users directly from identity providers like Google, Okta, and Azure. Learn more.
  • Collaboration

    • Multi-user collaboration: Collaborate in real-time with multiple users, setting custom teams and permissions to maintain data security.
    • Query history: Track and review past queries. Learn more.
  • Data management and SQL development

    • Data filters and views: Utilize flexible filters and interactive views for efficient data handling. Learn more.
    • SQL development tools: Enhance SQL development with autocomplete, syntax highlighting, and script execution capabilities. Learn more.
  • Data import/export

    • Data export: Export data to a variety of formats, including CSV, Excel, and more. Learn more.
    • Data import: Import data from files directly into your database. Learn more.
  • Data Visualization

    • Entity relationship diagrams: Visualize database schemas through entity-relationship diagrams. Learn more.
  • Query development

    • AI assistant in SQL Editor: Integrates an AI assistant to offer guidance and automation within the SQL Editor. Learn more.
    • Search in query history: Enables searching through previous queries for easier management and reuse. Learn more
    • Visual query builder: Provides a graphical interface to construct SQL queries without writing code. Learn more.

Integrated database drivers

CloudBeaver AWS has a comprehensive set of JDBC drivers, offering connectivity to various databases without needing separate downloads and configurations.

Supported databases

The CloudBeaver AWS provides support for a wide range of databases. For a full list of supported databases, refer to Supported databases.

Subscription and licensing

CloudBeaver AWS is available for subscription through the AWS Marketplace. The subscription price depends on the instance size you choose. A bigger instance allows more users to work with the application at the same time.

You get a one-month free trial with access to all CloudBeaver features. After the trial, billing is managed based on the AWS pricing plan for the chosen instance size. You don’t need an extra license, as everything is handled through the AWS Marketplace subscription.

In rare cases, CloudBeaver AWS may request a license if access to the EC2 metadata service is restricted. This is often due to enforced IMDSv2 policies by AWS. Since CloudBeaver runs inside a Docker container with a different network interface, it might be unable to communicate with the EC2 instance metadata. Refer to the Troubleshooting section for guidance on resolving this issue.

Initial setup

After subscribing, navigate to http://<EC2_IP>/ in your browser, where <EC2_IP> is the public IP of your EC2 instance. This will open the initial CloudBeaver configuration wizard, which guides you through the setup process.

For more information on initial configuration, see Server configuration wizard.

CloudBeaver AWS updates

CloudBeaver AWS runs inside a Docker container on your EC2 instance. To update it manually, connect to your EC2 instance via SSH or the instance console, and pull the desired Docker image.

To update CloudBeaver AWS:

  1. Access your EC2 instance via SSH.
  2. Once connected, stop the running CloudBeaver container, pull the latest Docker image, remove the old container, and start the updated version.

Refer to the following documentation for additional guidance:

Support

For technical support with CloudBeaver AWS, you will need to submit a ticket through the DBeaver customer portal on dbeaver.com. When creating a support request, ensure to include your AWS Agreement ID, which is necessary for verifying your subscription.

You can locate your Agreement ID by going to AWS Marketplace > Manage Subscriptions and selecting CloudBeaver AWS. This ID is essential for the CloudBeaver support team to handle your request properly.

Tip: If you need assistance on how to access the Manage Subscriptions section, refer to the official AWS documentation.

Once you have your Agreement ID, log into your account on the DBeaver website, navigate to Profile -> Tickets, and create a new support ticket. Be sure to include all relevant details about the issue to allow the support team to assist you effectively.

Troubleshooting

CloudBeaver AWS installations from the AWS Marketplace may prompt for a license due to issues with EC2 metadata service availability. This can happen when AWS policies enforce the use of IMDSv2 and restrict access to IMDSv1.

Since CloudBeaver runs inside a Docker container, it operates with a different IP address, which prevents it from connecting to the EC2 metadata service using IMDSv2. As a result, CloudBeaver cannot verify that it was launched through a Marketplace installation.

Solution: To resolve this, ensure your Docker container is run with the --network host option, which allows CloudBeaver to access the EC2 metadata service by sharing the host's IP address.

CloudBeaver Documentation

User Guide

Installation

Configuration

CloudBeaver AWS

CloudBeaver Enterprise Edition

Deployment

Clone this wiki locally