After several recent updates to Dataverse I’m excited to release SQL 4 CDS 5.2 to take full advantage of the new platform features, along with several UI and query handling improvements.
Bypassing plugins in Dataverse: faster, simpler data imports
Data migration can be one of the most time consuming parts of deploying a new CRM system, and all that complex business logic in your shiny new plugins just complicates matters. At best they just slow down the import, or worse they change your historical data according to your latest Continue Reading
Improving bulk Dataverse performance with EnableAffinityCookie
A few months ago I investigated how using multi threading and batching requests can be used to improve the performance of Dataverse integrations. In the latest release of the Dataverse tooling we’ve now got another option to use – EnableAffinityCookie. Let’s have a look at how that can help too.
Date/Time handling in SQL 4 CDS
The ways different datetime columns in Dataverse/D365 behave across timezones is already the subject of plenty of blog articles. In this one I’d like to clarify how they work in SQL 4 CDS. Please pay particular attention to this if you’re updating any datetime values!
SQL 4 CDS 5.1 Released
This is mainly a bug fix release based on reports from users (thank you!) and telemetry. If you’ve hit problems running queries with SQL 4 CDS v5, please update to v5.1 and try again. If your query still doesn’t work, please let me know! You can put details of any Continue Reading
SQL 4 CDS v5 Released
I’m really pleased to announce this major update to SQL 4 CDS! This is a complete overhaul of the engine that converts your SQL into something that Dataverse/CRM can understand, and means you can now run a much broader set of queries than ever before.
Querying Virtual Entities
Virtual entities are a great way of exposing external data sources in Dataverse, and with the recent release of create/update/delete support I’m sure they’re about to become much more widely adopted. Your data immediately becomes available for your apps and appears no differently to your users than any other entity. Continue Reading
Custom Action to Custom API Converter Tool Released!
I’ve just released my latest XrmToolBox tool – Custom Action to Custom API Converter!
Create/Update/Delete Virtual Entities
It’s finally here! We can now use standard Create/Update/Delete operations with virtual entities! There’s a great example to get started over at the Microsoft docs site.
SQL 4 CDS 4.1.0 Released
I’ve quietly been releasing minor updates to SQL 4 CDS over the past few weeks, so I thought it was time to do a blog post for an “update roll up”