Overview

QueryPie supports MS Azure integration for database registration and management. You can synchronize resources within Azure to register them as databases managed by QueryPie, and grant access permissions and set policies for users and groups for the synchronized databases.

Registering Azure Integration Information in QueryPie

1. Navigate to the Cloud Provider menu from the Database settings menu.
2. Click the Create Provider button in the top right.
3. Enter a name that can distinguish the provider in the Name field.
4. Select Microsoft Azure from the Cloud Provider field.
5. Enter the Tenant ID of the resources you want to synchronize.
6. Enter the Subscription ID.
7. Enter the Credential information required to synchronize resources. Currently, only Client Secret method is supported.
   • Provides a manual synchronization method that enters Azure’s Client Secret when clicking the Synchronize button.
     Starting from QueryPie 10.2.2, the “Save Credential for Synchronization” option is provided to enable scheduled synchronization even when using Client Secret as the Credential type.
8. Select the resources you want to synchronize from the Database Type Filter field.
   • Currently, only Azure SQL Database can be synchronized.
9. Select the synchronization method from the Replication Frequency field.
   1. Manual : A method that synchronizes manually only when you want to synchronize.
   2. Scheduling : A method that synchronizes resources through periodic scheduling. Provides Cron Expressions.
10. Auto Configuration Upon Initial Synchronization You can specify some values for DBs that are first synchronized from the Cloud Provider. Initial value settings cannot be modified after saving the Cloud Provider. If changes to this setting are needed, you must delete the Cloud Provider and register it again.
    • Tag : You can automatically add tags to synchronized DBs.
      • If you enter {vpcid} in the tag value, the VPC ID of the Cloud that the DB belongs to will be automatically filled.
      • Example: If you set the tag Key to “Network” and enter Value as {vpcid}, when the DB is in “vpc-1a2b3c4d” VPC, the “Network: vpc-1a2b3c4d” tag will be automatically created.
11. Click the Save button to save the Cloud Provider.

Synchronizing and Managing Registered Azure Cloud Provider

1. Navigate to the Cloud Provider menu from the Database settings menu.
2. Click on the registered Cloud Provider to enter the detailed information screen.
3. Click the Synchronize button in the top right to synchronize resources from Azure.
4. You can check the synchronization progress in the displayed Synchronization Log, and also check the synchronization history in the Administrator > General > Systems > Jobs menu.
5. Once a Cloud Provider is registered, the Provider basic information and authentication information cannot be changed.
   1. Name : Changeable
   2. Cloud Provider : Not changeable
   3. Tenant ID : Not changeable
   4. Subscription ID : Not changeable
   5. Credential : Not changeable
      1. “Save Credential for Synchronization” : Can be changed from disabled to enabled, but cannot be changed from enabled to disabled
   6. Database Type Filter : Not changeable
   7. Replication Frequency : Cloud synchronization settings with the “Save Credential for Synchronization” option enabled can change this value. “Save Credential for Synchronization” is disabled by default.