MongoDB Data Connection

  • Last update: September 19, 2024
  • Overview

    Version 

    FineDataLink VersionFunctional Change
    4.0.4.2

    Scheduled Task supported data reading from the MongoDB database.

    4.1.6.4Scheduled Task supported data writing into the MongoDB database.

    Function Description

    FineDataLink supports connection to MongoDB for data reading/writing using scheduled tasks.

    Compatibility Instruction 

    If a MongoDB plugin and a MongoDB data connection in FineDataLink exist simultaneously:

    • The two kinds of data connections provided by FineDataLink and the plugin are independent of each other and not mutually available. They are distinguished by name.

    • FineDataLink cannot use the MongoDB Detail Dataset and the MongoDB Aggregation Dataset provided by the plugin.

    • FineDataLink MongoDB data connection is masked at the server dataset.

    Procedure 

    Version and Driver

    1. Confirm the database version, and download the driver package.

    Supported Database VersionDriver Package
    MongoDB 7.0 and prior versionsmongo-java-driver-3.12.10.jar

    2. Place the downloaded driver package in the \webapps\webroot\WEB-INF\lib directory.

    3. Restart the FineDataLink project.

    Connection Information Collection 

    Collect the following information before connecting FineDataLink to the database.

    • IP address and port number of the database server

    • Username and password of the database (can be omitted if no authentication is required)

    Procedure

    1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection.

    iconNote:
    If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission


    2. Click the MongoDB icon.

    3. Fill in the connection information.

    The following table describes the setting items.

    Setting ItemDescription
    Data Connection NameFill in the data connection name.
    Database Address

    Fill in the IP address or hostname of the MongoDB database and the port number

    If it is a cluster, enter multiple addresses separated by commas. For example, 192.168.1.123: 27017,192.168.1.124: 27017.

    The comma can be either half-width or full-width.

    Read PreferenceSpecify the read strategy, which is effective when the cluster is a replica set. This configuration item does not take effect in other cases. For details, see Read Preference.
    Authentication Method

    There are two options, namely No Authentication and Username & Password.

    If No Authentication is selected, you can connect to the target database without authentication.

    Auto Time Zone ConversionIf selected, FineDataLink will automatically converse the time zone when synchronizing the time field from MongoDB databases
    Time ZoneIt appears when Auto Time Zone Conversion is selected, allowing for specifying a time zone.

    4. Click Test Connection. If the connection is successful, click Save to save the configuration.

    Data Source Usage

    After configuring the data source, you can use it to read and write data in Data Development. For details, see MongoDB Input and MongoDB Output.

     


    附件列表


    主题: Data Source Configuration
    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