Forum Discussion
The easiest way to do this is to use a combination of these Snaps:
File Reader > Excel Parser/Formatter > Oracle Insert
The File Reader Snap supports reading data from a variety of remote systems.
The Oracle Insert Snap can be used to load data from the upstream source into the Oracle table. Alternatively, for bulk data loading requirements, you could use the Oracle Bulk Load Snap
Thank you sriram.
I have gone through parameters of File reader snap, it supports different protocols but I had below query:
a) server path I am accessing is like : \\Rsc.aaaa.com\rdrive\D00\AllDept\SHARED\ComRead\MA\2018
in the snap Settings >File syntax is - ftp:// “path”
I am giving as ftp:\\Rsc.aaaa.com\rdrive\D00\RRRRRR\SHARED\ComRead\MA\2018
the snap is throwing error.
b) There are many files in that path, I want to read only a single file and the name of file is dynamic(changes periodically but will have a specific pattern). I don’t find an option in the file reader snap to mention file name, please suggest on this
Did you configure your REST snap with an error view? If so, see if the error_entity field in the error document tells you anything useful.
The error view output tells the same story, that it is forbidden. We are asking another engineer who has worked on external APIs as well. We aren’t sure if it is a security/whitelisting issue. I appreciate your help. I might get back here for questions again if there is anything else on the SnapLogic side.
Related Content
- 3 years ago
- 4 months ago
- 10 months ago
- 2 years ago