Book Image

Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

By : Roberto Stefanetti, Alex Chow
Book Image

Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

By: Roberto Stefanetti, Alex Chow

Overview of this book

Microsoft Dynamics Business Central is a full business solution suite and a complete ERP solution, which contains a robust set of development tools; these tools can help you to gain control over your business and can simplify supply chains, manufacturing, and operations. Implementing Microsoft Dynamics 365 Business Central On-Premise covers the latest features of Dynamics Business Central and NAV from the end users' and developers' perspectives. It also provides an insight into different tools available for implementation, whether it's a new installation or migrating from the previous version of Dynamics NAV. This book will take you from an introduction to Dynamics NAV 2018 through to exploring all the techniques related to implementation and migration. You will also learn to expand functionalities within your existing Microsoft Dynamics NAV installation, perform data analysis, and implement free third-party add-ons to your existing installation. As you progress through the book, you will learn to work with third-party add-on tools. In the concluding chapters, you will explore Dynamics 365 Business Central, the new Cloud solution based on the Microsoft NAV platform, and techniques for using Docker and Sandbox to develop applications. By the end of the book, you will have gained a deep understanding of the key components for successful Dynamics NAV implementation for an organization.
Table of Contents (22 chapters)
Title Page
Copyright and Credits
Dedication
About Packt
Contributors
Preface
Index

Extracting data


Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central offer several ways to analyze and report data inside the application. If that is not enough, you can also extract data from the application and use external tools to report and analyze your data.

In this section, we will see the different ways in which you can extract your data from Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central. Once it is outside the application, you can use the most convenient tool for you.

Data in Microsoft Dynamics NAV and Dynamics 365 Business Central can be extracted in multiple ways:

Feature

Dynamics NAV

Dynamics 365 Business Central on-premise

Dynamics 365 Business Central SaaS

Copying and pasting

Yes

Yes

Yes

Extracting data through Microsoft SQL Server

Yes

Yes

No

Any external data/reporting tools that can connect to Microsoft SQL Server

Yes

Yes

No

Web services (OData) published

Yes

Yes

Yes

Electronic Data Interchange (EDI)

Yes

Yes

Yes

Microsoft PowerShell Scripts

Yes

Yes

No

Microsoft Power...