Book Image

Mastering Microsoft Dynamics 365 Business Central

By : Stefano Demiliani, Duilio Tacconi
Book Image

Mastering Microsoft Dynamics 365 Business Central

By: Stefano Demiliani, Duilio Tacconi

Overview of this book

Dynamics 365 Business Central is an all-in-one business management solution, which is easy to adopt and helps you make smarter business decisions. This book is a comprehensive guide to developing solutions with Microsoft ERP (in the cloud and also on-premises). It covers all aspects of developing extensions, right from preparing a sandbox environment to deploying a complete solution. The book starts by introducing you to the Dynamics 365 Business Central platform and the new Modern Development Environment. You'll then explore the sandbox concept, and see how to create sandboxes for development. As you advance, you’ll be able to build a complete advanced solution for Dynamics 365 Business Central with AL language and Visual Studio Code. You'll then learn how to debug and deploy the extension and write automatic testing. The book will also take you through advanced topics like integration (with Azure Functions, web services, and APIs), DevOps and CI/CD techniques, and machine learning. You'll discover how Dynamics 365 Business Central can be used with Office 365 apps. Finally, you'll analyze different ways to move existing solutions to the new development model based on extensions. By the end of this book, you'll be able to develop highly customized solutions that meet the requirements of modern businesses using Dynamics 365 Business Central.
Table of Contents (25 chapters)
Free Chapter
Section 1: Dynamics 365 Business Central - Platform Overview and the Basics of Modern Development
Section 2: Developing Extensions for Dynamics 365 Business Central
Section 3: Debugging, Testing, and Release Management (DevOps)
Section 4: Advanced Integrations with Dynamics 365 Business Central
Section 5: Moving Solutions to the New Extension Model

Connecting to an existing SQL Server

You can instruct the container to connect to an existing SQL Server and database instead of using the SQL Server inside the container, which will also mean that the SQL Server inside the container will not be started. This is needed if you want to connect multiple instances to the same database, but also makes a lot of sense if you want to run a lot of containers on the same host. Otherwise, you will have one SQL Server running per container, which will need a lot of resources.

In this section, I am assuming there is a SQL Server (in a container or not) called sqlserver running in your local environment where the Business Central container can reach it. I have a SQL user called sqluserwith a password of 1SuperSecretPwd!, who has the necessary rights to access a Business Central database called FinancialsW1 on that server. For this scenario...