1 Reply Latest reply on Jun 9, 2016 1:23 AM by handat

    How to achieve FTP process to get files from external system.?

    3246766

      Hello

       

      I have a requirement where an external system sends a file and we have to load the file into staging table to go into Oracle base tables. Currently we are doing this process manually.

      Please suggest a method and how to automate this process. I need to give access to the external system guys to place files in a local directory from where I can load into staging table.

       

       

      Thanks

      raj

        • 1. Re: How to achieve FTP process to get files from external system.?
          handat

          Don't do FTP as that is insecure. Take advantage of your ssh daemon and create a user account that is limited to their home directory. Then give them access to that. You can also generate certificates for them so they can be able to access it with just their private key and you don't need to give them passwords. They can then use scp or winscp to copy files to your server using their key.