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 ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
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 ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive