0

Connecting to SFTP server

Hi, 

I am having SFTP server having incremental files from which I wish to load the tables. How to achieve this? 

Questions:

How to connect SFTP server using Incorta?

How to retrieve files at constant interval ?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi  Gautham Incorta does not connect directly to SFTP. Typically in this situation you would create a bash shell script that handles the ftp, saving, and archiving of files and schedule that using cron. At that point, you can schedule your Incorta schema load to take place after the cron job runs. There may be multiple ways to achieve your goal and this example is a fairly common one.

    Reply Like 1
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 26Views
  • 2 Following