In my last post I loaded some data from Excel into Azure Data Lake and stored it in the Common Data Model format. Now I want to present that data using Power BI.Continue reading “Visualising CDM Data with Power BI”
Last time I showed how to create a data lake, but how do you get data into it? What format should you store it in?Continue reading “Loading Data into Azure Data Lake”
In the world of data technologies, you’ll probably see data lakes appearing more and more often. I’d like to take a closer look at the Azure Data Lake and how it works with the wider Azure data ecosystem.Continue reading “Exploring the Data Lake”
Since Dynamics CRM 2013 we’ve been able to create our own APIs within the XRM framework using the Custom Action process type. Recently a new option appeared in the maker portal called Custom APIs which sounded very similar, so I thought I’d take a look.Continue reading “CDS Custom APIs”
I’ve looked at different ways of accessing CDS metadata recently, but there’s another way I’d overlooked – using FetchXML.
CDS exposes a limited amount of metadata as special virtual entities that lets you query it using standard FetchXML syntax:Continue reading “Querying Metadata with FetchXML”
I received a notification today that the preview TDS endpoint had been disabled on my environment because of a security vulnerability.Continue reading “CDS T-SQL Endpoint Vulnerability”
I’ve been studying lately for the Azure Data Engineer Associate certification, and the main point of one of the exams (DP-201 – Designing an Azure Data Solution) is all about picking the data platform(s) that best meet the requirements.
Having used SQL Server for many years it’s a simple trap to fall into to just use it for everything. It’s a very powerful tool for running complex queries and can cope with just about anything you want to throw at it, but it’s not always the best choice.Continue reading “Picking the right data technology”
One of the things that really attracts me to the D365 platform is its metadata capabilities. As an ISV we make a lot of use of this at Data8, making sure our solutions automatically adapt to the customizations that each customer has made in their own system.
There are a few different ways to access the metadata, from both the SDK and Web API. I’m going to look at the SDK options in this post – this is what you’d use in a plugin or external app.Continue reading “Retrieving Metadata in D365 / CDS”