CSV via FTP

Connection

URI

URI can be FTP or sFTP. Example: sftp://abc.exavault.com:22/

Additional Connection String Parameters

Use a semi-colon, ";", between parameters.

I've had some ftp sites that require that I include the password in the Additional Connection String Parameters:

password=abc

If you don't want the connector to parse the CSV file and try to guess the field type, include:

typedetectionscheme=None

If your job is timing out, you can disable timeouts by adding this to the Additional Connection String Parameters:

timeout=0

Example:

password=abc;typedetectionscheme=None;timeout=0

CSV via SFTP

Use the CSV via FTP Connector and put the following into the Connection String Parameters: sshclientcert=D:\inetpub\wwwroot\MemberEngine\InstanceName\Files\pemfilename.pem;sshclientcerttype=pemkey_file;sshauthmode=public_key;timeout=0

You will have to ask Starfish Support to put the pem file on the server for you. Please be sure to share the file with a secure method.