SFTP Server Data Stream – Decibel

The SFTP data stream enables Decibel to deliver Session and Pageview data to an SFTP server every night.

Settings

To view settings for the SFTP data stream, select SFTP Integration Enabled.

The following settings are available:

Setting	Description
Data type	Select the type of experience data you want to deliver to your SFTP server every night. The following options are available: Session: Delivers all Session data from the past 24 hours Page: Delivers all Pageview data from the past 24 hours All: Delivers all Session and Pageview data from the past 24 hours
Schema version	Select a schema to define the data fields available in the Session and Pageview datasets to be delivered to your SFTP server. Note: Decibel recommends using the Version 7.0 schema allowing for additional custom Session or Pageview fields to be included.
Custom pageview fields	If necessary, select additional Pageview data fields to use alongside the data fields defined in the selected Schema version.
Custom session fields	If necessary, select additional Session data fields to use alongside the data fields defined in the selected Schema version.
Output type	Select the file type to export Session or Pageview data for delivery to your SFTP server.
Frequency	Select how frequently Decibel exports data to the SFTP server.
Export hour	Select the hour to export Session or Pageview data every day.
Export period	Select the period to export Session or Pageview data from. The following periods are available: Previous 24 Hours: Exports Session or Pageview data from the 24 hours up to the hour selected in Export hour Previous Day: Exports Session or Pageview data from the hours of 00:00 to 23:59 the previous day
Timezone identifier	Select your timezone.
Output filename	Enter a filename to give exported Session or Pageview data. Use one of the following uppercase character combinations to provide a variable date convention: YYYY: Year, four digits Example: 2021 YY: Year, two digits Example: 21 MMM: Month, three letters Example: Jan MM: Month, two digits Example: 01 FFF: Month, in full Example: January DDD: Day of week, 3 letters Example: Mon DD: Day of month, two digits Example: 31 LLL: Day of week, in full Example: Monday HH: Hour, two digits (00-23) Example: 21 II: Minute, two digits (00-59) Example: 57 SS: Second, two digits (00-59) Example: 37 EEE: Time zone, three letters Example: GMT CCC: Date and time, ISO 8601 Example: 2024-02-12T15:19:21+00:00 RRR: Date and time, RFC 2822 Thu,_21_Dec_2021_16:01:07_+0200 AAA: Date and time, Atom Example: 2015-08-22T15:52:01+00:00 OOO: Date and time, cookie Example: Monday,_15-Aug2019_15:52:01_UTC
Use temporary filename	If necessary, select this option to send Session or Pageview data to a temporary TMP file until the export process completes. This setting is recommended for high-traffic properties.
ZIP files to Archive	If necessary, select this option to deliver Session or Pageview data to your SFTP server in one ZIP file instead of 24 individual files for each hour of the day.
ZIP Archive filename	If you selected ZIP files to Archive, enter the filename to give the ZIP file. Use one of the following uppercase character combinations to provide a variable date convention: YYYY: Year, four digits Example: 2021 YY: Year, two digits Example: 21 MMM: Month, three letters Example: Jan MM: Month, two digits Example: 01 FFF: Month, in full Example: January DDD: Day of week, 3 letters Example: Mon DD: Day of month, two digits Example: 31 LLL: Day of week, in full Example: Monday HH: Hour, two digits (00-23) Example: 21 II: Minute, two digits (00-59) Example: 57 SS: Second, two digits (00-59) Example: 37 EEE: Time zone, three letters Example: GMT CCC: Date and time, ISO 8601 Example: 2024-02-12T15:19:21+00:00 RRR: Date and time, RFC 2822 Thu,_21_Dec_2021_16:01:07_+0200 AAA: Date and time, Atom Example: 2015-08-22T15:52:01+00:00 OOO: Date and time, cookie Example: Monday,_15-Aug2019_15:52:01_UTC
Date for the archive filename	If you selected ZIP files to Archive, select a date convention to use in the ZIP file name. The following options are available: Date zip file is created: Date used in the filename reflects when the ZIP file was created Date of earliest included data: Date used in the filename reflects the date of the earliest item of data in the ZIP file
Archive encoding	If you selected ZIP files to Archive, select the encoding type to use for the ZIP file.
SFTP Integration Enabled	Select this option to view all settings and integrate your SFTP server with Decibel.
Host	Enter your SFTP hostname.
Port	Enter your SFTP port number.
Username	Enter your SFTP server username.
Password	Enter your SFTP server password.
Remote path	Enter the remote server path to export the data file to.

To save changes and enable SFTP integration with Decibel, click Save.

Other data stream destinations

Decibel also supports data streaming with the following destinations:

Settings

Other data stream destinations

Related articles