Use of SCP or SFTP from mid-server to deliver reports...

[tonywelle]

I Researched, found and loved the SNCGuru Update Set for scheduled report extracts, Until I installed and understood it. Unfortunately, it only supports FTPS and not SFTP. I could not find where the package ftp4che supported any other protocols.

Any suggestions on how to use SCP or SFTP in similar functionality?

[john_andersen]

The FTP and SCP transfer protocols are different code paths in the system, using different java packages. Unfortunately, if you want SCP or SFTP you will need to code it in yourself as a modification to that update set. Probably not a very trivial thing to do. I put it on my to do list a couple of years ago, but I have still never gotten around to it.

If it doesn't fit your needs and you don't have time to enhance it, I would recommend using the ODBC driver as an alternative to getting data out of your instance:

http://wiki.service-now.com/index.php?title=ODBC_Driver

[tonywelle]

Thanks John,

ODBC doesn't fit the need as I need to process from a Linux/UNIX server. From what I read I believe the ODBC driver to require install on Windows.

I read the javadocs for the sshtools library that is part of the std Mid server install and modified your mid server include script to support sftp.

Be glad to share it with you if you are interested.

[john_andersen]

Tony,

You are correct, ODBC driver will only work on a Windows platform device.

Yes, while the MID Server includes the java libraries necessary for SFTP, etc, it is not coded in with the Scheduled Data Extract. You would have to modify the scheduled data extract to utilize those libraries.

It definitely can be done, but you would have to enhance the scheduled data extract mid server script include to utilize the java libraries for sftp and write code around them to get it to leverage SFTP.

[tonywelle]

John, I have already modified the SNDataRetriever include script to support sftp. Glad to share if you are interested.