Really Thank you so much!.... For ADF beginners should watch these videos. Then they can explore further by their own. These videos are great foundation to learn and work in ADF platform. Appreciated your efforts, dedication and patience
In Every Demo, you are opening the portal again and again, you just keep it open and already login, and so that it will save little time of logging, just my sincere advice.
Another great video..I am using this after 4 years 😂. I have a question.. is it possible to parameterize linked service for Authentication Type ->System Assigned Managed Identity ? If yes, how to do it. My database is Azure SQL DBA.. and for my linked service I need to use this authentication type,. I can't use SQL authentication due to firewall restriction.. I am not sure how to create managed private end point using system assigned managed identity
Hi sir, very helpful videos u r making, just one question on how to pass parameters dynamically in pipeline to linked service. For example in foreach we have 5 server url and if we create copy activity in every loop. How will we pass the serve url to linked service for rest api call to different servers.
Hi, can you please guide me on how we can create parameterized linked services for file system? We have 3 different folders in the file system as per the environment - dev, uat and prod.
Hi Basheer, first of all thank you so much for the very informative video series. Just wanted to highlight that in this video you've kept the IR to be Azure and in the later videos you've taken the SQL server example (on-prem). Do we need to have the IR to be Self-Hosted for better understanding in this video?
Hi ; ), Is it possible to parameterize the Linked Service where values are stored in a out source Table ? For instance access the value in the table via the Lookup then strore the value in a variable and then put it into the Linked Service ?
hi @WafaStudies, can you please recommend to me any video that is there for dynamically setting the env variable. e.g I have created a workflow and there is an HTTP call, the endpoint URL is hardcoded and pointed to QA tes1 env, same workflow if I want to test for QA test2 then I am changing manually how to set it dynamically. I am new to azure logic Apps so trying to achieve environment profiling how works. Thanks !!
@wafastudies Can we change one type of linked service to another, I mean IF a linked service is created on SQL Server Database , can i change it to SQL Managed Instance
Hello @wafaStudies Is there any possibility that, can we do On-prem Oracle DB(prod) to On-prem Oracle DB(UAT) (need to add some data) copy data using ADF? If yes How??
Hey, I like ur Videos, Got question , 1. Lets say I installed self-hosted IR for ADF-1 now on my local machine. 2. Later I decided to remove this ADF-1 from my subscription for some reason 3. Now , I see that "IR installed on my local " is no where useful as this completely tied up with my ADF-1 keys , right? 4. Lets say now I created another ADF-2 for integration job to copy my on-prem local data to Azure may be Blob, SQL server whatever 5. It seems I need to remove and re-install my previous IR and register again with DF-2 keys , AM I Right? OR Any work around is there? Thanks
Hi Maheer, If I'm giving Windows authentication I'm not getting Create option ... My Local SQL SERVER DB is Windows Authenticated no need of giving credentials to login is the same for Azure linked service also
He saved our money with his teaching!! I am gonna share his videos in my social networks #linkedin
Thank you 🙂
Thank you so much for providing this much detailed content free of cost. Keep making videos.
Thank you ☺️
Really Thank you so much!.... For ADF beginners should watch these videos. Then they can explore further by their own. These videos are great foundation to learn and work in ADF platform. Appreciated your efforts, dedication and patience
Thank you ☺️
one of the first videos covering full module on ADF. Good job.
Thank you 🙂
Would u mind adding some videos on Usql,notebook, python etc. Simple demos will be fine
You are Excellent Bro...Your focus and patience in explaining concepts great!!!
Thank you for kind words 🙂
Just mind blowing explanation about the fundamentals of Parameterizing Linked Services. Thank You
Thank you ☺️
Thanks for the content. Whole series is awesome.
Thank you 🙂
you are really a gem brother. keep up the good work. The content is awesome
Thank you ☺️
Thank you ☺️
Bravo keep It up!! You teched the world
Thank you 😊
What great lessons of here !!! Thank bro
Thank you 🙂
Excellent Video Tutorial Bro.... Thanks for the Content... Please keep Going ...
excellent video
Hi brother, Your concepts are awesome and useful indeed..Thanks for valuable content..!!
Thank you for your kind words.
@@WafaStudies I'm AzureETL Developer.Would you pls share google drive link to download your videos for reference..?
@@Anas_ILoveMyIndia sorry I don't have them on Google drive. They are free on RUclips. Kindly check there.
Thanks for the amazing videos; Your videos are very helpul and to the point . Kindly upload a video on how to process SQLs parallely in ADF pipeline.
Superb...
Thank you 🙂
In Every Demo, you are opening the portal again and again, you just keep it open and already login, and so that it will save little time of logging, just my sincere advice.
Thank you so much bro
Welcome
Thank you Sir
Welcome Madam 🙂
thanks very usefull video
Thank you 🙂
Thanks for the awesome Data factory tutorial.
I have a question, from where to pass parameter in linked service ?
Another great video..I am using this after 4 years 😂.
I have a question.. is it possible to parameterize linked service for Authentication Type ->System Assigned Managed Identity ?
If yes, how to do it.
My database is Azure SQL DBA.. and for my linked service I need to use this authentication type,. I can't use SQL authentication due to firewall restriction.. I am not sure how to create managed private end point using system assigned managed identity
can u make video on real time scenarios by using database parameters
Hi Basheer ,here we are using autointegration runtime if we are connected onpremises sql server then we are using self integration runtime?
Hi sir, very helpful videos u r making, just one question on how to pass parameters dynamically in pipeline to linked service. For example in foreach we have 5 server url and if we create copy activity in every loop. How will we pass the serve url to linked service for rest api call to different servers.
Can u please share the documentation link
hi maheer just a small doubt if i use windows authentication then what username and password one should use?
We should use Windows login details in that case.
what app is this on the left of notepad icon in taskbar to manage switching between windows?
Good stuff :)
Thank you 😊
Hi, can you please guide me on how we can create parameterized linked services for file system? We have 3 different folders in the file system as per the environment - dev, uat and prod.
Hi Basheer, first of all thank you so much for the very informative video series. Just wanted to highlight that in this video you've kept the IR to be Azure and in the later videos you've taken the SQL server example (on-prem). Do we need to have the IR to be Self-Hosted for better understanding in this video?
Is there a way to configure managed private endpoint as well to use with parameterized linked service ?
12:13 Can you please put the link in the description instead of the video. We're forced to type the long link.
Hi ; ), Is it possible to parameterize the Linked Service where values are stored in a out source Table ? For instance access the value in the table via the Lookup then strore the value in a variable and then put it into the Linked Service ?
hi @WafaStudies, can you please recommend to me any video that is there for dynamically setting the env variable. e.g I have created a workflow and there is an HTTP call, the endpoint URL is hardcoded and pointed to QA tes1 env, same workflow if I want to test for QA test2 then I am changing manually how to set it dynamically. I am new to azure logic Apps so trying to achieve environment profiling how works. Thanks !!
@wafastudies Can we change one type of linked service to another, I mean IF a linked service is created on SQL Server Database , can i change it to SQL Managed Instance
No
Hello @wafaStudies
Is there any possibility that, can we do On-prem Oracle DB(prod) to On-prem Oracle DB(UAT) (need to add some data) copy data using ADF? If yes How??
Hi Sir what about Azure SSIS IR we have not discussed it know
can you tell me how to parameterized the linked service for multiple sql servers not to multiple database
Wherever "Add dynamic content" is
given we can parameterize that thing.
Is it possible to create one linked service dynamically for more than one type of resources .?
Hey, I like ur Videos,
Got question ,
1. Lets say I installed self-hosted IR for ADF-1 now on my local machine.
2. Later I decided to remove this ADF-1 from my subscription for some reason
3. Now , I see that "IR installed on my local " is no where useful as this completely tied up with my ADF-1 keys , right?
4. Lets say now I created another ADF-2 for integration job to copy my on-prem local data to Azure may be Blob, SQL server whatever
5. It seems I need to remove and re-install my previous IR and register again with DF-2 keys , AM I Right? OR Any work around is there?
Thanks
Bro, before parameterize linked service we must make sure we are connected with IR's if we are using on prim DB right ?
If you are working with on prem resources then u need to go with selfhosted IR. I have videos on it kindly check them to get good Idea
Thanks for the viedos bro, they are excellent ♥️
Thank you 🙂
Hi Maheer, will you give real time one to one training for azure data engineering?
Sorry I'm not taking online classes
Can we use a single linked service in mutiple ADF's?
No. Each adf is different. U need to have linked seveice created there
@@WafaStudies thank you
One question - the parameters that are passed e.g dbName and serverName here, are they all predefined?
Data stores is ok what are compute machines?
Can we use a single Linked service for multiple task?
I have a question here...How to paas value to these linked service parameter dynamically..?
Shouldnt the integration Runtime for OnPrem SQL Servers which we want to be parameterized be selfhosted right? correct me if I am wrong..
Sir one help... How we can parameterize blob storage connection.. Dynamic Linked service for blob storage
Can you pass connection parameters in ODBC Linked Services as well? If yes, how?
Hi Maheer, If I'm giving Windows authentication I'm not getting Create option ... My Local SQL SERVER DB is Windows Authenticated no need of giving credentials to login is the same for Azure linked service also
Hi brother plz make videos on Azure Purview
Sure. I will plan soon
@@WafaStudies thank you so much brother
Is it possible to have single linked service for multiple servers i.e., sql server, oracle, db2.......etc.....
Hey Bro, Can we do parameterization for Databricks linked service attributes like 'Databricks url' and 'Databricks resource id' ?