Export

This sync enables moving data from a user specified datawarehouse to FTP.

SETUP

Configuring the Credentials

Select the account credentials which has access to relevant FTP account from the given list & Click Next

Credentials not listed ?

Click on + for adding new credentials and fill the form that pops-up.

ftp reverseetl add credentials

Data Sync Details

Data Sync

Select Export & click Next

ftp export sync
How do you want to fetch data?

Select whether you want to fetch data from the Data Model or from Table/ View.

Data Model

In case you want to fetch data using Data Model, select the data model that you would like to use for this sync. Checkout how to configure a model here.

Data Warehouse

In case you want to fetch data using Table/ View, select the data warehouse that you would like to use for this sync.

Table / View

Select the Table/ view in the data warehouse that you would like to use for this sync.

Field Selection

This refers to the fields from which data will get updated from the data warehouse to your FTP. You can select all fields or choose the required fields.

Setting Parameters

Parameter Description Values

Fetch Mode

Required

This refers to the manner in which data will get fetched from the warehouse: FULL will fetch all records available in the data model / segment and will send tham to FTP,and INCREMENTAL will fetch only new records since the last sync and will send them to FTP.

{Incremental,Full}

Default Value: FULL

Incremental Key

Dependent Required

This refers to the key using which the rows will be incrementally fetched for upload.

Enter a row number

File Transfer Protocol

Required

Select a protocol for FTP connection.

FTP, SFTP, endTime

Default Value: FTP

Destination File Type

Required

Specify whether to export data in CSV or newline delimited JSON or Apache Parquet or Apache Avro.

csv, txt, parquet, avro

Default Value: csv

Include Headers

Required

Specify whether to include headers in the exported file if "Destination File Type" is "csv".

Yes, No

Default Value: Yes

File Path

Required

Enter the absolute path where file needs to be uploaded. Supports datetime string formats.

Enter the file path.
ftp sync config

Data Sync Scheduling

Set the schedule for the sync to run. Detailed explanation on scheduling of syncs can be found here

Dataset & Name

Give your sync a name and some description (optional) and click on Finish to save it. Read more about naming and saving your syncs including the option to save them as templates here

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.