Databases

Overview

QueryPie DAC can control 20+ types of RDBMS, NoSQL, and other diverse data sources through standardized SQL syntax using its own developed engine. Users can access databases and execute queries through web browsers regardless of operating system. It also supports the use of IDE tools such as Datagrip and DBeaver through desktop agents.

Recommended DAC Initial Setup Sequence

If you are an administrator using QueryPie DAC (Database Access Controller) for the first time, we recommend following the initial setup sequence below for smooth database management.

Clicking on linked items will take you to a page where you can immediately check the related guide.

	Setup Sequence	Setup Items
1	Preparations	User Registration User Group Registration
2	Register Connections	Synchronize DB Resources from AWS DB Connections \| Manually Registering DB Connections Data Source-Specific Setup Guide
3	Configure Policies	Setting Up Data Masking Policies Setting Up Table/Column Access Restriction Policies Setting Up Sensitive Data Policies Setting Up Ledger Table Control Policies
4	Grant Permissions	Creating and Managing Privileges Granting and Revoking Access Permissions
5	Access DB	Accessing DB
6	Check Logs	Checking Audit Logs