how can I use salesforce with upsert to create a monthly historical data?

Reply
Highlighted
Yellow Belt

how can I use salesforce with upsert to create a monthly historical data?

Hello Beautiful People - 

 

how can I use salesforce with upsert to create a monthly historical data?

 

basically, we want to have a month end snapshot every month,

while during the new month, data gets updated.

 

Thanks!


Accepted Solutions
Highlighted
Major Red Belt

Re: how can I use salesforce with upsert to create a monthly historical data?

@Hey @WorldWarHulk ,

 

It sounds like you're describing two distinct things.  UPSERT is UPSERT.  Taking a monthly snapshot is a separate activity that you could implement with ETL, Data Assembler or Scripting.

 

Does your SFDC data require UPSERT? If yes, you can implement UPSERT using the Java CLI if it's not natively available in the connector... just be careful during implementation because dis-entangling poor configurations can involve a lot of back and forth with support.

EDIT:: sorry, just saw that this question is related to something you previously posted about.  If you haven't used UPSERT before AND your data volume is sufficiently low, I think I'd recommend you start your implementation with a recursive query as @GrantSmith  recommended.  

 

UPSERT and the like are very powerful tools but they don't give you a lot of leeway for error, so if you don't have access to someone who's implemented it before, it can be risky to put into production.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Highlighted
Major Red Belt

Re: how can I use salesforce with upsert to create a monthly historical data?

@Hey @WorldWarHulk ,

 

It sounds like you're describing two distinct things.  UPSERT is UPSERT.  Taking a monthly snapshot is a separate activity that you could implement with ETL, Data Assembler or Scripting.

 

Does your SFDC data require UPSERT? If yes, you can implement UPSERT using the Java CLI if it's not natively available in the connector... just be careful during implementation because dis-entangling poor configurations can involve a lot of back and forth with support.

EDIT:: sorry, just saw that this question is related to something you previously posted about.  If you haven't used UPSERT before AND your data volume is sufficiently low, I think I'd recommend you start your implementation with a recursive query as @GrantSmith  recommended.  

 

UPSERT and the like are very powerful tools but they don't give you a lot of leeway for error, so if you don't have access to someone who's implemented it before, it can be risky to put into production.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.