FTP/SFTP

file transfer protocol (ftp) and secure file transfer protocol (sftp) is supported by dlh io for synchronization of your data into files that can be pushed to your current ftp or sftp server, or potentially a third party ftp/sftp server as part of your downstream process in your data pipelines pre requisites access to a ftp/sftp server ability to test the ftp/sftp server setup instructions target connection setup datalakehouse io securely connects to your ftp/sftp server using the form in the datalakehouse io portal please complete the following entries enter a name or alias for this connection, in the 'name/alias' field, that is unique from other connectors enter a server/host field, enter the ip or dns for the server enter a port field, enter the port number on which to connect enter a folder path field, enter the ftp/sftp server folder path where to land the data files/information use / as the default if unknown, and this will land in the base folder enter a user field, enter the name of the user for your access credentials select the auth type , for which your credentials will access the server either your credentials are user and password or user and encrypted key if you select the username/password option you'll be prompted to enter your password if you select key pair authentication you will see the private key field where you will enter your private key if selecting username/password enter the password in the password field for your access credentials if selecting key pair authentication enter a private key field, enter the private key credentials select a private key encrypted? option if yes, then enter the private key password if no, continue to the next step click the save & test button once your credentials are accepted you should be able to see a successful connection control each column data type sql transformations docid 5zjgrvbhtywqw8 olioh0 allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via datalakehouse io (dlh io) this especially helps when you want to control the data type set in your target connection since all columns are set as varchar(16777216) issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com