DynamicsSubs

  Wassup Guyz? Today will talk about Linking Azure Cosmos DB to Azure Synapse Analytics, and then dealing with its migrated data.  As we all know, Azure Cosmos Db had been in the market for quiet a time now. Azure Cosmos DB is a globally distributed, multi-model database service offered by Microsoft. It is designed to provide high availability, scalability, and low-latency access to data for modern applications. It is a fully managed NoSQL and relational database for modern app development, whereby you can store the humongous volume of dataset, allowing them to be easily replicated across regions/locations, in a most effective way. Essentially in a Cosmos DB, we create a Database (we call it a TodoList) and inside it the we keep Tables (called as Items), into which we can keep our records. And as you have rightly guessed, the reccords are stored in form of JSON structures, and you have provision to query the records and even create triggers/stored procs on them. Creating...

Setting up Azure Synapse Link for D365F&O could be quite tricky, and has a lot of hurdles/precursors which you need to address in order to enbale Azure Synapse Link for D365F&O. There are a number of pre-onboarding activities you need to execute, a number of setups you need to keep handy, a number of aacounts you need to setup beforehand, before you go for setting up an Azure Synapse Link For F&O. The following article tells the steps to Azure Synapse Link enablement for D365F&O, along with the various kinds of issues which might face whilee doing so, along with their resolutions. Step 1 : Create a Datalake Storage account in Azure Portal, with the following settings:  Don't forget to mark the following setting, from the advanced tab: Click Review + create >> Create to complete the wizard to create the Storage account. Step 2:   Create a new Azure Synapse Analytics Workspace, by filling out the following form from Azure portal: Click on Review + Create ...

  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 >> + ...