Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to access directory situated on different server through TDF ?

Hi,

I have a job in TDF 6.3.1 which contains following design -0683p000009Lv9F.jpg

 

So I am fetching parameters from tFileInputdelimited_1and store in Global variable and pushed it into tFileOutputRaw_1,to create a output file.

 

But I want to create this output file to the directory situated on another server,but i have not access to that server by my credentials .

 

That's why I uses the output file path with Username who has the access to that server like this

"file:\\\\Servername\\c$\\Talend\\6.3.1\\cmdline\\studio\\out.txt"

But I am unable to create or access that direcotry.

 

Can any one suggest me what i have missed? Suggest me the solution pls..

Any how I want to access that directory otherwise I will not able to call  commandline.bat  file reside on that Server through tSystem_1 component.

 

Kindly reply soon....!

 

Thanks,

Vaibhav

 

Labels (2)
26 Replies
Anonymous
Not applicable
Author

Hi ,

You mean to say I have to install Putty on My local machine so that ,I can connect to Remote server and run the .bat file there?

 

I have downloaded the putty setup successfully installed also but when click "open" gives "Network Error:Connection Refused" . I enter Hostname as my Remote Server Name.

But Tell me Is it required to install openSSH or Tectia SSH on my Remote server.

Even Remote server doesn't have SSHD service in services.msc.

 

Can you please help me?

 

Thanks...!

cterenzi
Specialist
Specialist

The destination server has to be configured to accept connections of this type.

Would it not make more sense to set up this batch file on the host running the Talend job? Or else compile the Talend job and set it up to run on the host with the batch file?
Anonymous
Not applicable
Author

Hi ,

I want to run my talend job from my local machine but want trigger or call .bat file which is on Remote server.

 

We have tSSH component to do this task but I am unable to connect Remote server even after installing Putty in my local machine and freeSSHd on my Remote server.

I get status on my Remote server as follows-

0683p000009Lumm.jpg

 

But when I Double click on Putty in My Local machine,I get this error-

0683p000009Lual.jpg

Even if it recognises my remote Hostname then also it gives above error.

Is there any extra settings I have to Make in freesshd or Putty ?

 

Kindly Suggest...!

 

Thanks,

Vaibhav

vapukov
Master II
Master II

@cterenzi - You are could be right, but some time we could have other restrictions - such as we have 2 different network(offices in same organisation) in process

we finish process in one office, upload file, then call remote job.

Of course - there are many other ways how to resolve same problem

 

@vaibhav - do not forget about windows firewall, it close all what not enabled by default

Anonymous
Not applicable
Author

Hi ,

I am not using freeSShd right now to get rid of "Access denied " error in when I enter my Username and after giving password ,it gives me access denied error.

Now I installed KpyM telnet ssh server setup on my Remote server to which I want to connect from my local machine.

 

Now I am able to login by my local machine using Putty,but problem with tSSh component in my talend job .I have provided all necessary info like Host,Username,Password etc. even job executed successfully, no error comes .

 

But changes which I have expected from talend job is not reflected . Don't know why this is happened ?

 

Reply with your valuable suggestions please...!

 

Anonymous
Not applicable
Author

I am using following settings in my tSSh component-

 

0683p000009Luay.jpg

kindly reply ...!

 

vapukov
Master II
Master II

You can first easy check - just login to ssh and run command

 

You do not need any CALL and exit, just run it as normal command (in tSSH the same - just a command), and see result

this is shh session to windows server:

0683p000009Lub3.png0683p000009LuSm.png

Anonymous
Not applicable
Author

Hi Vap,

I m trying to run my commandline.bat file through putty like below

 

0683p000009LuGr.jpg

 

but before command executes ,it give pop up window like connection closed by remote host. Ideally on remote Server idle timeout is 5 min ,i explicitly set it as 0 i.e. no timeout. I also set keepalive timeout in Putty as 11 minutes. 

This will not serve my problem even though my changes are not reflected whatever I want .

There are two active sessions files appeared in my SSh server folder.

 

I also tried to run .bat file in tSSh but same happens, the job runs for so long and not closed then also I don't get the output that I expected.

 

Is anything I missed because even Event logger also shows I am able to login and excutes shell command as shown in above attached figure. 

 

Kindly reply...!

 

 

 

 

vapukov
Master II
Master II

Hi,

 

I don't know (and more important - do not want to know 🙂 ) all possible tools in a world

 

I use - https://www.bitvise.com/ssh-server, it work (of course by default it also timeout)

We have Jobs which run 3.5Hr month by month - stop and start new iteration, so ask Your sysadmin (or hire one) for setup it to You once properly, and then just use .

Anonymous
Not applicable
Author

Hi,

Yes of course no one is expert in all tools in the world 0683p000009MACn.png 

 I really appreciate your help ,and for our discussion of the current  topic ,now I am able to execute my .bat file by putty after some changes in .ini file on server.

 

Now I am trying to execute same .bat file through talend job by tSSh using Target execution as Local but same thing job doesn't response ,stuck somewhere don't know why but same credentials worked in putty .

It not even give error if there is problem in syntax only running continuously.

 

There is another way also in which we start putty from another batch file,by tSystem component but I want to execute this from tSSH if possible.

 

0683p000009Ludd.jpg

Does it belong to Port number ,bcz putty uses port number 22 and when I started Talend job It shows - [statistics] connecting to socket on port 3357.

 

Reply if its relevant for you...!

 

Thanks & Regards,

Vaibhav