Hy,
to find a well fitting design we need also to consider whether
- the SQL server is on the cloud or OnPrem
- what is the volumn of data, or estimated number of records, peak and average
- what means periodically (every min, once every week ...)
- what kind of data are transported (master data, transactions, ...)
- is there a standard for the data to transport
Best is to know as an example would be: ~100 MB (or ~1.000 rows) of all open Purchase lines, once a hour
