4We are looking for ways to ingest data from Dynamics 365 Finance into our OLAP system.
We have identified the following approaches:
- OData API - Easy to use, but very slow.
- Batch Export API - Much faster than the OData API but has a significant impact on system performance.
- Synapse Link - Directly stores data in Parquet format in ADLS without impacting system performance.
Can anyone confirm if our understanding of these approaches is correct? Are there any additional points we should consider in terms of cost and performance?
