Create FTP/SFTP Connection

Connection Properties

image-20240331-033849.png

 

Name

Mandatory

Description

Name

Mandatory

Description

Connection Name

Yes

Name of the connection

Description

No

Description of connection

Directory

Yes

The directory where the files/objects are stored

FTP/SFTP (Protocol Type)

Yes

Indicate whether FTP or SFTP

Username

Yes

Username used for authentication

Password

Yes

Password used for Authentication

Host

Yes

The FTP / SFTP host

Port

Yes

Indicates the port to be used for the connection

Steps to create connection:

  1. There are two ways to create connection -

    1. Choose the FTP connector from Pipeline tab > Add Connection.

      image-20240429-074411.png
      Pipeline tab

       

    2. You can also add the connection via Connections tab>Add Connection. 

  1. Fill in the required details.

  2. Click on the Test connection button to confirm.

  3. Click Create connection.

Reading Objects

EazyDI

 

FTP Host

 

For excel objects indicate and choose the sheet name from the drop down

 

For date string handling See Date and DateTime String Handling in EazyDI