Collecting data from Microsoft Dynamics 365

This guide explains how to collect data from Microsoft Dynamics 365. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

You can collect all report types and fields available in Microsoft Dynamics 365.

  • Microsoft Dynamics 365 can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Creating a datastream to collect data from Microsoft Dynamics 365

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Microsoft Dynamics 365.

Configuration: Choose the data you want to collect from Microsoft Dynamics 365

To choose what data to collect and customize the Microsoft Dynamics 365 datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Report type, select the type of data to collect from Microsoft Dynamics 365.

  1. In Fields, change the list of fields that you want to see in your data extract.

  1. In Date filter, select the field that you want to use to define the fetch date range.

What's next?