File collector: Not able to read data from SFTP

[Shruti1]

Hello All,

Please help me with

File Collector Activity: Not able to read Data from SFTP

Reaason:

My Adobe Campaign is on my local machine 

and File collector activity needs to read the data from SFTP Path 

D:\psftp\filename.csv

but this SFTP Path ""D:\psftp\filename.csv""  is under server with with i am connecting using Remote Destop connection

Now I need to read "D:\psftp\filename.csv"" this file from sftp location and load the data in Workflow using data loading activity whcih is not in my local machine but adobe campaign is in my local machine

Can anyone plz plz help me how can i achieve the same

this is bit urgent for me

thanks in advance

[Darren_Bowers · Accepted solution]

Hi @Shruti1 - It sounds like you have a few options. From you post it sounds like your remote server is an actual SFTP server. But as you have remote access to the server, it might also be on your network?

Here are a couple of options:

1. You can map a drive from your local machine to the remote machine SFTP server folder and load into Campaign using a data loading activity from the local file system
2. If the remote server is actually an SFTP server, set up an SFTP connection to the remote server and use SFTP to access the file directly into the workflow
3. Set up some external ETL process to copy the file from the remote server to the local campaign instance

Cheers

Darren