Perhaps one of the features that makes Dynamics 365 and the Power Platform so compelling is its much-touted capability to integrate with a wide variety of data sources, regardless of where these reside. This can not only allow you to centralise all of these disparate sources into a single view but also will enable you to leverage some of the exciting capabilities within Power BI and Power Automate with minimal effort. The purpose of this talk will be to discuss, evaluate and showcase all options currently available to get your on-premise data within CDS or available for use within tools such as Power Automate. Each option has its distinct advantages and disadvantages, and the session will aim to present these and offer a suggested answer, based on the business requirement that needs to be met.