Information about Workbench

Workbench

Workbench is a front-end interface by which the admin user can connect to the Element servers and execute SQL queries.

Accessing Workbench

Select the arrow icon in the top right corner of the Element DB screen to access the Workbench.

arrow icon

Adding Element Connections.

1. Sign in to the DL Unify Portal.

Sign in page

2. Select the Element DB tile from the DL Unify Dashboard and enter the Element Secret.

Element Secret popup

3. Manage Database is the default page upon sign-in.

Manage Databases Page

4. Access Element Workbench by clicking the arrow icon on the top right corner of the Element DB screen.

arrow icon

5. Click on the + button next to Element Connections

• button

6. A pop-up with the following details appears:

• Connection name - also known as the DB access level (DB_ADMIN, DDL, DML_WRITE, DML_READ).

• Username- Enter the previously copied username in the Username section.

• Element Server URL- The user will get the Element server URL from the activation link.

• Organization code- To view the organization code, click on the organization's initials at the top right corner of the Element DB page. Click on the Profile under initials (refer to screenshot 'arrow icon' above) to view the Organization code.

New Connection popup

7. After entering all the details, click on the Save and Save Anyway buttons.

Save button

8. To open the Workbench, hover over it and click on the play icon. A pop-up with the Element secret data field appears.

9. Copy and paste the Element secret in the data field.

Enter Element Secret

10. There are two types of SQL:

• DDL (Data Definition Language)- Create Table, Alter Table, etc.

• DML (Data Manipulation Language)- Insert Record, Update Record, Delete Record.

11. Differences between DDL, DML Write, and DML Read access.

A user with DDL access can perform the following queries-

• Create Table

• Alter Table

• Show Table

• Drop Table

• Insert Record

• Update Record

• Delete Record

• Select Record

A user with the DML Write access can perform the following queries-

• Insert Record

• Update Record

• Delete Record

• Select Record

A user with DML Read access can perform the following queries-

• Select Record

12. If a user tries to perform queries beyond his access level, he gets an error message stating, Access Denied.