This article describes how to export data contained a data table to an external server.


Using the New Integration wizard to set up the Data exporter

Step 1) Go to Data > Integrations and select the New Integration button.

Step 2) In the Select Integration Type step of the Add Integration wizard, enter the configuration information as described in the below parameters table. Then press the Next button to continue to the next step, Configure selected Integration.

Parameter

Description

Name

Enter a name for the integration.

Description

Optional field used to describe the integration.

Data Selection Label

Selection labels are not required applicable to the Data Exporter. This is because the exporter is drawing data from Data Tables, which have already been created using device labels.

Integration type

Select Send to external MQTT Broker

Step 3) In the Configure selected Integration step, enter the configuration information as described in the below parameters table. Then press the Create button to complete the process and return to the Integrations page.

Parameter

Description

Data table selection and scheduling parameters

Data table to be exported

Select the data table from the drop-down list.

This data will be exported on a recurring basis, with the intervals and frequency determined by the below fields.

Schedule Type

This setting determines how often the data is exported. You can select between Daily or Monthly intervals.

  • Daily. Enables you to set export data in a frequency ranging from once every 24 hours to once every hour.

  • Monthly. Set the export frequency to once per month.

Initial Anchor time

Determines when the data will first be exported.

Time range of the data to be exported

This setting applies only to the Daily schedule type.

Only data recorded within this past time frame will be exported.

Set individual time range

By default, the time range of the data to be exported is automatically set; it is determined by the daily schedule frequency.

However, this toggle switch allows you manually set the time range via the Hours field. This optional can be useful to allow for overlapping time ranges, so that data that is added to a time interval after that interval has already been exported, will be exported with the following export.

Hours

Time range of recorded data to be exported.

Example:

SFTP Target Server parameters

SFTP Server Host

SFTP server address. Consult the SFTP server administrator to retrieve this information.

  • Example:

    • ftp.smarkmakers.io

SFTP Server Port

Remote server port. Consult the SFTP server administrator to retrieve this information.

User

Remote server user name. Consult the SFTP server administrator to retrieve this information.

Password

Remote server password. Consult the SFTP server administrator to retrieve this information.

Remote Path

Folder path used to store files on the remote server