We are successfully able to use the Salesforce Plugin to pull data from Salesforce and drop the data into a local PostgreSQL database for analysis.
However, I'd like to get this data automatically updated on say a daily basis.
Is there anyone out there who has this worked out?
When I try to select the last data object in the dataflow and say refresh. We do not get a re-fresh from Salesforce.
And I'd prefer not to pull the entire dataset every time I want a refresh. Just the updated records.
I'd love to have a conversation with anyone who has figured out how to make this work well. Or anyone out there who is struggling a little bit with this like me.