Announcements
Regarding on-premises data gateway:
https://docs.microsoft.com/en-us/power-automate/gateway-reference
Is it possible to connect this to an entity, for e.g. Accounts, in Microsoft dynamics Online (customer engagement)?
Is your CRM online or on-premises? CDS is only in the online environment so even using an on-premises gateway you won;t be able to connect to an account entity in CRM on-premises. You can connect to the CRM database using the on-premises gateway to access CRM data, but you'll be connecting to SQL, not the Account Entity.
it´s regarding crm online.
Then I'm not clear on what you are asking. If its CRM online then where does an on-premises gateway come in? On-premises gateways are only used to connect Power Apps to on-premises data sources. Could you clarify your question?
OK sure I will try to explain better.
My client is using Mcrosoft Dynamics CE online. They have a few entities (for e.g. Accounts) which contain sensitive information. Because of this, my client wants to keep this information in a local SQL server in the same city their business is located.
So i´m looking for a way so they can continue using their Dynamics CE online instance, but in some way store the sensitive information locally.
It would be very possible to sync the sensitive information locally, but there is no way to make CRM online use that local copy. A copy of the data would need to stay in the CRM online CDS instance for CRM to work. I don't think that is what your client is trying to achieve.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 223
