Thanks Shaik. This entire series has been very helpful. Thanks for your time and generosity.

@WafaStudies

2 жыл бұрын

Thank you 😊

This is so far the best video on IR I saw over youtube

@WafaStudies

2 жыл бұрын

Thank you ☺️

man you are too good .in a very simple non accented way you have explained this so well. I hope your channel becomes viral. all d best

@WafaStudies

2 жыл бұрын

Thank you ☺️

@marnirambabu

Жыл бұрын

@@WafaStudies is there any vedio for azure ssis integration run time

Amazing video and explaination. Thank you so much mate.

@WafaStudies

Жыл бұрын

Welcome 🤗

Thanks bro ! you're one of the rare gem on KZread

@WafaStudies

3 жыл бұрын

Thank you 🙂

Good work. Large number of people are waiting for Databricks tutorial as well. Please upload Databricks video tutorial.

Thanks bro ! you're one of the best on KZread

@WafaStudies

2 жыл бұрын

Thank you ☺️

This is really helpful. Thank you so much.

@WafaStudies

2 жыл бұрын

Welcome 😊

thank you bro, excellent video

you are FANTASTIC ! keep it up man

@WafaStudies

2 жыл бұрын

Thank you ☺️

Superb Azam, realy helpfull.👍

God bless you bhaiya. Thus is so clear. Thank you.

@WafaStudies

Жыл бұрын

Thank u. God bless you too ☺️

Nice explanation sir, 💯

Very Well explained. I like your teaching skills.

@WafaStudies

2 жыл бұрын

Thank you 😊

Very Nice explained

Hi sir, is it possible to have sink as on premise database using self-hosted IR in azure data factory?

very well explained

Nice work, very useful, you are awesome

@WafaStudies

Жыл бұрын

Thank u

Thanks for the video ,how does this work in Production?

Good to get indroduction knowledge on self hosted

Sir this video is a bit fast, but your previous videos which are slow are awesome.

what if the on prem is a linux based node ? you use linux based wizard to set up your IR ?

Troughput means how many jobs/process are getting executed per second/minute. now how multiple node will improve throughput, does it do parallel processing ?

Hello, If we want to connect our ADF to private postgres database in AWS then also self hosted needed? If yes then how will we install that in AWS Postgres?

10:25 Configure upto 4 Nodes for Self Hosted IR. Configure Multiple Nodes: high availability. Cloud -> On prem. 1 node went offline. ADF stops working pp gets failed. I want PL to always run. It will pick Node 2 and continue running pipeline. Good throughput.

So if the actual on Orem server is in another machine, we can install in SHIR in our machine with the same key and can access that server ?

Nice video. A kind query. Actually when I clicked Register button, it shows Runtime node name along with server name and if I clicked finish button, it went to another screen that is Specify backup file window to store backup file along with password. Please help how to solve this issue.

How it works if want to connect unix on prem server to cloud via self hosted IR

God bless you

Hi can you make a video on accessing oracle databases from adf by using oracle data guard . Oracle dataguard connection string is available how to select correct database by using this.

Hello guys, Is there any possibility that, can we do On-prem Oracle DB to On-prem Oracle DB copy data using ADF? If yes How??

Is there any limits of IR in a single Azure data factory? Max how many IR we can create.

should need to install it on SQL Server or Apps server? thanks

i have created a simple data flow which tries to copy data from SQL Server (on-prem) to Azure blob Stoeage but i get the following error message : Linked service with Self-hosted Integration runtime is not supported in data flow. Please utilize the Azure IR with managed vnet.

I am facing connection issue while creating linked services for sql server. Please help. Below is error Cannot connect to SQL Database: '(LocalDB)\MSSQLLocalDB', Database: 'AdventureWorksDW2016', User: 'santo'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Login failed for user 'santo'., SqlErrorNumber=18456,Class=14,State=1, Activity ID: e1d0b6c6-c54c-45cb-bbfb-78bb936af562

How this works in production environment?

I have one doubt, if it only work in private network then why you told that it i public and private both

Pls.Share a video on SQL server DB CI/CD through Devops pipeline.

Again Thanks :)

@WafaStudies

3 жыл бұрын

Welcome 😁

What are the drawbacks of data movement using Self-hosted IR for cloud storage compared to Azure IR?

@harmanbawa19

11 ай бұрын

Using Self-hosted Integration Runtime (Self-hosted IR) instead of Azure Integration Runtime (Azure IR) for data movement to cloud storage comes with some trade-offs. Here are the drawbacks: 1. **Network Overhead**: - Self-hosted IR moves data over your own network. If your on-premises network connection to the Azure cloud is not fast enough, data movement can be slow. Azure IR, on the other hand, operates in the cloud and can often access Azure services faster. 2. **Maintenance**: - Self-hosted IR requires you to manage and maintain the infrastructure on which it runs. This can include updates, patches, and troubleshooting any issues that arise. Azure IR is fully managed by Microsoft, so you don't have to worry about this overhead. 3. **Cost Implications**: - Even though Azure IR incurs costs based on data movement, Self-hosted IR might lead to indirect costs. These could be associated with maintaining infrastructure, increased network usage, or potential bottlenecks in on-premises resources. 4. **Scalability**: - Azure IR automatically scales based on the data movement demand, ensuring optimal performance. With Self-hosted IR, you'd need to manually scale and provision more resources if the demand grows. 5. **Security Concerns**: - Using Self-hosted IR means the data moves across your network, which may raise security concerns. You need to ensure data is encrypted and that your network is secured. With Azure IR, Microsoft manages most of the security aspects. 6. **Latency**: - For cloud-to-cloud transfers, Azure IR is usually faster because it's already within the Azure network. Using Self-hosted IR in such scenarios can introduce unnecessary latency. 7. **Complex Setup**: - Setting up a Self-hosted IR involves more steps, including configuring on-premises resources, compared to Azure IR which is more straightforward. 8. **Availability**: - Azure IR is designed to be highly available by Microsoft. With Self-hosted IR, you'd need to ensure high availability, especially if you have critical data movement tasks. Using the right Integration Runtime depends on the specific use case and requirements. While Self-hosted IR makes sense for certain hybrid scenarios, direct cloud storage interactions often benefit from the capabilities of Azure IR.

Thanks Maheer, this is helpful. Quick question I have: For what Key 2 in Self Hosted IR is used for? There I saw 2 keys are there

@Aji_Appu_Aarna_125

2 жыл бұрын

We can use any one of key

Thanks, Mate!, This is really excellent the way you are teaching ADF in so much detail. I have one question on Self Hosted IR, The nodes that we create for multiple on perm servers to achieve high availability, and if one of the nodes fails and which also has SQL Server linked service on the same on-premise server. Will this SQL server going to use the compute service from the other available nodes or will it fail completely?

@ramisettibramhini2639

2 жыл бұрын

as per my knowledge, it won't fail as the basic functionality of nodes is to achieve high availability even if one nodes fail, the linked server will be same for all the nodes.@shaik;Pls correct me if I'm wrong

@tipsandhacksbygaurav

Жыл бұрын

Try to reproduce the same scenario in actual ...shutdown on-prem server in between data movement and check if it is working or not with 2nd node...

Thanks for the demo. May I know how I can use self hosted IR via a Mac book?

@visheshsharma5234

11 ай бұрын

Hey, I was looking to setup self-hosted IR in my Macbook too but I haven't been able to find out the way. Can you help me to set it up?

Thanks

@WafaStudies

Жыл бұрын

Thank you so much 😇

Thanks a lot

@WafaStudies

2 жыл бұрын

Welcome 😊

Hi bro How we contact you

Hi ,once created self hosted IR and trying to connect linked service but am facing issue with firewall

@WafaStudies

2 жыл бұрын

Take selfhosted IR and add it to ur firewall rules

great

@WafaStudies

2 жыл бұрын

Thank you 😊

How can I perform this on a mac?

@visheshsharma5234

11 ай бұрын

hey did you find out how we can run it on Mac??

Please upload databricks videos more

@WafaStudies

4 жыл бұрын

Sure