12-23-2022, 01:07 PM
If data is present in any file (eg.excel) and we need to make a table out of that excel file in the database,
we can use sftp reader- monitor combination and do the task easily.
Sftp monitor ->
- There are two paths, monitored path and copy path.
- It monitors the data coming to the monitored path and cut’s and paste it to the copy path.
- It sends only the path to the output.
Sftp reader ->
- It reads the data from the copy path.
- This is dependent component, sftp reader will not work without a sftp monitor.
we can use sftp reader- monitor combination and do the task easily.
Sftp monitor ->
- There are two paths, monitored path and copy path.
- It monitors the data coming to the monitored path and cut’s and paste it to the copy path.
- It sends only the path to the output.
Sftp reader ->
- It reads the data from the copy path.
- This is dependent component, sftp reader will not work without a sftp monitor.