Azure Data Factory Tutorial | Introduction to ETL in Azure

[@AdamMarczakYT]

Please note that after recent UI changes in Azure You can find Linked Services under Manage tab in the Data Factory portal 😊

[@mohammedashfaq3892]

Great explanation, thanks for this note i was wondering where exactly the linked services was. This makes clear to me. Appreciate.

[@AdamMarczakYT]

Thanks! While I can’t recreate all the content whenever Microsoft decides to make minor UI changes I can surely let you know in the comments :) For major changes or new version of the services we will still get updated videos :)

[@sunnybruno8530]

Hi Adam, please where exactly can I find the managed tab, so as to get to the linked services?

[@rodrickedwards2759]

@@sunnybruno8530 The manage tab on the left nav. Probably the last icon for you.

[@lattejia]

Adam, you have no idea how this is very helpful to me. Especially that I'm in a new project that has to work with everything about Azure. I used to study in Microsoft website for the Data Engineering certifications and all of these terms are very new to me that I'm losing hope with being able to understand it fully. I'm so glad that I stumbled upon your channel in hopes of understanding all of this and you're the only one I watch when I need help. All your videos have helped me even get a promotion at work. I thank you from the deepest bottom of my heart and I hope you continue making this! I support you with all my might! (Sorry for my bad english)

[@AdamMarczakYT]

This is fantastic read. This is the reason why I created this channel, thank you!

[@RithDil]

Yeah, for me too. I'm so glad to see this video. Thanks Adam

[@blaaarrghh]

Well this was one of the best introduction videos I've seen. Not too compilicated, not too fast.

[@AdamMarczakYT]

Glad you think so! Thanks!

[@fahadaijaz4]

This is the probably the best tutorial presentation I've ever seen.

[@AdamMarczakYT]

Thank you :)

[@solomonyasharahla8603]

lol facts

[@na_ira_]

I was so scared about starting Azure topics. This is making my life so easy. Perfect explanations with great presentations. The examples make it easy to retain. Thank you!

[@pat_mueller]

how about today bro?

[@na_ira_]

@@pat_mueller I hate azure

[@rajdeepmandal1470]

My confusion was the workflow, what to do after what. You just saved my life, looking at the comment section it seems you saved lives of many like me, I am big fan of you now. This is the video I will suggest if anybody wants to learn ADF. Thank you

[@AdamMarczakYT]

Glad it helped!

[@sankaranarayanans8814]

I didn't get sleep while watching this video. Clear explanation with a perfect scenario ... Keep it up bro.. :-)

[@AdamMarczakYT]

Thanks! Comments like this only make me want to do more!

[@mohammedashfaq3892]

Agreed bro, I got a new project which involve data factory and ETL assignments.

[@langtonkadzere5737]

This was more than a University Degree. Clearly illustrated and explained. Thank you Adam.

[@EdwinVeenboer]

i am doing DP-203 at the moment and was really struggling with this. Thank you for clearing things up. You're a great teacher!

[@kal_jorEl]

I can't thank you enough for giving this tutorial. Absolutely fantastic. The Analogy makes so much sense and your presentation is also very good. Subscribed.

[@AdamMarczakYT]

Awesome! Cheers! Glad my content is of help to you! :)

[@dgh25]

Amazing how Microsoft couldn't do a simple explanation of this. Their documentation is retarded. Always the same with Microsoft - totally useless when it comes to explanation and documentation.

[@nicholasgregory4774]

This tutorial is EXACTLY what I was looking for. Subscribed to your channel 7 minutes in. Thank you for the time and effort you're putting into these tutorials. Bookmarked an additional 3 videos to watch after this.

[@AdamMarczakYT]

Awesome, thank you! :)

[@LunjunMou]

This is a concise and right to the point DEMO for Data Factory! We are just about to start our AZURE Journey and this is definitely a good start point! Thank you very much Adam!

[@MichalPCode]

That diagram at the start was fantastic! Very clear and explaining everything! Dzięki wielkie!

[@AdamMarczakYT]

Glad it helped! Dziękuje!

[@jigar121212]

I can;t believe - I learned so much in less than 25 minutes. No BS, no time waste - to the point explanation.

[@AdamMarczakYT]

That is superb! Glad you enjoyed it.

[@sreenijatumuluri7890]

Thanks a lot for such clear explanation, completed all ADF videos in one go! You got a new subscriber, glad I discovered this content.

[@AdamMarczakYT]

Welcome aboard! Thanks!

[@davidpile2576]

Good intro. You nearly lost me when I saw moving a filing cabinet from the shop to home. Only all the positive comments got me to sit through that. Glad I did

[@AdamMarczakYT]

Haha, I get you. It's a little far fetched example to simplify responsibilities of each component of ADF, but many people appreciated it :)

[@jahanviMath6452]

Very well explained. I have passed azure fundamentals by watching your AZ 900 Episodes. Thank you so much for all your work 🙏🙏 now watching to clear data engineering 🙏

[@AdamMarczakYT]

Fantastic, congrats!

[@SajjadKhanTech]

While I am in airport waiting for my flight , I able to do this exercise successfully in 30 mins .. It was possible because Adam videos was directly to the point Thanks adam

[@Stinkys8050]

Wow, this is precisely what I was looking for. Thanks for this great tutorial.

[@AdamMarczakYT]

Glad it was helpful!

[@chandramandava3345]

One of the best videos on Azure Data Factory on KZbin..

[@AdamMarczakYT]

Wow, thanks!

[@pramodnithan8859]

Great Explanation. Perfect tutorial for Beginners. Thank you for the efforts. Appreciable :)

[@AdamMarczakYT]

You're very welcome! Thanks :)

[@puttarinkesh8535]

Just Wowwwww... Best video on ADF Even a paid teacher cannot deliver the content we get in this video. Thank you so much Adam

[@dks82]

very well articulated with great scenario!! Adam's way :)

[@AdamMarczakYT]

Thank you :)

[@swenmeinert3967]

Best job. The explanations from Microsoft cannot clear up anything to me. This one is the eyeopener I was looking for.

[@AdamMarczakYT]

Thank you Swen! :)

[@jsonify]

I absolutely love your tutorials. So very informative. Is there any chance you might do a tutorial on converting an AVRO file that was stored in a Data Lake, to a CSV that can be stored in the SQL DB? This seems like it should be a pretty straight forward out-of-the-box solution, but the AVRO body looks like it needs to be decoded in Data Factory first. Thank you!

[@raven-888]

You are a legend. your 2 minute visualization explained things that I couldn't understand event after spending hours on tutorials and documentation.

[@michalhutny7356]

Great work Adam! I'm waiting on second part of Azure Data Factory, but this time with SSIS packages usage :)

[@AdamMarczakYT]

I might in future just to cover entire ADF scope of features but I have some strong opinions on SSIS. I just personally think there are much better options available in the cloud instead of SSIS. I only use SSIS if I do 'lift-up' from existing solutions, I never use it for new projects. Thanks for watching and commenting!

[@matthewgoss883]

Adam Marczak - Azure for Everyone - Could you share an overview of options for those of us rooted in SSIS?

[@amansingh9097]

so far it's the best explanation I have found on youtube. Also great use of example, and really liked how you broke the entire flow component by component through the example.

[@prasmitdevkota4251]

Watched the whole thing without a second skipped. You got a new subscriber

[@SkorpioX94]

5:41 I genuinely thought you were just plucking a guid out of your head! Another great video, thanks so much for this!

[@ABRARKHAN-tp7sl]

Clear explanation in simple way...Even non technical background persons can understand.

[@AdamMarczakYT]

Awesome, thank you!

[@gunturulaxmi8037]

Hey really wonderful.i have done Az-900 certification successfully by watching all the concepto explainwd by you.i am much interested to do datafactory and I do not know how hands on , in Azure. But your videos helped me alot to get a confidente on that.Thanks alot.really appreciate it.

[@mikitaarabei]

God Bless that such tutorials exist on internet

[@commanderraccoon]

Clearly explained without making it too detailed for an Intro video. Thank you so much! :)

[@AdamMarczakYT]

My pleasure! :)

[@ugandar123]

I like the way you are explaining. It's detailed and clear. Whenever people post any questions in our Azure whatsapp groups I always refer your videos. Thanks for all your efforts...

[@AdamMarczakYT]

It's my pleasure, thanks for helping me grow, more cool videos are coming! Plans are grand!

[@joyaljjoy]

For someone who never used azure, I got the basic understanding of it.

[@odiapeter9165]

Great analogy and demo! As a project manager involved in data integration projects, I find this video valuable.

[@ryanfisher5835]

The best explanation of Azure Data Factory I’ve ever come across. Thanks for this!

[@AdamMarczakYT]

Cheers Ryan! :) Thanks for watching :)

[@maheshkumarsomalinga1455]

Hi Adam, I am very new to ADF. This video is very clear and crisp to understand a basic pipeline in ADF...Great stuff ! Appreciate it and thanks for posting it...

[@AdamMarczakYT]

My pleasure!

[@niyatiagrawal676]

Superbbb Video. I have been searching for this kind of easy video from so many days. Very short and crisp.

[@AdamMarczakYT]

Glad you liked it

[@yedlakrishnabharat4821]

These are the best videos on Azure Data Factory. The presentation is so neat, clean and easily understandable. Thanks, Adam

[@AdamMarczakYT]

Thanks man!:D

[@empowerpeoplebytech2347]

Fantastic. I just started my Azure journey with data factory while watching this video. Thank you very much!

[@AdamMarczakYT]

Glad it was helpful!

[@kaniShruthi]

without any second thought, best video to understand what is ADF for beginners. Great job!!

[@nautyrider]

I like the correlation between real-life scenarios and how its related to ADF. Thanks for the video, it helps to clear down the ADF jargons.

[@AdamMarczakYT]

Glad it was helpful!

[@TheRealWhatsUpJua]

These videos have really become my go to while studying for my next cert as well as a refresher for everyday tasks at work and visualizing the data to come up with solutions for our clients. Thank you!

[@loshyourik]

I'm totally new into data management in Azure and I'm amazed cool explanation + slides + a demo from scratch thanks a lot!

[@AdamMarczakYT]

You're very welcome!

[@icici321]

Excellent tutorial on Azure data factory. Could not stop watching till the end. Very nicely explained. Thanks very much.

[@AdamMarczakYT]

Superb! Thanks for watching!

[@amitaggarwal3678]

Seriously i need to prepare a presentation on azure data factory on very short notice and I am glad that I found this video. Must recommend !!! You just need to know basics of azure rest this video will teach you about Az data factory.

[@AdamMarczakYT]

Amazing! Thank you :)

[@ogryzeq]

This is my first video from you and I am already a fan.

[@AdamMarczakYT]

Awesome, welcome aboard!

[@e2ndcomingsoon655]

Great tutorial, stopped working with ADF for some time and I happened to forget, this really made me remember it clearly! Thank you! Great video!

[@akinja-earlrichards2543]

Very relatable and easy to understand. Great work Adam. Keep it up.

[@AdamMarczakYT]

Thanks, will do!

[@venkatkurimimdla3360]

Really Amazing !!!!The way you explained it was simply WOW!!!!! Thanks Adammmm

[@AdamMarczakYT]

My pleasure!

[@awwalhameed6711]

This is the best video I've seen on this topic. Your diagram help to explain everything in detail. I would love to connect with you for further lessons.

[@TheRetroEngine]

Properly well explained and easy to follow. I'm a GCP Cloud Architect but have an Azure project coming up, so I'm reading up on Azure Data Factory. This was BRILLIANT! Thanks for doing it!!

[@chandramohannara9076]

Super clarity..step by step detailed explanation..best content on azure so far..keep up great job..thanks for all your hard work!!!

[@AdamMarczakYT]

Thank you so much :)

[@anilkumarjuluri8236]

Till Today i was very much confused with the ADF, Watching your Video and the Way to explained is really fantastic and now I'm much confident in moving data from Source to Destination. Thanks alot Adam. Much Appreciated.

[@AdamMarczakYT]

You are most welcome, thanks! :)

[@priyankagupta119]

You are amazing in delivery any content in the simplest way. I liked your videos.

[@Info-Galaxy]

Thank you Adam, it helped me a lot to start with Azure Data Factory. Became fan of your channel.

[@arulmouzhiezhilarasan8518]

Thanks Adam, I am new to ADF. This is great video to learn reg ADF. Explanation with one simple example and teaching stuffs in clear and easy way, makes everyone to understand stuffs easily and never forgot ADF.

[@AdamMarczakYT]

Great to hear!

[@roselinetulypalma4380]

I have seen several videos here. All videos seems very helpful and very clear and conceptual. Thank you :)

[@600Alfi]

Witam Adam, hands down, one of the best explained videos on azure services i have seen, with a real world example and also some way to visualize/conceptualize new terms and functions within Azure. perfect amount of info for an introductory video, with results!

[@danielpillay4972]

Brilliant, started working with Azure Factory and this video is very helpful.

[@AdamMarczakYT]

Great to hear!

[@navin8437]

This video helped me understand Azure Data factory more than all of Microsoft's articles combined. Thank You..

[@AdamMarczakYT]

Glad it helped!

[@Tharun459]

Well.. This is Fantastic.. Any beginner who's interested in Azure Data Factory can't ask for more. Thank you so much Adam.. !! :)

[@AdamMarczakYT]

My pleasure! :)

[@AjayGupta-fj6io]

Great Job Adam !!!! Correlation between cabinet example and ADF made it easy to understand. Keep it up.

[@AdamMarczakYT]

Thanks, will do!

[@surajchaudhary58]

Thanks a lot, Adam for Clearing my all doubts! I love to see more related videos of you!

[@soucianceeqdamrashti8175]

Good introductory tutorial! Keep up the good work Adam!

[@fadiabusafat5162]

Cheers Adam. Amazing Tutorial. Keep moving on and please always made familiar with your tutorials.

[@The_Bold_Statement]

Excellent explaination, underrated youtube playlist for ADF

[@sphnyhptrs]

Great video. Concise and Clear! You have a true gift to teach.

[@AdamMarczakYT]

I appreciate that!

[@sazidaanjumsheikh6817]

Perfect Adam... this is so helpful to me. everytime I watch your video I learn more and more..

[@ihebbibani7122]

Very well Explained , you deserve a subscription which is already .Excellent Work ! Excellent Voice ! Excellent Pedagogy ! You can really be happy as I never mince my words :)

[@AdamMarczakYT]

Welcome aboard! I appreciate the support :)

[@1066sgp]

This really changes things for me and my Team. We have outgrown Sharepoint and Excel and this will help us the the data side of our full stack development project.

[@tanishadas23]

This is a perfect tutorial, Adam. I absolutely love your smooth explanations. Thank You!!🌻

[@RamaKrishna-jh7vg]

Your explanation is Awesome Adam. Really it helps us to get more & more insights on the Azure related tools. Really appreciate with the work you are doing. (Y)

[@AdamMarczakYT]

Glad it was helpful!

[@khumgee100]

I saw a lot of Videos and this is the perfect explanation with the help of example diagram and scenarios. Thumps up for great work.

[@AdamMarczakYT]

Awesome, thank you!

[@thexxmaster]

Great video - really clear and the narrative structure makes it logical to follow. Thanks

[@satori8626]

Amazing video, with the the perfect combination of explanations and demos, by far the best I have been able to find on the topic. And I appreciate that you made the simplest possible example to demonstrate the concept.

[@ModyKhan]

Excellent demo. Very well explained. Thank you Adam!!!

[@AdamMarczakYT]

My pleasure!

[@fabriciocorporative245]

Excellent job, Adam! Great explanation and lab. I could understand it completely. Please, keep doing this videos! Many thanks :D

[@AdamMarczakYT]

Thanks, will do!

[@gurjitsingh9054]

Excellent mate ! you made ADF so simple to learn.

[@canadafamily1897]

Thank you for crystal clear explanations. The whole video was well laid out! Please keep up your good work.

[@AdamMarczakYT]

Thank you! Will do!

[@kimp2002]

Great content Adam! Very easy to follow, just what I was looking for to get a basic understanding of Azure Data Factory. Thanks!

[@AdamMarczakYT]

Great to hear! Thanks for watching and commenting Kim :)

[@khushwantnegi4011]

I like the way you describe it, easy to understand difficult to forget.. thumbs up

[@AdamMarczakYT]

Thank you! :)

[@AArora81]

Really good introduction! Quick and effective. Well done and thank you for sharing.

[@AdamMarczakYT]

Glad it was helpful!

[@AArora81]

@@AdamMarczakYT could you please advice on the best practice for handling date data. For example, presently I'm using the similar example as you have taken in this video with addition of few date columns. The pipeline fails since my target columns are of date type in SQL database (mapped from the date values in the source csv). I presume some kind of specifiers/transformation would be needed for the same but not quite sure presently. Could you point out if possible?

[@charlesdelanoy]

Thanks Adam, great video. I went through the steps and it's all working. The Azure screens and the process has slightly changed through, e.g. Data Flows which was in preview is now mainstream...etc.

[@AdamMarczakYT]

Thanks Charles, I wouldn't say that Data Flows are mainstream now but they are surely more popular than before. I do have small tutorial on them too :) Thanks for watching :)

[@PowerWithInYou555]

Thanks alot sir....i was searching something like this...to gain some basic knowledge...but your video has provided clear picture of whole functionality of ETL.....please keep posting your knowledge :)

[@AdamMarczakYT]

You are most welcome :)

[@omotayoogunnika6865]

This video helped me to carry out my first data integration project, thanks Adam

[@greenshadowooo]

A very detail introduction!! Really appreciate your effectiveness and effort.👍👍👍

[@supriyo.0921]

This is absolutely the most simple tutorial that I've seen around this topic! Awesome job! Subscribing to the channel.

[@jimmarlow1424]

Yeah, pretty intuitive. Longtime SSIS user here but am starting to warm up to ADF. Good job on the tutorial, very informative.

[@AdamMarczakYT]

Thank you! Come for one, stay for more!

[@prashanthnayak6668]

Thanks and that was a real quick introduction to how it all really works. Since I have been using Informatica Powercenter ETL for quiet sometime now, I could instantly relate..🙂

[@arunchenchu]

Explanation is very nice and it makes understand the topics very well....thanks a lot Adam...

[@AdamMarczakYT]

Glad to hear that! :)

[@navneethparthasarathy8395]

Hope you come up with some courses for Azure Exams. That will be really helpful to the community of Azure learners . This video was fantastic

[@subirdutta6701]

Amazing Adam. One of the best tutorial. A perfect explanation with practical . Thanks a lot. :-)

[@AdamMarczakYT]

Glad you liked it!

[@ITCLOUD13]

TOP TOP TOP .. always the best and simple explanation of concept azure..👍🏻👍🏻👍🏻👍🏻👍🏻

[@AdamMarczakYT]

Thanks a ton :)

[@kavitas8127]

Very well explained. Thanks Adam. I am gonna watch your other videos too to get more clarity on other Azure services.

[@AdamMarczakYT]

Awesome, thank you!

[@shivadarjani6990]

Perfect and clear tutorial! Thanks Adam!

[@AdamMarczakYT]

Glad it was helpful!

[@Mark01962]

I have to pull a db from Atlassian Enterprise Insights into Azure and this at the very least, points me in the right direction. As always ... thank you very much

[@anassawaf9935]

You are simply the best Adam. Very well appreciated. Great knowledge and approach.