Overview
Version
| FineDataLink Version | Functional Change |
|---|---|
| 4.0.4.2 | Scheduled Task supported data reading from the MongoDB database. |
| 4.1.6.4 | Scheduled 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 Version | Driver Package |
|---|---|
| MongoDB 7.0 and prior versions | mongo-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.
Note:
2. Click the MongoDB icon.
3. Fill in the connection information.
The following table describes the setting items.
| Setting Item | Description |
|---|---|
| Data Connection Name | Fill 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 Preference | Specify 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 Conversion | If selected, FineDataLink will automatically converse the time zone when synchronizing the time field from MongoDB databases |
| Time Zone | It 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.
Previous：SeaboxMPP Data Connection
