Book Image

Microsoft Dynamics 365 Extensions Cookbook

Book Image

Microsoft Dynamics 365 Extensions Cookbook

Overview of this book

Microsoft Dynamics 365 is a powerful tool. It has many unique features that empower organisations to bridge common business challenges and technology pitfalls that would usually hinder the adoption of a CRM solution. This book sets out to enable you to harness the power of Dynamics 365 and cater to your unique circumstances. We start this book with a no-code configuration chapter and explain the schema, fields, and forms modeling techniques. We then move on to server-side and client-side custom code extensions. Next, you will see how best to integrate Dynamics 365 in a DevOps pipeline to package and deploy your extensions to the various SDLC environments. This book also covers modern libraries and integration patterns that can be used with Dynamics 365 (Angular, 3 tiers, and many others). Finally, we end by highlighting some of the powerful extensions available. Throughout we explain a range of design patterns and techniques that can be used to enhance your code quality; the aim is that you will learn to write enterprise-scale quality code.
Table of Contents (19 chapters)
Title Page
Credits
Foreword
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Integrating with SSIS using KingswaySoft


SQL Server Integration Services (SSIS) is a great choice when building complex ongoing inter-system integrations or complex one-off data migrations. KingswaySoft offers a Microsoft Dynamics 365 Integration product that provides Dynamics 365 specific add-ons to the base SSIS toolset. KingswaySoft add-ons turn complex Dynamics 365 web services integration into high performance, easy-to-use, point-and-click configurable data integration solutions. Daniel Cai, Microsoft MVP and a personal inspiration to me becoming a business solutions MVP, is one of the masterminds behind this product.

In this recipe, we will cover a simple scenario, reading the account records from a CSV file and upserting (update or insert if the record is not found) them into Dynamics 365 with a custom-defined primary key. We will also deal with redirecting errors to a separate flat file.

Getting ready

For this recipe, you will need Visual Studio 2015 with SQL Server Data Tools (SSDT...