QueryPie Docs

Release Notes

• 9.16.0
• 9.15.0 ~ 9.15.3
• 9.14.0 ~ 9.14.2
• 9.13.0 ~ 9.13.5
• 9.12.0 ~ 9.12.14
• 9.11.0 ~ 9.11.5
• 9.10.0 - 9.10.4
• 9.9.0 - 9.9.8
• 9.8.0 - 9.8.10

QueryPie Overview

• Installation and Maintenance
• Customer Portal
• Overview of the System Architecture

User Management

• SSO Integration
• Add Users Manually
• User Group Management
• User Control

Authentication and Security Settings

• Set Account Lockout Policies And Timeouts
• Set IP Restrictions
• DB Security Settings
• Set Up Server Security
• Secret Store Integration

Access DB & Server via Proxy

• Enable Database Proxy

Workflow

• DB Access Request
• SQL Request
• Export Request
• Server Access Request
• Approval Management
• Set Approval Rules
• Post-Approval
• Approval References
• Resubmit Approval Requests
• Approval Delegation
• Slack DM Notifications
• [Internal Network] Forward Slack DM Workflow Results

Audit Logs and Reports

• Extract and Download Audit Logs

DB Management

• Register Connections Manually
• Create MongoDB Multi-Host Connections
• Set Connection Details and Policies
• Synchronize DB Resources in AWS

DB Access Policies

• Data Masking Policies
• Table/Column Access Restriction Policies
• Sensitive Data Policies
• DB Alert Policies
• MongoDB Data Policies and Rules
• Ledger Table Control Policies

DB Access Control

• Create and Manage Privileges
• Grant and Revoke Access Control

Connect to DB

• Access to DB with Web SQL Editor
• Proxy Access Through Agents

Manage Servers and Server Accounts

• Synchronize Server Resources in AWS
• Synchronize Server Resources in GCP
• Synchronize Server Resources in Azure
• Register Servers Manually
• Manage Servers as a Group
• SSH Key Management
• Server Account Templates

Server Access Policies

• Set Up Server Access Policies
• Server Alert Policies
• Access Control Expiration & Timeout Policies

Server Access Control

• Grant and Revoke Server Access

Connect to Servers

• Connect to Granted Servers
• Web Terminal
• Web SFTP