Data Lake table data update

Technically we shouldn't be updating data in Data Lake directly, so it has true representation of what's there in M3.

However, there has been a scenario recently which required us to get direct SQL update done in M3 database (M3 CE) by Cloud DBA team. Those direct updates in M3 database didn't trigger any Event hence that update didn't reach Data Lake.

What's the best way to get that direct update in M3 database reflected in Data Lake table?

Find more posts tagged with

Infor Data Fabric

Accepted answers

All comments

Alistair Johnson

Have you already tried EVS002MI to re-send the data to Datalake? That should work - as it's the same process that is used for an initial send of data.

Legacy Contributor

That's a good option. I've used EVS002MI for initial load. Has that option to load data for date range?

per-melander

Hi Akash - yes there is a From date/To date as date range in EVS002MI, so if you know the date range for the data that the cloud dba modified, the re-load of that portion will be easy.

Legacy Contributor

That's great, thanks Per.

Just on that, which parameter should get the date column name for the date range to work against?

Legacy Contributor

Is it possible to resend data of specific company only? e.g. CONO=200

Copyright © 2025 Infor. All rights reserved.