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