Overview

The Databases menu provides a database browser interface that allows administrators to view database objects and records managed by OneDB.

Through this menu, administrators can browse supported database platforms, including MySQL, Oracle, PostgreSQL, and MSSQL. Administrators can view available databases, schemas or owners, tables, and table records from the OneDB Admin Console.

The data displayed in this menu may appear as plain values or tokenized values, depending on the field configuration and data protection policy applied in OneDB.

This menu is mainly used for visibility and verification, allowing administrators to confirm that OneDB can access the managed database and display data according to the configured protection policy.

Supported Database Types

The Databases menu can be used to browse database objects from supported database platforms, such as:

Database Type	Common Browsing Structure
MySQL	Database → Table → Records
PostgreSQL	Database → Schema → Table → Records
Oracle	Database / Service → Schema / Owner → Table → Records
MSSQL	Database → Schema → Table → Records

The displayed structure may vary depending on the database type, database permissions, and how the database connection is configured in OneDB.

Main Functions

Administrators can use the Databases menu to:

• Browse databases managed by OneDB
• View available schemas, owners, or database objects
• View tables inside a selected database, schema, or owner
• View table record count and table size, when available
• Browse records inside a selected table
• Verify whether field values are displayed as plain or tokenized values
• Confirm that database objects are accessible through OneDB
• Validate that OneDB data protection policies are applied as expected

Database Browser Navigation

The database browser follows a general hierarchical navigation flow.

Depending on the database type, some levels may be different or may not be displayed.

For example:

MYSQL

POSTGRESQL

ORACLE

MSSQL

Database List View

The first level shows the list of database connections or database objects available for the selected database type.

Example information displayed:

Field	Description
IP / Host	The database server address.
Database / Schema / Service	The database, schema, service, or logical object name depending on the database type.
Database Type	The database engine, such as MySQL, Oracle, PostgreSQL, or MSSQL.
Browse Icon	Opens the selected item for further browsing.

Schema or Owner View

After selecting a database or connection, OneDB may display available schemas, owners, or logical object groups.

This level may vary depending on the database type:

Database Type	Common Term
MySQL	Database
PostgreSQL	Schema
Oracle	Schema / Owner
MSSQL	Schema

Example information displayed:

Field	Description
Schema / Owner	The schema, owner, or object group available inside the selected database.
Browse Icon	Opens the selected schema or owner and displays the available tables.

For some database types or configurations, OneDB may directly display tables without showing a separate schema or owner level.

Table View

After selecting a database, schema, or owner, OneDB displays the available tables.

Example information displayed:

Field	Description
Table	The table name inside the selected database, schema, or owner.
Records	The number of records available in the table, when available.
Size	The estimated table size, when available.
Browse Icon	Opens the selected table and displays its records.

Example:

Table	Records	Size
Customers	1,250,000	128.50 MB
Employees	6,864,400	364.38 MB

Record View

After selecting a table, OneDB displays the records inside the table.

The columns displayed in this view are based on the selected table structure. Depending on the configured OneDB protection policy, field values may be shown as plain values or tokenized values.

Display Type	Description
Plain Value	The original value is displayed as stored or retrieved from the database.
Tokenized Value	A token value is displayed instead of the original sensitive value.

Example:

Field	Plain Value	Tokenized Value
FullName	Shean Hathway	z3eY8 onuux7e
Email	shean@domain.com	ZZ3uO@Xg0vUC.pqw
Phone Number	555-0100	190-6320

The actual displayed values depend on the field settings, tokenization configuration, and data protection policy applied in OneDB.

Plain and Tokenized Data Display

OneDB may display different values depending on how each field is configured.

For example:

Field	Configuration	Displayed Value
CustomerID	Plain	Original value
FullName	Tokenized	Token value
Email	Tokenized	Token value
Department	Plain	Original value
CreatedDate	Plain	Original value

This allows administrators to verify whether sensitive fields have been protected properly while non-sensitive fields remain readable.

Filtering Records

The Filter function allows administrators to narrow down displayed records based on selected criteria.

This is useful when administrators need to search for specific records or verify how certain field values are displayed after being processed by OneDB.

Administrators can use filtering to:

• Search specific records
• Validate protected field behavior
• Check whether tokenized fields are displayed correctly
• Review selected records without browsing the entire table
• Confirm that OneDB can read data from the selected database object

Important Notes

The Databases menu is primarily used for browsing and verification. It is not intended to replace a full database administration tool.

Administrators should use this menu to confirm that:

• The selected database platform is accessible from OneDB
• Database objects can be browsed successfully
• Schemas, owners, or tables are displayed correctly
• Table records can be viewed
• Plain fields are displayed as expected
• Tokenized fields are displayed correctly based on configuration
• OneDB data protection policies are applied as intended

Recommended Practice

Use the Databases menu after configuring the related OneDB components, such as Connection, Field Settings, Keys, Mask, and Template.

For production environments, access to this menu should be carefully controlled because it may display database records, including plain or tokenized values depending on the configured policy.

Recommended controls:

Recommendation	Description
Limit access	Only authorized administrators should access the database browser.
Use role-based access	Assign browsing permissions based on user responsibility.
Validate field settings	Confirm sensitive fields are correctly registered in OneDB.
Review displayed values	Ensure protected fields appear as expected.
Avoid unnecessary exposure	Do not grant browsing access to users who do not need to view database records.
Test per database type	Validate browsing behavior for each supported database platform.