SOLVED

Automate Data import from an SFTP location

Go to solution
shwetar
Level 1

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.

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Automate Data import from an SFTP location

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.

View solution in original post

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Automate Data import from an SFTP location

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
Level 1

Re: Automate Data import from an SFTP location

thank you for your response.