Overall I am very impressed with this video. It rates as very good compared to even some of the MVPs. The background noise of birds, traffic so on is very pleasant and adds interest. Adhishek is very knowledgeable about his subject matter and is very thorough explaining everything in each screen. He speaks at a pace that is perfect for me, at least. I learnt a lot from this video. a eques: would you consider creating a video that uses the Staging area option. I would like to see how a temporary table can be used and for what purpose. Given a pipeline does not stop at the temporary table-creating stage I do not understand how a human can intervene to view the table without having to put a Terminate Activity at that stage?? You can handle the Inner Join using the Power query activity or the Dataflow activity? No need to create a SQL Stored procedure for that. You should keep all your transformation processes in ADF - not split across platforms. It makes it harder and more involved(time consuming) to debug if you do. Also you are mixing codeless with coded transformations - which you should try to avoid. I appreciate there are of course, scenarios where lots of SQL has been written and you want to reuse it but consider this: rewrite that sql into codeless ADF transformation and DELETE that SQL. SQL is 20th century technology. We now have codeless tech and with the advent of AI (e.g. ChatGPT) we can, simply, write a paragraph of text and an ADF pipeline will be created (soon). We can do this already in Power Automate Flows. ADF is next. No need to use SQL ever again. I hope! Thanks for the video! I have subscribed.
Just like normal mapping in ADF mapping section, you need to map GUID column. Only additional thing required is to mention which entity GUID belongs to. For that purpose it is required to create one new mapping manually and mention schema name of table in parameter section of ADF OR store it into sql table in one column and map that field to entityschemaname@EntityReference. E.g for accountid, you will map accountid to accountid column [this is normal GUID mapping] and then you will create additional mapping- SQL Table / ADF parameter which will store schema name of account and map it to account@EntityReference [Just type this in CRM mapping] and run the pipeline. I hope this will help you:)
Great video - very easy to follow :)
Amazing Abhishek 🙌
Overall I am very impressed with this video. It rates as very good compared to even some of the MVPs. The background noise of birds, traffic so on is very pleasant and adds interest. Adhishek is very knowledgeable about his subject matter and is very thorough explaining everything in each screen. He speaks at a pace that is perfect for me, at least. I learnt a lot from this video. a eques: would you consider creating a video that uses the Staging area option. I would like to see how a temporary table can be used and for what purpose. Given a pipeline does not stop at the temporary table-creating stage I do not understand how a human can intervene to view the table without having to put a Terminate Activity at that stage??
You can handle the Inner Join using the Power query activity or the Dataflow activity? No need to create a SQL Stored procedure for that. You should keep all your transformation processes in ADF - not split across platforms. It makes it harder and more involved(time consuming) to debug if you do. Also you are mixing codeless with coded transformations - which you should try to avoid. I appreciate there are of course, scenarios where lots of SQL has been written and you want to reuse it but consider this: rewrite that sql into codeless ADF transformation and DELETE that SQL. SQL is 20th century technology. We now have codeless tech and with the advent of AI (e.g. ChatGPT) we can, simply, write a paragraph of text and an ADF pipeline will be created (soon). We can do this already in Power Automate Flows. ADF is next. No need to use SQL ever again. I hope! Thanks for the video! I have subscribed.
Really helpful
Hi,Do you know how to connect Connect Microsoft Business Central to Azure SQL Database?
@@yasangigamage4978 you can refer below link
learn.microsoft.com/en-us/answers/questions/751705/how-to-connect-business-central-to-azure-data-fact
Very well explained ! Thanks Abhishek for creating such a detailed video explaining every step, helps a lot !
Hello,
Isn't there some way for me to pass the value of the tag, for example 'Yes/No' instead of 0 and 1?
greetings from Mexico
No, If you want to migrate the data into Dynamics CRM for picklist, then you must have to add the corresponding picklist number in table
Hi
Can u explain How GUID is mapped during data migration using ADF
Just like normal mapping in ADF mapping section, you need to map GUID column. Only additional thing required is to mention which entity GUID belongs to. For that purpose it is required to create one new mapping manually and mention schema name of table in parameter section of ADF OR store it into sql table in one column and map that field to entityschemaname@EntityReference.
E.g for accountid, you will map accountid to accountid column [this is normal GUID mapping]
and then you will create additional mapping- SQL Table / ADF parameter which will store schema name of account and map it to account@EntityReference [Just type this in CRM mapping] and run the pipeline.
I hope this will help you:)