Help Center/ ROMA Connect/ User Guide (ME-Abu Dhabi Region)/ FAQs/ Data Integration Tasks/ Will Collected Data Be Updated After a File Is Parsed from OBS to the RDS Database?
Updated on 2024-07-10 GMT+08:00

Will Collected Data Be Updated After a File Is Parsed from OBS to the RDS Database?

If the same file is collected and the destination database has a primary key, FDI updates data based on the primary key each time the file is updated on OBS.

If multiple files are collected and the destination database has same primary keys, FDI updates data with the value in the earliest file each time. By default, FDI obtains files from OBS based on the timestamp in descending order. The file uploaded at the latest time is parsed first, and the file uploaded at the earliest time is parsed last. As a result, after the task execution is complete, the value in the database is still the value in the earliest uploaded file.