Databases

Overview

QueryPie DAC (Database Access Controller) supports controlling over 20 different RDBMS and NoSQL data sources through a standardized SQL syntax using a proprietary engine. Users can access databases and execute queries via a web browser, regardless of the operating system. Additionally, QueryPie supports the use of IDE tools like Datagrip and DBeaver through a desktop agent.

Recommended Initial Setup Sequence for DAC

If you are a first-time administrator using QueryPie DAC, it is recommended to follow the steps below to ensure smooth database management.

Click the linked items to navigate directly to the related guide.

	Recommended Steps	Setup Items
1	Preparation	Users Groups
2	Register DB Connections	Synchronize DB Resources in AWS Registering a DB Connection Manually Data Source-Specific Configuration
3	Set Policies	Data Masking Data Access Sensitive Data Ledger Table Policy
4	Grant Permissions	Privilege Type DB Access Control
5	Access DB	Connect to DB
6	Review Logs	Database Logs