External Database Configuration

  • Last update: August 30, 2024
  • Overview

    Application Scenario

    FineDataLink has a built-in HyperSQL database (HSQLDB).

    The HSQLDB cannot be accessed by multiple threads and may become unstable in a cluster environment with large amounts of data. It is suitable for a local trial of product functionality. Projects intended for formal use require the configuration of an external database. 

    Unpredictable problems may occur in the data migration process. You can choose to migrate the existing data or enable a new database.

    Function Description

    A FineDataLink system with an external database configured is stable in cluster environments or when experiencing large amounts of data.

    You can configure the external database during initialization or on the platform. The configuration requirements and steps of the two methods are the same.

    Configuration Method

    The following table shows the supported types and versions of the external database.

    iconNote:
    You are advised to choose MySQL and Oracle databases as the external database.

    Database Type

    Supported Database Version

    Configuration Method

    RDS MySQL

    /

    Configuring MySQL5 External Database

    MySQL

    5.1.73, 5.5.31, 5.5.46, 5.5.56, 5.6.22, 5.6.31, and 5.7.16

    8.0.11, 8.0.16, and 8.0.20

    Configuring MySQL8 External Database

    SQL Server

    2000, 2005, 2008, 2012, 2014, 2016, 2017, and 2019

    Configuring SQL Server External Database

    Oracle

    10g, 11g, and 12c

    Configuring Oracle External Database

    Db2

    9.7, 8.2, and 11.1

    Configuring Db2 External Database

    PostgreSQL

    9.4.7, 9.5.0, 9.5.2, 9.6.0, and 13.0

    Configuring PostgreSQL External Database


    附件列表


    主题: 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