The recently developed module of the software expert proves to be a flexible and convenient export functionality for the fast data provision of information from Business Central - time-controlled and in self-selected, regular cycles.
Nuremberg, 15.12.2022 - There is often a lot of potential in a company's data, which, used correctly, can bring an enormous number of advantages. Whoever optimally exploits the value of their ERP data can gain comprehensive new insights, make more efficient strategic decisions and thus secure important competitive advantages. But evaluating the relevant information also depends on the right analysis tools. Ideally, it should always be done via a suitable platform, such as Qlik Sense or Power BI.
However, before the data can be analyzed at all, it must be transferred from the ERP software Dynamics 365 Business Central to the respective analysis software. The BC Suite Data Provider from prisma informatik provides a convenient export functionality for the rapid provision of data from Business Central. The use of this module is particularly helpful when classic web services are not suitable for the required data export and an alternative becomes necessary.
BC Suite Data Provider - How does the module work?
The dynamic BC Suite Data Provider makes it possible to export the required information in table form from the ERP system on a time-controlled basis at regular intervals (via task queue). The data is eventually loaded into Microsoft's cloud-based Azure Blob Storage and from there uploaded to the desired analytics platform for further use. Which tables and fields are exported, can be defined independently. Customer-specific tables or data from third-party modules (apps) can also be transferred. Data exchange with Azure Blob Storage files is a standard feature of the analysis platforms.
Setting up the module is also very easy. The BC Suite Data Provider is installed as an extension in the desired Dynamics 365 Business Central environment in no time via the extension management and can then be used immediately for data export.
Solution with numerous advantages
Users of the BC Suite Data Provider thus benefit from fast and easy data provision from Business Central through an extremely dynamic export functionality. No complex Business Central programming is required to configure tables for data transfer.
The data export enables different formats as well as the transfer of calculated fields (SIFT fields) from Business Central (e.g. customer balance, item inventory, item availability etc.) and the transfer from multiple clients (multi-client management).
The exchange of data via cloud spaces (Azure Blob Storage) is included in the standard of common analysis platforms such as Qlik Sense and Power BI. This eliminates lengthy upload and download times, which ensures a very high transfer speed compared to standard web services.