Aggregate function in Azure Data factory
This post is about using Aggregate function in ADF. Most of us are aware about using Group by in Aggregate. But we will be facing the issue of…
Anitha Santosh
165
Posts
41,553
Views
Batch job not executing – Ax2012
Batch jobs can create a problem when the database is restored or refreshed from one environment to other environment. Given below the trouble shooting steps and solution to…
Connect D365 to Azure DB – Azure Data factory
In this post, I will explain about copying data from CRM to Azure DB . This is done by using COPY DATA TOOL available in Azure Data Factory.…
Create Azure Data Factory
Given below simple way with screenshots to create a new Azure Data Factory(ADF) from azure portal. Go to portal.azure.com. Select Data factory from Search bar. Follow the steps…
The database is in single-user mode, and a user is currently connected to it.
I had this issue when I tried to swap the databases after bacpac restore. “Could not rename the database ‘DbName’. The database is in single-user mode, and a…
Call FO Runnable classes with dynamic parameter from URL – D365FO
We are already familiar with calling D365FO URL menu items or forms or Runnable class. To recap, I am giving few samples below To call Display menu item…
Date Transformations in Derived column – Azure Data Factory
In my Azure Data Factory journey, everyday is a new learning. Defaulting date to current date is common. I had to requirement to default the date to last…
Data Factory integration with D365FO – Import
In this post, I am going to explain about the import of CustGroup using ADF to D365FO. There are many ways to import data, here I chose OData…
Filter expression in Azure Data Factory
If you are working on a bulk data, there is always a need to focus only on a particular set of data. We bring this filter in D365FO…
Default a field value in SQL Server
We initialise a field`s value in D365FO / Ax2012 …. (I am saying this as an example since I am from Technical Ax background ) . Similarly, we…