If the source of truth is SAP, why not just build a service that gets the data you need from SAP?
> has to be imported all at once due to some issue I don't understand that prevents incremental updates.
Has to? Seems like a straightforward problem to solve. Might be good to understand why this “isn’t possible”
> These deployments take place at 2am and require multiple people to be involved.
Big red flag. If it’s a computer process it can be automated. Deployment should be automated. It is totally stupid to have people awake at 2am doing deployments.