Hi All.
I have got a pipeline that copies tables from dynamics 365 to a database using pipelines, I was wondering if its possible to have a custom table that is only populated every so often, I can then do a check on the destinatioin SQL server database to see how up to date my ETL replication is, is the time is 1pm, and the table is populated by dynamics every 15 minutes, if by 2pm my synch/replicated table still has 1pm as the last synch time, then I know there is a problem with the pipeline flow or some other problem.
Is there a better way to do this other than monitoring the actual pipeline ?
Thanks in advance.