Hi all,
Can someone help me understanding the difference beween below settings on the IAL Config?
Use Live Data = always running live and showing all data, and Copy All Data you can schedule but still showing all as available til that particular schedule date?
Copy Only New Data: Only adds changed data? Or also updated data?
Best answer by ashen_malaka_ranasinghe
Hi
Use Live Data means the IAL never stores data. It always queries the source tables at runtime, so the data is always current. There is no scheduling or copying involved, but it can put more load on the database.
Copy All Data means the IAL stores a full copy of the data. Each time the job runs (manually or scheduled), it reloads all records again. The data you see is only as up to date as the last successful run.
Copy Only New Data is an incremental load. It copies only the data that has changed since the last run, based on a timestamp or similar column. This usually includes both new records and updated records, as long as the source supports tracking changes.
+14Hi
Use Live Data means the IAL never stores data. It always queries the source tables at runtime, so the data is always current. There is no scheduling or copying involved, but it can put more load on the database.
Copy All Data means the IAL stores a full copy of the data. Each time the job runs (manually or scheduled), it reloads all records again. The data you see is only as up to date as the last successful run.
Copy Only New Data is an incremental load. It copies only the data that has changed since the last run, based on a timestamp or similar column. This usually includes both new records and updated records, as long as the source supports tracking changes.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
