Synchronize DB Resources in AWS
Overview
QueryPie supports integration with AWS for database registration and management. You can synchronize resources from AWS and register them as managed databases in QueryPie. Additionally, you can assign access permissions to users and groups and configure policies for the synchronized databases.
Registering AWS Integration in QueryPie
Navigate to the Administrator > Databases > Cloud Providers menu.
Click the
Create Provider
button in the upper right corner.Name: Enter a name to distinguish the provider.
Cloud Provider: Select Amazon Web Services.
Region: Choose the region where the resources to be synchronized are located.
Credential: Enter the credentials required for synchronization.
Refer to the Setting Up Credential Types section below for more details.
Database Type Filter: Select the resources to be synchronized.
Replication Frequency: Choose the synchronization method:
Manual: Synchronize only when triggered manually.
Scheduling: Synchronize on a regular schedule using Cron Expressions.
Click
Save
to register the Cloud Provider.
Setting Up Credential Types
Default Credentials (Instance Profile) : If the QueryPie server is installed on the same AWS account, you can sync resources within the same AWS environment by assigning policies to the IAM role of the EC2 instance where QueryPie is installed. Assign the appropriate policy based on the resources needed.
Cross Account Role : This method allows synchronization of resources from a different AWS account by creating an IAM role. Follow the on-screen steps to generate the necessary permissions and assign policies. (To use this credential, set the AWS account ID where QueryPie is installed in the AWS_ACCOUNT_ID environment variable.)
Access Key : This method allows only manual synchronization. After saving, you can click the
Synchronize
button on the Provider details screen, enter the AWS account's Access Key, and synchronize the resources once.
Required Policies for Database Resource Synchronization:
RDS : AmazonRDSReadOnlyAccess
DynamoDB : AmazonDynamoDBFullAccess
Redshift : AmazonRedshiftReadOnlyAccess
Athena : AmazonAthenaFullAccess, AmazonS3DFullAccess
Redis : AmazonElastiCacheFullAccess
Synchronizing and Managing AWS Cloud Providers
Navigate to the Administrator > Databases > Cloud Providers menu.
Click on the registered Cloud Provider to open the details screen.
Click the
Synchronize
button in the upper right corner to sync resources from AWS.You can monitor synchronization progress in the Synchronization Log or view the history under Administrator > General > Systems > Jobs.
Once a Cloud Provider is registered, certain provider details cannot be modified:
Name: Changeable
Cloud Provider: Not changeable
Region: Not changeable
Credential: Not changeable
Role ARN: Not changeable
Database Type Filter: Changeable
Replication Frequency: Changeable
Supported Resources for Synchronization
Amazon RDS (MySQL, MariaDB, PostgreSQL, SQL Server, Oracle)
DynamoDB,
Redshift
DocumentDB
Athena
Redis (ElastiCache)