You are currently browsing the category archive for the ‘Common Data Service’ category.

For the first time in Canada, Dynamics 365 Saturday will take place on May 05, 2018 at the Microsoft Meadowvale office.

As the event line-up is taking shape, it’s looking like a great set of presenters, covering a Functional Track, a Technical Track as well as an Ecosystem track with a focus on related technologies like CDS, PowerApps, Power BI.

Spots are filling up quickly, and the seats are limited. Register to reserve your seat HERE.

Note that this is a FREE event, everyone is welcome to attend.

See you all there!

Advertisements

As we’ve looked at CDS in these previous articles Creating your first Common Data Service (CDS) database and How to import .csv data into CDS, let’s bring it back home and see one way to bring data from your Dynamics 365 Customer Engagement into CDS. We’re looking at Flow now.

We can use Flow for both importing and exporting data with CDS. In addition, we can use it for both standard and custom entities. As for sources, the list of connectors is continuously growing. What does that mean? We can actually synchronize data between various application using CDS.

Note that, while we’re doing this, we’re following a typical scheduled ETL flow. This is not a synchronization service. One of the biggest differences is the fact that no deletes are supported. We can create records, update records, but have no ability to capture delete.

Read the rest of this entry »

Welcome back to this small series of posts on PowerApps and CDS.

Now that we’ve looked at how to create your first CDS database in the previous article HERE, let’s see how we can use it by loading some sample data.

We can load a sub-set of data generated using a free online service like Fake Name Generator (http://www.fakenamegenerator.com/). Go to Order in Bulk and get a set of data generated based on the setting you configure on the wizard. You can get a maximum of 50,000 records, but for the purpose of this example de default 3,000 should suffice.

Now, with the data file in hand, let’s see how we can load these records into our Contact entity. Read the rest of this entry »

Common Data Service is an Azure based service that allows you to bring data together from the Dynamics family of products, along with other external sources. It is based on the concept of having data living together in one place, where it can be served to apps created through PowerApps.

As described in this previous article, you start by creating an environment. With that in hand, you are ready to create your first database. Make sure you are an administrator in the current environment where the database is to be create, and that the correct license is assigned to you. You create the database either through the Admin center as described in the linked article, of directly from the PowerApps working console, by selecting first the environment you will work in, and then navigating to Common Data Service > Entities.

image

Read the rest of this entry »

Microsoft Business Solutions MVP

Check out my course [Video]

Getting Started with Dynamics 365 Customer Engagement

Reviewed Book

Implementing Microsoft Dynamics 365 for Finance and Operations

Implementing Microsoft Dynamics 365 for Finance and Operations

Reviewed Book

Microsoft Dynamics 365 Extensions Cookbook

Microsoft Dynamics 365 Extensions Cookbook

Check out my Book

Microsoft Dynamics CRM 2016 Customization - Second Edition

Microsoft Dynamics CRM 2016 Customization - Second Edition

Check out my Book

Microsoft Dynamics CRM Customization Essentials

Microsoft Dynamics CRM Customization Essentials

Check out my Book

Microsoft Dynamics CRM 2011 Scripting Cookbook

Microsoft Dynamics CRM 2011 Scripting Cookbook

Reviewed Book

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 484 other followers

Follow Dynamics 365 Wizardry on WordPress.com