1. Can register servers.
  2. Can add databases from registered server.
  3. Can manage databases on registered server.


Step 1. Configure the Server

  1. Select Resource Management > Server Management.


  2. Click the New button to add an item.


  3. Write name, IP address, and description and click the Save button.
    The code is automatically generated by the system, not by user input.


Step 2. Configure the Database

Register the database to be used for report development.

When connecting to the database in the product, it can be used after completing data registration and permission granting.


  1. Select Resource Management > Database Management.


  2. Click the New button to activate the DB registration window.

  3. Connect registered server in Server Management, fill in the required fields as requested in the window, then click OK button to complete the setup.


  4. After registration, double-click the item again and click the Connect button to verify if the connection is successful.


For security reasons, the actual input screen has not been registered as an image.

Please refer to the image below for the MTXRPTY DB input.



Step 3. Set Database Permissions

After adding and connecting the database, set permissions for users, departments, and groups.


  1. Double-click the permission icon of the added database to open Permission Settings window.


  2. Click the New button to open Permission Subject Lookup window.



  3. Search for or select the user, department, or group to be newly registered, then click the OK button.


    For Company-wide department with the code name DEFAULT, it represents all users.

    This is a default department added during product installation, so it can be deleted or modified.


  4. Set read, write, and create permissions.


    The permissions granted to the DB service ID take precedence over the permissions set in the product.

    Please verify the permission of the account for the connected database.

    If the service ID of the connected database does not have the required permissions (read, write, create) for the Table or DB to use, even if the permissions are set as shown above, they cannot be used.


    OptionDescription
    ReadPermission to SELECT tables in the database.
    WritePermission to INSERT, UPDATE, DELETE data in the tables of the database.
    CreateSince the AUD platform does not support table creation, the create permission is not necessary to set.



  5. Click the Save button to complete the setting.