17. Parameterize Linked Services in Azure Data Factory 

He saved our money with his teaching!! I am gonna share his videos in my social networks #linkedin

Thank you so much for providing this much detailed content free of cost. Keep making videos.

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

one of the first videos covering full module on ADF. Good job.

You are Excellent Bro...Your focus and patience in explaining concepts great!!!

Just mind blowing explanation about the fundamentals of Parameterizing Linked Services. Thank You

Thanks for the content. Whole series is awesome.

you are really a gem brother. keep up the good work. The content is awesome

Bravo keep It up!! You teched the world

What great lessons of here !!! Thank bro

Excellent Video Tutorial Bro.... Thanks for the Content... Please keep Going ...

Hi brother, Your concepts are awesome and useful indeed..Thanks for valuable content..!!

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.

excellent video

Thanks for the awesome Data factory tutorial. I have a question, from where to pass parameter in linked service ?

hi maheer just a small doubt if i use windows authentication then what username and password one should use?

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?

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

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 ?

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 Basheer ,here we are using autointegration runtime if we are connected onpremises sql server then we are using self integration runtime?

@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

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 @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 !!

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 ?

Can u please share the documentation link

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 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

Is there a way to configure managed private endpoint as well to use with parameterized linked service ?

Superb...

Is it possible to create one linked service dynamically for more than one type of resources .?

Hi Sir what about Azure SSIS IR we have not discussed it know

I have a question here...How to paas value to these linked service parameter dynamically..?

can you tell me how to parameterized the linked service for multiple sql servers not to multiple database

Can we use a single Linked service for multiple task?

Shouldnt the integration Runtime for OnPrem SQL Servers which we want to be parameterized be selfhosted right? correct me if I am wrong..

Can you pass connection parameters in ODBC Linked Services as well? If yes, how?

Thank you so much bro

Sir one help... How we can parameterize blob storage connection.. Dynamic Linked service for blob storage

what app is this on the left of notepad icon in taskbar to manage switching between windows?

Hi Maheer, will you give real time one to one training for azure data engineering?

can u make video on real time scenarios by using database parameters

One question - the parameters that are passed e.g dbName and serverName here, are they all predefined?

Can we use a single linked service in mutiple ADF's?

Hey Bro, Can we do parameterization for Databricks linked service attributes like 'Databricks url' and 'Databricks resource id' ?

Is it possible to have single linked service for multiple servers i.e., sql server, oracle, db2.......etc.....

thanks very usefull video

Thank you Sir

Data stores is ok what are compute machines?

12:13 Can you please put the link in the description instead of the video. We're forced to type the long link.

Wherever "Add dynamic content" is given we can parameterize that thing.

Hi brother plz make videos on Azure Purview

Good stuff :)