topic Re: "winscp" to transfer data from server to local drive in SAS Enterprise Guide

"winscp" to transfer data from server to local drive

sas_9 — Mon, 10 Dec 2012 21:57:45 GMT

Hi all,

we are using sas eg 5.1 and have sas mc 9.3. i want to implement "winscp" in our organization. I know "winscp" do secure file transfer from server to local drive but i don't know which extra server (FTP or something else) need to be created on SAS MC? can someone help me on what are the things need to be done to use "winscp"? i have "winscp" onboard but when i tried to connect with server- its not working. I am sure need to create one more FTP server or something link that on SAS MC.

please help...

Thanks.

Re: "winscp" to transfer data from server to local drive

ChrisHemedinger — Mon, 10 Dec 2012 23:55:43 GMT

Is this to allow SAS to get/retrieve files using FILENAME FTP? Or are you simply looking to transfer files from your SAS EG desktop to/from the SAS server? If the latter, you might be able to use this instead:

There and back again: copying files in SAS Enterprise Guide - The SAS Dummy

If you're expecting to see the FTP server in the "Servers" list in your EG session, you won't. EG shows you only SAS Workspace servers. (Well, and SAS OLAP servers.)

Chris

Re: "winscp" to transfer data from server to local drive

Haikuo — Tue, 11 Dec 2012 00:25:40 GMT

winscp is becoming more and more popular among industries for its price (free) and being able to comply with sFTP (Secure File Transfer Protocol) standard. I only use it occasionally to transfer files between Unix server and Windows environment. SAS does support sFTP using filename statement, if I do it on a regular basis and want it to be automated, that would be where I 'd take a look. Before using it, make sure sFTP server is running on the server you are trying to connect.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Haikuo

Re: "winscp" to transfer data from server to local drive

sas_9 — Tue, 11 Dec 2012 02:53:20 GMT

Thanks Chris.

I don't want to see FTP server in EG. I am thinking to create FTP server for "winscp" to transfer sas datasets. So basically, just want to connect winscp to SAS server.

Thanks.

Re: "winscp" to transfer data from server to local drive

sas_9 — Tue, 11 Dec 2012 02:55:40 GMT

Hi HaiKuo - thanks for your reply. but if i create FTP server on SAS MC, is it going to take care of connection b/w SAS and FTP?

Re: "winscp" to transfer data from server to local drive

Haikuo — Tue, 11 Dec 2012 03:00:46 GMT

I have never done that, so can't comment. Sorry.

Haikuo

Re: "winscp" to transfer data from server to local drive

SandorSzalma — Tue, 11 Dec 2012 14:38:31 GMT

Hi,

usually you can use putty, winscp without changing anything on the unix server.

(SSH-connection is per default enabled (port 22) and preferred.)

Regards,

Sándor

Re: "winscp" to transfer data from server to local drive

sas_9 — Wed, 12 Dec 2012 21:43:25 GMT

I am haing windows server- what kind of server i need to create through SAS MC? please let me know.

Re: "winscp" to transfer data from server to local drive

SandorSzalma — Thu, 13 Dec 2012 09:35:07 GMT

we use winscp only with Unix servers.

having SAS running on Windows server, I would create a share on it and map this share on my pc.

Re: "winscp" to transfer data from server to local drive

tlt — Thu, 13 Dec 2012 20:32:57 GMT

Hi,

If by SAS MC, you mean SAS Management Console,

You need to configure a server through SAS MC only if you need SAS functionalities, such as user's authentification through SAS Metadata, etc ...

But you can also, for sole file transfer between servers, install any software supported by the 2 two servers, eg winscp, putty, and configure your software as specified. Doing this, the files can be transferred as any binary files, not SAS files (eg datastes, catalogs, etc...) and some features are for you to care

Users' authentification
file integrity

hth