Injest D365F&O into Azure Synapse Analytics, using no code Pipelines and Linked datasets
Azure Synapse Analtycs is amazing and has so many hidden gems. This blog deals with one such awesome features that can help you to bring data from any source and can take it to any data sink/destination. We will be fetching data from D365F&O and will be taking it to Azure blob, using pipelines, without writing a single line of code. To do this, please follow the following steps: a. Keep your Azure Azure app registrations details ready. Don't forget to register your App to your Entra ID, and give appropriate API permissions >> Grant admin consent for Dynamics ERP. b. Create a new Azure Synapse Analytics Workspace, by filling out the following form from Azure portal: Click on Review + Create >> Create to conclude the worksapce creation. Please do select appropriate Region. It will take some time for completing the deployment. Once done, click on View Studio, which will take you to Synapse Analytics Studio. c. Click on Data >> Linked Tab >> + ...