We are trying to connect snowflake to marketo to retrieve on a daily basis all the campaigns data and stored into our database. But we don´t see the way to do that... Can somebody give us a hand?
Thanks for your help!
Start at developer.marketo.com.
This is far too expansive a question for a simple Community thread, though.
If you don't have a lot of tech resources to build/maintain custom ELT, then you may want to look at services like Stitch or Fivetran. Both have Marketo and Snowflake connectors out of the box and a non-developer can be up and running in an hour or two.
It would also be a good idea to reach out to your Customer Success Manager at Marketo so that they can pull in the relevant teams to help assist with your questions regarding integrations.
Could you please help how you integrated the snowflake with Marketo ?
I believe there is no direct intergration between Marketo and Snowflake. You would need to leverage the Marketo APIs (example we use the Bulk REST API to extract data via AWS and store it into snowflake - https://developers.marketo.com/rest-api/bulk-extract/) to extract the data out of Marketo and push it into snowflake, and vice versa, if you are looking to update records or objects in Marketo, you would need to leverage the APIs once again to update Marketo.
Hope that helps!