hi, i need to connect to sap via odbc using workbench to get 530 millions data. these data must be stored in domo for data viz. they are range between 2023 until 2025 (still growing daily).
i came across multiple methods online but not sure if they do work/or if it's the best way: append? partition? upsert? workflow for automation? recursive dataflow? also to note that data in 2023 and 2024 are static, but data 2025 might still have updates, i just need the latest. if possible, could we also subtly detect if there're changes in 2023 and 2024 data, and replace accordingly? pls advise