15. Setting up Self Hosted Integration runtime in Azure Data Factory

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 ?

God bless you

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

Hi Brother,

When I try to create a linked services with SQL server, I am getting the below issue when I test the connection. Please advise how to fix it. I am not sure if any issues with password or other.

"Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-HDF1UG2', Database: 'PerTraining', User: 'deva'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Login failed for user 'deva'., SqlErrorNumber=18456,Class=14,State=1,
Activity ID: 02b3a658-510a-49bd-bad5-7636cf2b719d."

Nice work, very useful, you are awesome

How can I perform this on a mac?

Hi bro How we contact you

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?

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

very well explained

Thanks

Amazing video and explaination.

Thank you so much mate.

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

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

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.

Troughput means how many jobs/process are getting executed per second/minute.

now how multiple node will improve throughput, does it do parallel processing ?

great

Thanks a lot

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

Very Well explained. I like your teaching skills.

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

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

This is really helpful. Thank you so much.

you are FANTASTIC ! keep it up man

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

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

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.

How this works in production environment?

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.

Again Thanks :)

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

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

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

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?

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

Please upload databricks videos more

Very Nice explained

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

Nice explanation sir, 💯

Superb Azam, realy helpfull.👍