Export tables from BC to your Own AzureSQL DB
For datawarehousing and analyse tooling it would be great if we could be able to export a configurable set of data tables from Business central to an external AzurerSQL. The export should scheduled and feed the external AzureSQL with updates. Same kind of solutions is available in D365 F&O https...
Extend codecop analyzer to report on protected tables
Recently we discovered in our Online environment we made modifications on protected tables (In this case table ID 297 - Issued Reminder Header). I see an improvement for the code analyzer (CodeCop) here. In case you do direct updates on such tables, permissions needs to b granted on the object le...
(Readonly)AppManagement endpoint to get information about tenants, environments and installed apps
Readonly AppManagement endpoint to get information about tenants and environments and its installed apps. Add standard data connector to the powerplatform, so we can build our own PowerApp to view information about current tenant and environments
Having audittrail on all admin admin activities related to deploy, publish, install and upgrade of apps
Have audittrail implemented on all admin functions in the platform about upgrade, install and deployment of apps and services. With an API endpoint we can extract all those management tasks. Who did what in which environment. Audit log is key for ISAE-3402 certification
Adding events to the Azure event grid about deployments, installation and upgrade of apps
Adding events about deployments and upgrades to the event grid, so customers, partners and we as ISV can subscribe to it. Could be about email or notification. But also triggering deployments of other components to Azure when deployment of BC has been completed. Having the events in event grid op...
Share data between companies for master data
Our customers tend to have many companies (up to 100+). Those companies will share a lot master data (Contacts, Customers, vendors , employees, postcode table). Only solution to share data is to duplicate it accross companies. Looking at the Dutch postcode table it is approx. 600Mb if size. Dupl...
Send External (business) Events to Azure event grid
Create a native integration with Azure event grid for all external business events. Having the event in Azure Event Grid opens up for more standardized integration possibilities.
Solution could be as follow:
- Create a setup page in BC to select the relevant business events ...
Prevent customer to uptake new major/minor version
When putting apps on apps source we can set the minimum platform version for which the app is compatible (Application property and dependencies in app.json). What we can't do is prevent customers moving to a higher version of BC. As long as my app compiles the platform can be updated. If it a...