How to – Use Azure Data Factory V2 to load data into Dynamics 365


Let us take a simple example where we will set up an Azure Data Factory instance and use Copy data activity to move data from the Azure SQL database to Dynamics 365.

Login to Azure Portal.

https://portal.azure.com

Search for Data factories

Create a new data factory instance

Once the deployment is successful, click on Go to resource

Inside the data factory click on Author & Monitor

Click on Author in the left navigation

Create a new Pipeline

And drag the Copy data activity to it

Go to the Source tab, and create a new dataset.

Below is our Azure SQL database with contacts table which will be our source here.


Select Azure SQL Database as the source dataset.


Create a new linked service to specify the connection properties.


Specify the details to connect to the Azure SQL Database.


We have selected the contacts table here.


Similarly, let us define a new dataset for Sink which will connect to our Dynamics 365 Instance.



Select the Dynamics data set and specify the linked service.

Specify the details of the Dynamics 365 instance to connect to.

We have selected contact entity as the destination.

Within the Mapping tab, we can specify the fields to be mapped.

Below is how we have specified the mapping.

Click on Validate and after successful validation, click on Debug to run the pipeline.

Within the Output window, we can see the status.

After the successful run, we can see the contact records created inside Dynamics 365.

We can specify a trigger for the pipeline as shown below.

Publish All will publish the changes to the data factory.

Hope it helps..

Advertisements

Enhanced knowledge articles in Dynamics 365 – 2020 release wave 2


With 2020 release wave 1, we had new features added in Knowledge management for increased productivity

https://nishantrana.me/2020/02/19/enhancements-in-knowledge-capabilities-in-dynamics-365-customer-service-2020-release-wave-1/

Opt-in for release 2020 wave 2

https://nishantrana.me/2020/08/05/enable-early-access-2020-release-wave-2-dynamics-365/

Check other posts on Release 2020 Wave 2

Now with release 2020 wave 2, we have a few more changes added to editing and view experience related to Knowledge articles.

  • The authors can create a collapsible section

The same experience for the end-users within the case form à

  • The collapsible section option was not available in 2020 release wave 1

  • Warning message in the Preview tab, if an anchor is used, has been removed now.

With 2020 Release wave 1

  • Icons have been updated within the Knowledge search control.

In 2020 Release wave 1 ->

In 2020 Release wave 2 ->

Dynamics 365 2020 release wave 2 –https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/

Hope it helps..

Enhanced email for timeline in Dynamics 365 – 2020 release wave 2


With 2020 release wave 1, we had seen a couple of enhancements in Email experience

https://nishantrana.me/2020/02/24/enhanced-email-experience-for-agents-in-dynamics-365-customer-service-2020-release-wave-1/

now this has been extended to Email within the Timeline section

Enable early access to 2020 release wave 2

Check other posts on Release 2020 Wave 2

Navigate to App Settings in Sales Hub, and click Manage for Enhanced email for timeline

Enable it and save.

Let us now navigate to one of the contact records and try creating a new email from its Timeline control

There we can now compose email in a pop-up and non-blocking window within the context of the record.

We can now work on a maximum of 3 active draft emails at a time.

The same rich edit experience which includes Drag and Drop / Copy and paste of the images is available.

In short, all the email enhancements that were added as part of Release 2020 Wave 1 is now available from within the Timeline control for email, making it a consistent experience for the users.

Hope it helps..

Show and hide the Dynamics 365 – custom app


To show and hide the Dynamics 365 – custom app from users other than having a system administrator role, we can use the below option

Navigate to Settings – Apps

and specify either Hide / Show for all roles.



For the end-users, it will hide the app

App not listed for the user.

Users can still access the app through URL.

The same settings can be applied from the General tab of System Settings

For Dynamics 365 On-Premise, we have a similar option in the General tab of System Settings

Hope it helps..

How to – Use RetrieveTotalRecordCount function to get the total number of records in Dynamics 365


Using RetrieveTotalRecordCount Function we can get the total number of records for an entity (works for more than 50000 records)

For e.g.

https://[orgname].crm.dynamics.com/api/data/v9.1/RetrieveTotalRecordCount(EntityNames=[‘lead’,’contact’,’account’,’incident’])


https://dreamingincrm.com/2019/07/22/getting-entity-record-counts/

https://stackoverflow.com/questions/51543802/counting-all-rows-in-dynamics-crm-online-web-api-odata

https://nishantrana.me/2020/05/27/different-ways-of-getting-record-count-total-in-dynamics-365/

Hope it helps..

Advertisements

The Nigel Frank International Salary Survey 2020/21 for Microsoft Dynamics 365


The latest edition of Nigel Frank International’s Microsoft Dynamics salary survey is now live!

This will be their 12th annual report published, and has proven to be an invaluable resource to myself and my peers over the years.

I had the pleasure of contributing a foreword to the report, which set the scene in terms of where the Dynamics 365 ecosystem is now, what the future holds, and my own career journey. I can say with certainty that the ecosystem has been, and will continue to be, altered dramatically due to the Covid-19 crisis, as is the same with the technology sector as a whole.

The report uncovers a wealth of changing sentiments, along with work benefits, diversity statistics, the importance of certifications, and of course average salaries to name just a few topics covered. After reading through the results, here are my 5 main takeaways:

  • Certifications are growing in importance

The crisis has resulted in a huge increase of professionals upskilling; this is due to a combination of increased free time and job losses. Certifications are the best way to beat the competition in this increasingly difficult environment according to 61% of professionals surveyed, who believe certifications give you the edge in the job market. This along with the fact that getting certified can increase your salary by up to a reported 22% makes the decision whether to get certified or not an easy one. This was echoed by 80% of respondents who agreed Dynamics certifications were important towards increasing earning potential. Now is the time to upskill and safeguard your career!

  • The rise of working from home

The most obvious impact of Covid-19 on our working lives has been the shift from office to remote. The increase in related benefits offered such as a company laptop (73%) has followed, with 60% of respondents being offered homeworking. It will be interesting to see if this continues as restrictions across the world are beginning to ease, but it certainly seems the pandemic has changed our way of working forever. A company laptop and flexible/ remote working options have continuously been the most desired benefits when looking at past editions of the survey, so if this continues, job satisfaction will surely be boosted within the Dynamics workforce.

  • Equal rights are being championed

69% of respondents see their employers as being equal rights champions, which is hugely positive. Obviously, there is some way to go to reach the remaining 31%, however this signals change for the better across the industry. This along with 61% of employers promoting racial and ethnic diversity, and 56% hiring and retaining mature employees, is a resounding success. I hope this will continue and grow across the tech sector as a whole.

  • Increasing workload for partners

51% of employees working for Dynamics partners have seen their workload increase over the last year, and this was prior to the effects of the Coronavirus. This is a keen reflection of the digital skills gap, which will only be widening with the increased demand on cloud and digital in terms of keeping businesses and economies functioning. It is crucial that more people are encouraged into the tech sector in order to relieve the burden from these existing Dynamics professionals. This will be sure to further boost diversity within the ecosystem also.

  • Increased adoption of Dynamics 365

Since its release in November 2019, there has been an increase in take up from both new customers and existing users. 41% of end users, an 5% increase on last year’s result, are using Dynamics 365, with a further 19% expecting to use it in the future. The move to the cloud has been instrumental to this increase, and Dynamics 365 only looks to keep building momentum and customer base.

If you’d like to read the full report, and find out the average salary for your role and location, please do take a look here: https://www.nigelfrank.com/microsoft-dynamics-salary-survey/

Hope it helps..