Configuring External Databases

  • Last update:November 08, 2024
  • Overview

    Application Scenario

    The built-in database for the BI is the HSQLDB database.

    HSQLDB database does not support multi-threaded access. In a cluster environment with large amounts of data, the database may become unstable. HSQLDB database is suitable for the local trial of product functionality.

    The external database is suitable for the formal use of the platform.

    Migration is based on existing old data, and unpredictable problems are held in the migration process of old data. Therefore, you can choose to migrate the old data or directly enable a new database.

    Function Description

    If an external database is configured for the BI system, the BI system can remain stable in cluster environments or situations with large amounts of data.

    You can configure external databases during initialization or on the platform. The two configuration methods require the same configuration via the same procedures.

    Configuration Method

    The following table describes the supported types and versions of the external databases.

    Note: MySQL and Oracle databases are recommended as the external databases.

    Database Type
    Supported Database VersionConfiguration Method

    RDS MySQL

    All versions

    Configuring   MySQL5 Databases

    MySQL

    5.1.73/5.5.31/5.5.46/5.5.56/5.6.22/5.6.31

    5.6.22/5.6.28/5.6.31/5.6.35/5.6.37/5.6.44

    5.7.16/5.7.23/5.7.26/5.7.33

    8.0.11/8.0.16/8.0.20/8.0.21/8.2

    Configuring   MySQL8 Databases

    Oracle standalone

    10g (10.2)/10.2.0.1.0

    11g (11.0.2.1)/11g   (11.0.2.4)/11.0.2.4/11.2.0.2.0

    12c/12c V12.2/19c

    Configuring   Oracle Databases

    Oracle cluster

    11g/12c

    SQL Server

    2000/2005/2008/2012/2014/2016/2017/2019

    Configuring   SQL Server Databases

    Db2

    8.2/9.7/10.5/11.1

    Configuring   Db2 Databases

    PostgreSQL

    9.2.3/9.4.7/9.5.0/9.5.2/9.6.0/13.0

    Configuring   PostgreSQL Databases

     


    附件列表


    主题: System Management
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy