Prerequisites for accessing Amazon RDS databases
Before you can connect to an Amazon RDS database using AWS Toolkit for JetBrains, you need to complete the following tasks:
Creating an Amazon RDS DB instance and configuring an authentication method
AWS Toolkit for JetBrains enables you to connect to an Amazon RDS DB instance that's already been created and configured in AWS. A DB instance is an isolated database environment running in the cloud that can contain multiple user-created databases. For information about creating DB instances for the supported database engines, see Getting started with Amazon RDS resources in the Amazon RDS User Guide.
When connecting to a database using AWS Toolkit for JetBrains, users can choose to authenticate using IAM credentials or Secrets Manager. The following table describes key features and information resources for both options:
| Authentication methods | How it works | More information |
|---|---|---|
|
Connect with IAM credentials |
With IAM database authentication, you don't need to store user credentials in the database because authentication is managed externally using AWS Identity and Access Management (IAM) credentials. By default, IAM database authentication is disabled on DB instances. You can enable IAM database authentication (or disable it again) using the AWS Management Console, AWS CLI, or the API. |
|
|
Connect with AWS Secrets Manager |
A database administrator can store credentials for a database as a secret in Secrets Manager. Secrets Manager encrypts and stores the credentials within the secret as the protected secret text. When an application with permissions accesses the database, Secrets Manager decrypts the protected secret text and returns it over a secured channel. The client parses the returned credentials, connection string, and any other required information and then uses that information to access the database. |
|
Working with Amazon RDS databases using DataGrip
After you've connected to an Amazon RDS data source, you can start interacting with it. By using
DataGrip from JetBrains, you can carry out database tasks such as writing SQL, running queries, and
importing/exporting data. Features provided by DataGrip are also available in the database plugin
for a range of JetBrains IDEs. For information about DataGrip, see https://www.jetbrains.com/datagrip/
