Service Now integration with FTP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2011 04:44 AM
We need to integrate Service Now with an FTP. The FTP will contain two xml folders. One of the folders will contain data from HP Service Manager 7.0 and the other folder will contain data uploaded from the Service Now instance. See attachment
1. Can we use Update Set for receiving information from the FTP?
2. What should we use for receiving information from the FTP?
3. Is there any example of settings that we need to do in SNC?
4. Is there a wiki page/demo for this?
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2011 05:12 AM
I think what you want to focus on is Import Sets within the Service-now platform. The system is designed to go and retrieve from an FTP server. Once the file is retrieved, you then need to transform the data to a target table in the system. Here are some links.
Import Sets
http://wiki.service-now.com/index.php?title=Import_Sets
Supported Data Sources
http://wiki.service-now.com/index.php?title=Data_Sources
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2011 05:47 AM
imartez correctly covered getting data into SNC from an FTP source.
For sending data from SNC and exporting it TO an FTP source, I recommend the update set found at this website:
http://www.servicenowguru.com/integration/exporting-report-ftp/
You can schedule data uploads from SNC to an FTP location with this application.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2011 06:28 AM
Can we use web service to upload data to the ftp?
Why is "Scheduled Data Extract" recommended?
We do not want to schedule the upload to the FTP, but want to use a trigger. Meaning that if a user click on the submit button, a trigger should wake up and send the information to the FTP server on the fly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2011 07:57 AM
Obviously I don't know exactly what you are doing. Are you saying that when one record changes, you want just that one record to be placed on an FTP site? Or, are you saying on a given event, you want to upload all of the records (or a subset of records) in a table to your FTP site.
If you are uploading bulk data, then I would use the Scheduled Data Extract and combine it with this blog here to force the Scheduled Data Extract to run on demand:
http://www.servicenowguru.com/scripting/execute-scheduled-jobs-script/
However, if you are doing one record at a time, then I would suggest that you use Web Services or some other mechanism to send that data across. However, you would need a receiving web service on the other end that captures your data, creates a properly formatted file, and stores it on the FTP server.
