Solver Data Source Connector: Microsoft Dynamics Business Central
Integration Platform â General Information
Solver offers a robust platform to streamline the movement of data both into Solver as well as out of Solver to your other applications.
Loading data into Solver:
Solverâs cloud platform includes an integration interface with scheduling of automated data loads and a number of generic, as well as specific, data source connectors.
For certain data sources, Solver also offers QuickStart*, which consists of an out-of-the-box integration that does not require any configuration, as well as pre-defined financial reports, budget templates, and dashboards.
Exporting data out of Solver to other applications:
Most of the time, customers donât have a need to export data OUT of Solver. However, in some cases, it may be desirable to export completed budgets back to the ERP system. In other cases, a company is using BI tools like Microsoft Power BI or Tableau and want to connect these to Solver to export data to their dashboards. There are two ways of exporting data out from Solver:
Solver API â Using this secure API as well as a connector, data can be delivered to a third-party solution.
Excel export â Solver can deliver data to Excel files in virtually any format that matches the required import format of third-party solutions. These Excel exports can also be scheduled using Solverâs Publisher.
Dynamics 365 Business Central Connectors
Solver offers several different connectors for Microsoft Dynamics 365 Business Central:
OData Connector â Use Solverâs OData connector to integrate to Dynamics 365âs OData API. Typically used for smaller data loads.
QuickStart Connector*â Use Solverâs pre-built OData connector which is already mapped to specific fields in Dynamics 365. In this case, Solverâs scripts automatically create the endpoints in Dynamics 365.
SQL Connector â This integration method relies on first transferring the chosen data and dimensions from Dynamics 365 to Microsoftâs âBring Your Own Databaseâ (BYOD) and then using Solverâs SQL connector to load the data from BYOD and into Solver. Typically used for larger data loads or complex transformations.
Imagine a suite of easy-to-learn and easy-to-use business solutions tailored to your market, designed for your business size, and dedicated to growing your business through happy customers. Microsoft Dynamics offers a full range of software focused on delivering business insights that matter to both you and your customers.