Skip to content

Posts by Mehmet Ozdemir

Code Free Dynamics 365 Configuration Values

Dynamics 365 Configuration Values In many systems, there will be a need to store key/value pairs for configuration data. Examples of this might be contact email address for an email template or a link to a payment gateway etc. To further complicate things we have development, test and production environments. What will be a valid…

Read More

Converting a CRM Workflow to an Action

Actions have been around for a while now and they’re a great addition to the CRM developers toolkit. But what about when you revisit an existing workflow and think, wouldn’t it be great if I could convert this guy to an action and then either call it from JavaScript or if using CRM 2016 or above use a…

Read More

CRM 2016 On-Premise to SharePoint Online Gotcha’s

CRM 2016 On-Premise to SharePoint Online Recently, I was asked to setup server-based authentication from Dynamics CRM 2016 to SharePoint Online. Step 1, read through the TechNet article and make sure all the prerequisite stuff was complete on the CRM installation. Microsoft Dynamics CRM System Administrator security role. This is required to run the Enable Server-based SharePoint…

Read More

Reporting Services migration made easy with ReportSync

Recently I was given a task to move a custom application developed on top of SQL Server 2005 to SQL Server 2014 (yes a big jump!). One of the tasks was to move the reports over to the new server. The server was already built and an empty reporting services instance was available. I needed a way…

Read More

TSQL pattern matching as part of a table join

OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:

To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning the LastName and FirstName and…

Read More

Connecting the CRM Email Router to a CRM Online deployment

Here’s a quick tip for connecting the CRM Email Router to a CRM Online Deployment. If you’re following along with the documentation from Microsoft: Microsoft Dynamics CRM Email Router Installing Guide for use with Microsoft Dynamics CRM Online The section that describes connecting to a CRM Online deployment states: If you are connecting to Microsoft…

Read More