- Can register servers.
- Can add databases from registered server.
- Can manage databases on registered server.
Step 1. Configure the Server
- Select Manage Resources > Set a Server.
- Click the New button to add an item.
- 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.
Note : Database Connection
When connecting to the database in the product, it can be used after completing data registration and permission granting.
- Select Manage Resources > Manage Database.
Click the New button to activate the Register DB window.
Connect registered server in Server Management, fill in the required fields as requested in the window, then click OK button to complete the setup.
After registration, double-click the item again and click the Connect button to verify if the connection is successful.
Note : Impossible Attaching Images in the Guide
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.
- Double-click the permission icon of the added database to open Set Permission window.
- Click the New button to open Inquiry Permission Subject Lookup window.
Search for or select the user, department, or group to be newly registered, then click the OK button.
Note : Company-wide Permission
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.
Set read, write, and create permissions.
Note : Database Permission Options
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.
Note : Pemission Example
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.
Option Description Read Permission to SELECT tables in the database. Write Permission to INSERT, UPDATE, DELETE data in the tables of the database. Create Since the AUD platform does not support table creation, the create permission is not necessary to set. - Click the Save button to complete the setting.
