โ05-23-2017 10:28 AM
Hi All,
Am trying to create two pipelines with below information,
SFTP Account created as Basic Auth,
User Name: ftpuser@52.86.106.54:22
File location path(sftp) which I verified is working when trying to access from browser,
Tried using google spreadsheet reader snap and could only see excel files but not csv. Is this the correct snap or should I use REST snap pack for it.
Thanks in advance!
-Arun
โ05-23-2017 11:45 AM
That worked but it takes me back to validation which runs forever,
Should I email customer support(support@snaplogic.com) to check for any performance issues.
โ05-23-2017 11:46 AM
Yes, that would be the correct action to take.
โ05-23-2017 04:49 PM
Hi - you need to remove the โCSV Formatterโ Snap - the โCSV Parserโ Snap converts the document stream to JSON, and the โSQL Server - insertโ Snap expects JSON as an input. You can see that the โCSV Parserโ Snapโs output is a diamond (binary), which wonโt connect up to the โSQL Server - insertโ's circle (JSON).
If the CSV is in the exact structure of the SQL Server table (same field names) then you might be able to connect the โCSV Parserโ directly to the โSQL Server - insertโ. Otherwise you can put a Mapper in between to map between the CSV structure and SQL Server table structure.
Good luck!