Joe Griffin

Information & Communications Technology

Environment and Cleantech

Manchester, England, United Kingdom

Cloud ETL with Azure Data Factory & the Common Data Service

In today’s fast-moving cloud world, it can be difficult sometimes to evaluate new solutions on the marketplace to satisfy Extract, Transform and Load (ETL) scenarios or data integration needs involving the Common Data Service (CDS). Typically, we may find ourselves returning to “safe” options such as SQL Server Integration Services (SSIS) or to look at investing in potentially expensive third-party solutions, such as Scribe Online or KingswaySoft. With version 2 of Azure Data Factory (ADF), developers now have a product available with sufficient feature parity to SSIS. In addition, ADF offers a range of additional options, such as the ability to manage your solution within Azure DevOps or seamlessly integrate with Azure functions to execute custom code. All of this, and more, can be implemented for little or no cost.

In this deep-dive session, we’ll look at how Azure Data Factory can be used to successfully migrate an on-premise instance of Dynamics 365 Customer Engagement to a cloud CDS instance. As part of this, attendees will become familiar with the process involved in deploying their first Azure Data Factory Pipeline, from start to finish. No previous experience with Azure Data Factory is required, although attendees should have some familiarity with CDS entities and how to deploy resources into Azure.

Joe Griffin

Director at SOLO Cloud Solutions Limited / Business Applications MVP

My name’s Joe Griffin, and I’m Director & Principal Consultant at SOLO Cloud Solutions. I hold various Microsoft certifications in Dynamics CRM/365 Customer Engagement, Azure, Power BI and SQL Server and am also a PRINCE2 Project Manager and Agile Practitioner. I have a broad knowledge of working with and managing projects involving Dynamics 365 Customer Engagement, Azure, Power BI, .NET and other technologies within the Microsoft cloud stack. During this time, I’ve developed a keen interest in coding, and love working with Transact-SQL, JScript, PowerShell, DAX & C#. Thanks to my previous experience, I have practical knowledge operating within the energy efficiency, managed services, retail, print & direct mail and utility sectors. I love getting involved as part of the Business Applications technical community and was very fortunate to receive the Most Valuable Professional (MVP) award from Microsoft in 2020, in recognition of my contributions in this area. When I’m not blogging or tinkering, I enjoy reading, catching up on the latest films/TVs and also enjoy learning about and studying history.

Joe's full speaker profile