We use Fivetran for big data sets but less frequent one-way syncs as you reference, and it is great but VERY expensive.