Picking the right data technology

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”

Retrieving Metadata in D365 / CDS

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”

SQL 4 CDS 2.3.0 Released!

I’m pleased to release the latest update for SQL 4 CDS today! For this update I’ve focused on common problems I’ve seen people encounter with their queries from my telemetry. These updates should either mean that more queries can be executed immediately, or the error message is more descriptive to help solve common errors.

Continue reading “SQL 4 CDS 2.3.0 Released!”

MSDyn365 Internals: Async Record Merging

Matt Beard & I spent some time investigating the new asynchronous merging functionality today and how it impacts Data8 Duplicare (it doesn’t, Duplicare continues to work as normal). If you haven’t seen this already, when you merge two records you’ll now see the message:

The selected records will be merged in the background while you work. For additional information, see Asynchronous Processing of Cascading Transactions.
Continue reading “MSDyn365 Internals: Async Record Merging”

MSDyn365 Internals: T-SQL Endpoint

Disclaimer: the details in this post are based on the best guesses I’ve been able to make about how this works, which are derived from the behaviour I’ve seen while using it. I don’t have any official information on any of this, so use at your own risk!

Continue reading “MSDyn365 Internals: T-SQL Endpoint”

PCF Dataset Control – Lookup Values

After getting over my initial authentication problems, my next adventure with PCF was to show some details from a lookup field in a dataset-bound control.

With a dataset control, the manifest file can contain mappings for the attributes in the dataset that will be shown in the control, e.g.

Continue reading “PCF Dataset Control – Lookup Values”