Ask HN: how do you sync data between services?

I am currently researching tools/products/services to:

- integrate all our company data (from APIs, databases, csv, excel) in a data warehouse (i.e., AWS Redshift)

- sync our customer database with our newsletter/mailing provider (i.e., MailChimp)

- exchange standardized and proprietary file formats with our data providers via FTP and HTTP

I would be interested to learn more about how you deal with such tasks.

What other scenarios exist in your company?

How do your solutions look like?

What 3rd party of software/services do you make use of?