We are using the native Dynamics 365 Query components to pull data from a client's 365 organisation.
Data such as quotes / leads / users.
So far we've struggled to get results. And even "validating" the component is causing the server to throw Out of Memory errors and timeouts.
We increased the ram size of our Matillion EC2 instance, however still experiencing some issues.
Other steps were to avoid using debugging on the jobs and only select explicit columns from the data. This has helped but not totally eliminated the problem.
Next step would be to create our own custom Dynamics connections but this is time-consuming.
Any suggestions or comments from those who have or are using Matillion with Dynamics 365 Query?
Cheers