17. Parameterize Linked Services in Azure Data Factory

[@NelapatiPraveenKumar]

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

[@WafaStudies]

Thank you 🙂

[@kartikeshsaurkar4353]

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

[@WafaStudies]

Thank you ☺️

[@rockseerock]

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

[@WafaStudies]

Thank you ☺️

[@sanishthomas2858]

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

[@WafaStudies]

Thank you 🙂

[@sanishthomas2858]

Would u mind adding some videos on Usql,notebook, python etc. Simple demos will be fine

[@krishnakumar-vi3tf]

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

[@WafaStudies]

Thank you for kind words 🙂

[@deepaksahirwar]

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

[@WafaStudies]

Thank you ☺️

[@divyaverma1132]

Thanks for the content. Whole series is awesome.

[@WafaStudies]

Thank you 🙂

[@gouravkarmakar9606]

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

[@WafaStudies]

Thank you ☺️

[@WafaStudies]

Thank you ☺️

[@balamanikanta7685]

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

[@snehasiktachandra3536]

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.

[@zenbabasha]

Bravo keep It up!! You teched the world

[@WafaStudies]

Thank you 😊

[@Anas_ILoveMyIndia]

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

[@WafaStudies]

Thank you for your kind words.

[@Anas_ILoveMyIndia]

@@WafaStudies I'm AzureETL Developer.Would you pls share google drive link to download your videos for reference..?

[@WafaStudies]

@@Anas_ILoveMyIndia sorry I don't have them on Google drive. They are free on KZbin. Kindly check there.

[@tipsandhacksbygaurav]

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

[@MrZoomok]

What great lessons of here !!! Thank bro

[@WafaStudies]

Thank you 🙂

[@adityaarbindam]

excellent video

[@vikasnegi9387]

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?

[@siri9622]

Thank you so much bro

[@WafaStudies]

Welcome

[@sonamkori8169]

Thank you Sir

[@WafaStudies]

Welcome Madam 🙂

[@MrSuryagitam]

Superb...

[@WafaStudies]

Thank you 🙂

[@priyankadp5777]

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

[@rakeshkaddi]

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.

[@satishkumar-bo9ue]

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

[@NickNokolas]

thanks very usefull video

[@WafaStudies]

Thank you 🙂

[@richajain3291]

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.

[@gaganacreations7464]

Hi Basheer ,here we are using autointegration runtime if we are connected onpremises sql server then we are using self integration runtime?

[@prekshajain5174]

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

[@WafaStudies]

We should use Windows login details in that case.

[@Arihant_Sethia]

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

[@bartomiejcal4073]

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 ?

[@abhishekreddygaddam5011]

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

[@WafaStudies]

Sorry I'm not taking online classes

[@manjunathareddy7122]

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

[@arjunpalitphotography]

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

[@ronydominic4873]

Hi brother plz make videos on Azure Purview

[@WafaStudies]

Sure. I will plan soon

[@ronydominic4873]

@@WafaStudies thank you so much brother

[@santoshprasanth6633]

Bro, before parameterize linked service we must make sure we are connected with IR's if we are using on prim DB right ?

[@WafaStudies]

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

[@santoshprasanth6633]

Thanks for the viedos bro, they are excellent ♥️

[@WafaStudies]

Thank you 🙂

[@DineshTelegenic]

Can u please share the documentation link

[@prannay19]

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

[@rikeshramjuttun4689]

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

[@purvajpradhan8841]

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

[@jyotsnab7994]

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

[@riteshchawla10]

Can we use a single Linked service for multiple task?

[@bhavnakamble975]

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

[@yuvarajmani5907]

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

[@shivanidubey1616]

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

[@shivadevisetti5588]

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

[@alfredsfutterkiste7534]

Good stuff :)

[@WafaStudies]

Thank you 😊

[@swathireddy2833]

@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

[@WafaStudies]

No

[@vasaripraveenreddy5268]

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

[@tarakmahesh6483]

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

[@avinash8379]

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

[@vishaljhaveri7565]

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

[@gullipalliharipriya2532]

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

[@WafaStudies]

No. Each adf is different. U need to have linked seveice created there

[@gullipalliharipriya2532]

@@WafaStudies thank you

[@AshishKumbhar-yy9pw]

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

[@anuragkhare3821]

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

[@vasaripraveenreddy5268]

Data stores is ok what are compute machines?

[@dataguys2192]

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