Automate Data import from an SFTP location | Community
Skip to main content
Employee
May 19, 2020 3:31 AM UTC
Solved

Automate Data import from an SFTP location

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
May 19, 2020 3:36 AM UTC

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.

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
May 19, 2020 3:36 AM UTC

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.

Translate
shwetarAuthor
Employee
May 19, 2020 4:52 AM UTC

thank you for your response.  

Translate