Help Center/ Cloud Bastion Host/ FAQs/ Product Consulting/ Which Types of Databases Can I Manage in a CBH System?
Updated on 2023-04-11 GMT+08:00
View PDF

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

In CBH, you can manage a variety of databases in the host O&M module (Host Operation) or application O&M module (Application Operation). 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 Operation Module

In the Host Operation 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, 12, 15, and 16

MySQL Administrator 1.2.17

MySQL CMD

Microsoft SQL Server

2017

Navicat 11, 12, 15, and 16

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, 12, 15, and 16

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 App Operation Module

You can use CBH to manage following versions of databases in the application O&M module:
  • Windows Server 2008 R2 or later

    You need to deploy the database client on a Windows operating system that supports remote desktop. Then, you can 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 are deployed on Windows servers and can be directly configured and called by CBH. To manage other types of database applications on Windows hosts, set the application server type to Other.

    Table 2 Supported Windows database clients

    Application Type

    Supported Client

    MySQL Tool

    MySQL Administrator

    Oracle Tool

    PL/SQL Developer

    SQL Server Tool

    SSMS

    dbisql

    dbisql

    PostgreSQL

    Navicat for PostgreSQL
  • For Linux servers, only database applications running on Linux CentOS 7.9 servers can be managed.

    Linux servers support only Dameng database V8 applications.

    Table 3 lists the database clients that are deployed on Linux servers and can be directly configured and called by CBH.
    Table 3 Supported Linux database clients

    Application Type

    Supported Client

    Dameng Database

    Dameng management tool V8
Parent topic: Product Consulting