Automate Data import from an SFTP location

[shwetar]

Hi, 

i am looking for possible ways to automate data imports into marketo from an SFTP location. the client has a couple of external systems which sends us files every 24 hours.  These files need to be automatically processed and added to the marketo DB ? Does marketo now have a way to support the same.

[SanfordWhiteman · Accepted solution]

Hi,

There's no built-in SFTP awareness to draw on.

But you can build a lightweight app that retrieves the file over SFTP and imports it — probably after translating at least the field names, unless you get it perfectly formatted from the external system/s — using the Marketo Bulk Import API.

We've got a few such setups running for clients.

[shwetar]

thank you for your response.