How to send file from MID Server via SFTP from ERP system?

[ram2497]

How to send file from MID Server  via SFTP  from ERP system?

Please provide the examples.

Thanks

Ram

[johnfeist]

Hi Ram,

If you want to send ServiceNow data to your ERP via the MID server, you need to do that via an export.  Basically, you set up an export set and then schedule the export job as needed.  Here is the link to the documentation on creating export sets.

As far as how you send via SFTP, you need to work with your colleagues who manage those functions.  What I did was to map one of the drives on an FTP server to the mid server.  I have a scheduled job on the mid server that is scheduled to run shortly before the export arrives.  The job keeps looking for the arrival of the data.  Once the file arrives, it gets moved to the FTP drive and the job ends.  I created a rule in the FTP software that when the file arrives, send it to the appropriate destination.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[Ashutosh Munot1]

Hi,

Where you want to send the file?

Thanks,
Ashutosh

[ram2497]

Thanks for your response.

My Requirement:

 send files from MID Server to SFTP Server Location.

Scenario:

1. System will search for the configuration record for the combination of category, sub-category

And request type.

3. If configuration record found, then system will read all its details and generate the outbound file.
4. The generated file will also get attached to the header record if ‘Attach File on Header’ checkbox is selected in the config record.

Now the file will be stored temporarily on the MID server and then it will be moved to configured SFTP server

Thanks Ram

[Ashutosh Munot1]

HI,

So what dont you push the file to MID using Export sets and then ask them to pull the file?

Thanks,
Ashutosh