Get Record CDS action missing attributes in Government Cloud

by Levin, Aric

Azure  Common Data Service  Flow  Government Cloud 


Posted on 1/18/2020 10:57:00 PM


While most of you might not be experiencing this issue, it is still a good workaround for a situation that you might have. Recently we had a situation that when we tried to retrieve the account record using the Get record action in our Government Cloud instance, but the results did not retrieve all the attributes. The attribute that we were really having an issue with was the address1_name.

Read More

Integrate CDS and SQL Server with Power Automate and On-Premise Data Gateway

by Levin, Aric

Azure  Common Data Service  Dynamics 365  Flow 


Posted on 1/8/2020 11:28:00 PM


In a recent blog I posted a few days ago, I posted how to use Azure Service Bus and a Listener application to integrate between the Common Data Service (Dynamics 365 or Power Apps Model Driven Application) and an On Premise SQL Service database. As mentioned that there are a few easier ways to implement this, I wanted to demonstrate how easy it would be to perform similar functionality using a Microsoft Power Automate Flow that connects to the On-Premise Data Gateway

Read More

Configure Azure Service Bus to integrate between CDS and On-Premise SQL database

by Levin, Aric

Azure  Common Data Service  Development  Dynamics 365  PowerApps  SQL 


Posted on 1/6/2020 2:17:00 AM


In this blog post I will demonstrate how to use Azure Service Bus and a Listener application to integrate between the Common Data Service (Dynamics 365 or Power Apps Model Driven Application) and an On Premise SQL Service database.

Read More

Configuring oAuth authentication for CDS

by Levin, Aric

Azure  Business Solutions  Cloud Platform  Common Data Service  Development  Dynamics 365 


Posted on 11/10/2019 9:37:00 PM


It has been quite some time since Microsoft announced the use of oAuth to connect between Server environments, but many organizations are still using username and password to connect to Dynamics 365 or the Command Data Service (CDS).

I recently had to work on a migration project, and while this customer was using legacy credentials to authenticate, they had no problems doing so with all of their environments. After they provisioned a new environment, suddenly they started receiving authentication exceptions from their data migration tool (using Kingswaysoft and SSIS).

Read More

Logic Apps and Azure On-Premise Data Gateway - Part II (Configuration)

by Levin, Aric

Azure  Business Solutions  Cloud Platform  Dynamics 365  Online Services 


Posted on 2/11/2018 8:33:00 PM


In the second part of the installation of configuration of Azure Logic Apps with the On-Premise Data Gateway, we will review the requirements that are need inside of the Azure Portal. This will cover the creation of the Data Gateway resource, the Logic app and the creation of the Trigger and Action inside of the Logic App designer.

Read More

Logic Apps and Azure On-Premise Data Gateway - Part I (Installation)

by Levin, Aric

Azure  Business Solutions  Cloud Platform  Dynamics 365 


Posted on 2/11/2018 7:45:00 PM


I recently had a requirement to configure Logic Apps for use with the Azure On-Premise Data Gateway and connection to an Oracle On-Premise database. Since I did not have access to the Oracle database at that point, I decided to try this out with an On-Premise SQL Server database as the logic should have been similar. I downloaded the Azure On-Premise Data Gateway and installed it on the server, and the configured the Azure environment to connect to the server and post data back to Dynamics 365. This post will be split into 2. The first is the installation of the Azure On-Premise Data Gateway, and the second is the configuration in Microsoft Azure, creating the connection, Logic App and setting the trigger and action.

Read More