Help Center> Cloud Bastion Host> FAQs> Product Consulting> Which Types of Databases Can I Manage in a CBH System?

Which Types of Databases Can I Manage in a CBH System?

In CBH, you can manage a variety of databases in the host operation or application operation module. In the host operation module, you can audit database operations, such as adding, deleting, modifying, and querying database operations. In the application operation module, you can audit operation sessions through videos.

  • In CBH standard editions, directly managing databases is not available. To manage databases, an application publish server must be set up.
  • In CBH professional editions, directly managing databases is available in the host operation and application operation modules.

Managing Databases in the Host Ops Module

In the Host Ops module, you can manage MySQL, SQL Server, Oracle, and DB2 databases. PostgreSQL databases cannot be managed with CBH. For the database types, versions, and client software versions supported by CBH, see Table 1.

Table 1 Supported database types, versions, and clients

Database Type

Version

Supported Client

MySQL

MySQL 5.5, 5.6, 5.7, and 8.0

Navicat 11 and 12

MySQL Administrator 1.2.17

MySQL CMD

Microsoft SQL Server

2017

Navicat 11 and 12

SQL Server Management Studio (SSMS) 17.6

Oracle

10g, 11g, and 12c

Toad for Oracle 11.0, 12.1, 12.8, and 13.2

Navicat 11 and 12

PL/SQL Developer 11.0.5.1790

DB2

DB2 Express-C

DB2 CMD command line 11.1.0

PostgreSQL

Not supported

N/A

Managing Databases in the Application Ops Module

To manage databases in the Application Ops module, deploy a database client on a Windows system that supports remote desktop. Use a web browser to remotely log in to the Windows desktop through CBH, invoke the database client, and implement O&M on database applications.

Table 2 lists the database clients that can be directly configured and invoked by CBH. To manage other types of database applications on Windows hosts, set the application server type to Other. For details, see Adding Application Resources.

Table 2 Supported database clients

Application Type

Supported Client

MySQL Tool

MySQL Administrator

Oracle Tool

PL/SQL Developer

SQL Server Tool

SSMS

dbisql

dbisql