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 ?

2replies 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.

    Like 1
  • And how does one schedule the Load after a cron tab? I mean in a bash script, I can see if the SFTP workload but not sure show the below can be done":

    you can schedule your Incorta schema load to take place after the cron job runs.

    Like
Like Follow
  • Status Answered
  • 5 mths agoLast active
  • 2Replies
  • 99Views
  • 3 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.