Hi,
We are currently upgrading to M3CE and plan to use ETL to mirror some tables to an SQL Server.
A few of these tables are fairly large, but we don’t actually need all the records from the data lake.
For example, we might want to exclude records with a “closed” status, or records with a registration date earlier than 2023.
At the moment, the load only uses the dlDocumentDate, and since all dates are migrated, everything gets transferred.
Is there a way to include additional fields in the initial load, so we can limit the amount of data transferred from the start.
Tried to see if this already been discussed but were not able to find a discussion around it
Regards Sandra