by The CRM Chap | Nov 29, 2020 | Analytics, Databases, Microsoft Azure
Getting your head around Azure Synapse Analytics can be challenging, even for the most seasoned SQL Server professional. With that in mind, this blog post will jump into the two concepts that you need to understand - table distribution and index types.
by The CRM Chap | Jun 21, 2020 | Analytics, Customer Engagement, Dynamics 365, Enterprise, Microsoft Azure, Microsoft Dataverse, Power Platform, SQL Server, Transact-SQL (T-SQL)
Azure Data Factory (ADF) remains a massive area for me, and within the projects I'm involved in. Previously, those looking to use ADF to map into Owner or Customer fields in the Common Data Service may have hit a few issues. Thankfully, this is now all in the past.
by The CRM Chap | Feb 23, 2020 | Analytics, Customer Engagement, Dynamics 365, Enterprise, Identity, Microsoft Azure, Sales, Service
The Dynamics 365 / Common Data Service Web API allows developers to leverage a wide variety of functionality, from almost any conceivable location - such as, for example, an Azure Data Factory V2 pipeline. With this in mind, let’s dive in and see how to achieve this.
by The CRM Chap | Feb 2, 2020 | Analytics, Microsoft Azure, Power Apps, Power Automate, Power BI, Power Platform, Web
Complex integration pieces that involve on-premise systems can be difficult to scope out and implement. One of the benefits of working with the Microsoft cloud is that there are multiple tools available to help us in this regard. Figuring out the correct one to use, though, can be a challenge…
by The CRM Chap | Nov 3, 2019 | Analytics, Compute, Databases, DevOps, Identity, Integration, Microsoft Azure, PowerShell, Security, Web
A few weeks ago, I did a post on the process involved when migrating Microsoft Azure Cloud Solutions Provider (CSP) subscriptions across tenants. Having done some actual work relating to this since then (shock horror!), I thought I'd follow up with a new post, sharing some additional thoughts and lessons learned.
by The CRM Chap | Oct 6, 2019 | Analytics, Databases, DevOps, Microsoft Azure, SQL Server
One of the best things about Azure Data Factory is its ability to incorporate continuous integration and automated deployments quickly alongside your solution. However, if you’re working with SQL Server data sources and are using square brackets to interact with tables, then you may be in for a bumpy ride…
by The CRM Chap | Jul 14, 2019 | Analytics, Databases, Microsoft Azure, SQL Server, Transact-SQL (T-SQL)
When you are amid a pesky IT issue, it can be difficult determining whether the problem is down to a bug/system fault or human error. Like this recent example involving Azure Data Factory illustrates, it is generally best to assume the latter, to avoid any prolonged difficulty.
by The CRM Chap | Jun 2, 2019 | Analytics, Customer Engagement, Dynamics 365, Microsoft Azure, Microsoft Dataverse, Power Automate, Power Platform
The Dynamics 365 Customer Engagement/Common Data Service connector for Azure Data Factory can, in most cases, fit into your data integration needs. However, it is worth highlighting the two field types which are, specifically, not supported; namely, the Customer and Owner field types.
by The CRM Chap | May 26, 2019 | Analytics, Customer Engagement, Dynamics 365, Dynamics CRM, Microsoft Azure, Sales, Service
By default, the Dynamics 365 Customer Engagement connector for Azure Data Factory V2 exposes a predefined list of fields, that must have data mapped to them for any Copy Data task to complete successfully. This behaviour can be impractical depending on your particular scenario; fortunately, there is a way in which you can override this.
by The CRM Chap | May 12, 2019 | 2015, 2016, Analytics, Customer Engagement, Dynamics 365, Dynamics CRM, Enterprise, Microsoft Azure, Sales, Service
Azure Data Factory V2 not just has 1, but three separate connectors that all claim to hook up to Dynamics 365 Customer Engagement/Dynamics CRM! So which connector is the "right" one to use and what differences do they have? With a little help from Alan Partridge, we can clear up any confusion...
Recent Comments