Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
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)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

Finally issue resolved .I build my local talend job and include home directory with the path as same as the path on remote server where commandline.bat file resides.

 

Building talend job and execute .bat file of that job on remote server after copying zip file of job on the server. This Works fine for me. I refer following topics- 1) http://etladvisors.com/2014/05/06/windows-deployment-and-scheduling-of-talend-jobs/

2)https://community.talend.com/t5/Design-and-Development/Using-tSystem-to-launch-a-batch-via-remote-co...

 

Thanks,
Vaibhav

View solution in original post

26 Replies
vapukov
Master II

where You want execute this commandline.bat file?

on Your machine or on remote?

Anonymous
Not applicable
Author

Hi,

thanks for your quick response..!

 

I want to execute .bat file through my machine but the problem is it is resides on different server. Commandline.bat file requires its all related files they are also resides on that server.

That's why I want to push my output file on that server and call it from Commandline.bat  file by specifying its name in command in Commandline.bat.

 

Thanks,

Vaibhav

vapukov
Master II

Still not 100% clean

 

1) if this .bat file could be executed from remote disk, but on local machine (did You test this?), You can:

- map network drive

- just make a local copy of files

 

2) But if as usual - dependencies more serious, like dll or other libraries - file will not work properly

in this case remote disk not help 

 

in any case - tSystem - call file for execute only on local machine with all local folders, so ev en if You put file on remote server and run bat file - it will look for Disk C: as local Disk C: on Your machine, but not on remote sever as You expect (same for all dependencies - it will search all path on Your machine)

 

Normal way, if You want call remote Job - install on remote server ssh and sftp services, in this case Talend will and upload file and call remote command 

 

 

Anonymous
Not applicable
Author

Hi Vap,

Thanks for your Prompt response....!

 

I mapped the network drive as you suggested,it  works for me.

Now I can Push my output file on that server ,but I am worried about tSystem component to call Commandline.bat file . 

 

I get Following Error in tSystem-

'\\Servername\c$\Talend\6.3.1\cmdline\studio'
CMD.EXE was started with the above path as the current directory.
UNC paths are not supported. Defaulting to Windows directory.
'commandline_test.bat' is not recognized as an internal or external command,
operable program or batch file.

 

 

I am very close to achieve my target if tSystem works fine for me. Is there any different way to do this?

Kindly reply to solve this query if possible 0683p000009MACn.png ....!

 

Thanks,

Vaibhav

vapukov
Master II

may be (but not sure) it could be done as You want ...

I can't suggest nothing, because always go by other way (from my point of view more proper)

 

I suggest on my projects (when windows) for clients - https://www.bitvise.com/ssh-server, or analogs from IBM (part of some product) or cygwin and etc

Some clients prefer native windows

 

just install one of this .. .and use standard ssh tools like - ssh, scp, sftp ... all what Talend need for do all what You need

 

 

 

cterenzi
Specialist

Windows is telling you the problem. You can't use a UNC path (i.e. paths in the form \\server\sharename\directory) when invoking CMD. If you mapped the share to a drive letter, refer to the drive letter instead.

vapukov
Master II


@cterenzi wrote:

Windows is telling you the problem. You can't use a UNC path (i.e. paths in the form \\server\sharename\directory) when invoking CMD. If you mapped the share to a drive letter, refer to the drive letter instead.


I agree with You about UNC error (and when I mean map - I mean map as local drive T:\ for example), just personal opinion - this is wrong way

even if You map network drive and try for example run excel - it will not work

Anonymous
Not applicable
Author

Hi,

I get following Error while using tSSH component-

java.io.IOException: There was a problem while connecting <ServerName> 22

 

0683p000009Lu3C.jpg

 

I am confused while set up of SSH2 option in Network tab of Talend Studio-->Windows-->Preferences.

Is it mandatory to install Putty.exe on my local machine to connect remote server by SSH protocol?

 

Kindly reply..!

vapukov
Master II

don't touch Talend 🙂

 

for work tSSH - You must have enabled SSH on target server, by default it not installed on windows server, and as well could be closed by firewall