Can we trigger a script from a databricks notebook to the windows remote machine(in VPN)?

[daniel_sahal]

@Ratna Chaitanya Raju Bandaru​ 

It's doable.

For example you can use SSH to connect to the windows machine and run your scripts in there (SSH client needs to be installed on the Win machine)

[Chaitanya_Raju]

@Daniel Sahal​ ,

Thanks for your quick response, if there is any blog or documentation or any stackoverflow link can you please help me with the same, so it can be useful for me.

[daniel_sahal]

@Ratna Chaitanya Raju Bandaru​ 

Here's how to install OpenSSH on WIN:

https://woshub.com/connect-to-windows-via-ssh/

Then you can just simply SSH to your machine from Databricks:

%sh
ssh -p PORT USER@DOMAIN.COM

[Chaitanya_Raju]

@Daniel Sahal​  , thanks for the update.

Is there any possibility this can be done using PowerShell i.e connect the server by executing Powershell script in databricks notebooks?

[daniel_sahal]

@Ratna Chaitanya Raju Bandaru​ 

You can try to install pwsh on the cluster, but i'm not sure if this will behave same as on Windows machine.

https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-linux?view=p...

[KaifKhan]

Hi, have you found any way to do it? i have the same requirement and not able to find any meaningful solution.

[Vartika]

Hi @Ratna Chaitanya Raju Bandaru​

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best? If not, please tell us so we can help you.

Thanks!