Scheduled Data Extract

Interested in the Crossfuze using the ‘Scheduled Data Extract’ solution in your ServiceNow instance? New and improved version includes options to:

  • Export only deltas from a previous export
  • Custom data filters
  • Extract data from very large tables using chunking.
  • Custom delimiters
  • Fully-tested against all ServiceNow releases!
  • And much more!

Contact Crossfuze for additional information on how you can leverage the power of this enterprise-grade product.

 

ServiceNow provides numerous ways of getting data into the system. The import set functionality supports pulling data in from an attachment, FTP(S) servers, JDBC data sources, etc. However, a common problem that many customers have is trying to get data out of their SN instance and into their data center. The simplest way to handle this currently is by having a report emailed to you on a scheduled basis. There has to be a better way!

Scheduled Data Extract ModulesThe good news is that there is a better way. The ‘Scheduled Data Extract’ update set has been designed to allow a user to have reports, tables, or table views sent to a specific directory on a local mid server or FTP to a customer’s FTP/FTPS server on a scheduled basis. The ‘Scheduled Data Extract’ update set has been battle-tested and is used by hundreds of large ServiceNow customers today.

On installation of the Data Extract update set, two new modules will be present within the Reports Application: ‘Scheduled Data Extract’ and ‘Data Extract History’.

 

 

How it works

 

Scenario #1:

Let’s say you want to have all of your users exported from ServiceNow to a particular computer in your corporate intranet. In this case you want it to end up on a generic Windows XP machine in a certain directory everyday at 12 AM. Once you’ve installed the scheduled data extract, you simply fill out the form in the following manner.

Scheduled Data Extract MID Server
Most of these fields should be self-explanatory. The MID Server field asks which mid server you would like to have handle this request (Note that the ‘MID Server’ field will not be visible until you have installed the MID Server plugin as documented below).  In this scenario, this field should be set to the mid server that’s running on the machine that will be receiving the export from ServiceNow. The Append timestamp field should be checked if you do not want to overwrite the file on your Windows XP machine each time ServiceNow exports its user table.

Scenario #2:

You want to export an incident report to an FTP server every Wednesday at 1 PM. This report should be in CSV format. Since the incident table contains so many fields, you want to limit the export to only include the fields that you’re interested in. This screenshot represents the solution. Notice the View field. This allows you to specify which view you want to use. It is by defining the view that you’re able to specify which fields should be exported.

Scheduled Data Extract FTP
Notice that the MID Server field is still a mandatory field. This is because the mid server is what handles the grunt work to get the data from ServiceNow and FTPs it to your FTP/FTPS server. The big advantage of this is that you do not need to open/modify ports to allow ServiceNow to send data to your FTP server. It can be a local FTP server that you use internally but do not want to open up to the outside world. The mid server is required to actually perform the transport of the exported file to your FTP location.

The ‘Scheduled Data Extract’ update set supports several secure FTP methods. One method that is not supported is SFTP, which commonly confused with FTPS.

Although it is possible to use this export functionality to export large numbers of records (500K+) from your ServiceNow instance, you obviously should not do so without doing some performance testing first. Any large query against any database has the potential to adversely affect the performance of that database.

 

Interested in using the Crossfuze ‘Scheduled Data Extract’ solution in your ServiceNow instance? Contact Crossfuze for additional information on how you can leverage the power of this enterprise-grade product. New and improved version includes an option to export only deltas from a previous export, custom filters, and the ability to extract data from very large tables using chunking. It’s also fully-tested against all ServiceNow releases!