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!
Best Answer
-
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"0
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有