As almost all people know there is a sync between Business Central and Dataverse. With this sync you can sync your Business Central data with Dataverse and use it in your apps/pages etc. Your data will be there in Dataverse.
Tag Archives: Data
Business Central Online, quick comparison and detection of differences between table data structures using Powershell
Previously it was possible to export data structures to files (available in runtime1), the functionality was blocked from runtime 2 onwards.
Interesting function that in my opinion should be reinserted and made usable at least for On-premise.
Business Central data exported in Azure Data Lake
Azure Data Lake includes all the capabilities required to make it easy for developers, data scientists, and analysts to store data of any size, shape, and speed, and do all types of processing and analytics across platforms and language
Anonymize Data in Business Central with our Chrome Extension
Anonymize Data in Business Central with our Chrome Extension
How-To Import variable CSV/TXT Files with the Data Exchange Framework into any Table
You can use the Data Exchange Framework to manage the exchange of business documents, bank files, currency exchange rates, and any other data files with your business partners.
Export SQL data to CSV or XML File via Powershell
Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file.
How to group data in AL? Best practicies. Performance review.
Data manipulation is one of the most trivial things for Navision/Business Central Developer. We are constantly working with data in tables, adding, deleting, modifying, and so on. Today we’re going to discuss data grouping. What does it mean to group data? How do you do it in AL? What is the best and fastest way to do it? I hope we can find answers to all these questions.