Solver - Loading Data from Dynamics 365 Finance & Operations
An overview of the steps required to load data using the Build Your Own Database method to connect to the Solver Data Warehouse
This course includes the documentation needed to connect Dynamics 365 Finance & Operations (F&O) to the Solver Data Warehouse.
1. In Dynamics 365 F&O, publish data entity jobs using the build your own database (BYODB) method.
2. Using SQL Server Integration Services (SSIS), enable access to the Dynamics 365 BYODB instance.
3. In Solver, use the Data Gateway or SQL Connector to access Dynamics 365.
A document that lists the standard set of data used in Solver is also included as an example.
Posted 10/19, Revised 1/2020