• English

      • Data source management

      Data source managerCommunity Edition+

      Introduction

      NocoBase provides the Data Source Manager plugin to manage data sources and their collections. It provides the management interface for all data sources; it does not connect to a data source by itself. Use it together with the applicable data-source plugin.

      Supported data sources include:

      • Main database: The NocoBase main database. It supports MySQL, PostgreSQL, MariaDB, KingbaseES, and OceanBase.
      • External PostgreSQL: Uses an external PostgreSQL database as a data source.
      • External MySQL: Uses an external MySQL database as a data source.
      • External MariaDB: Uses an external MariaDB database as a data source.
      • External MSSQL: Uses an external MSSQL (SQL Server) database as a data source.
      • External KingbaseES: Uses an external KingbaseES database as a data source.
      • External OceanBase: Uses an external OceanBase database as a data source.
      • External Oracle: Uses an external Oracle database as a data source.
      • External ClickHouse: Uses an external ClickHouse database, typically for queries, statistics, and reports.
      • External Doris: Uses an external Doris database, typically for queries, statistics, and reports.
      • REST API data source: Connects data supplied by a REST API to NocoBase.
      • External NocoBase: Uses the remote NocoBase API to connect another NocoBase application as an external data source.

      Plugins can extend this list with other database types and platforms that provide APIs or SDKs.

      Installation

      This plugin is built in and does not require a separate installation.

      Usage

      During application initialization, NocoBase provides a data source for storing NocoBase data. This source is called the main database. See Main database for details.

      External data sources

      NocoBase supports external databases as data sources. See External databases for details.

      External data sources

      Synchronize custom database tables

      You can synchronize tables that were created in the database outside NocoBase.

      Synchronize custom database tables

      You can also connect data supplied by an HTTP API. See REST API data source for details.

      External NocoBase data source

      Use the remote NocoBase API to connect another NocoBase application as an external data source. See External NocoBase for details.