AWS - postgres to postgres - how to?

I’m looking to use DBT for a load and transform of data from a transactional postgres database to a simple DWH in a separate postgres instance.

The transactional db is a postgres instance running on its own server, whereas the DWH will be an RDS instance.

What would be the best way to connect the 2 with transforms etc. all don by DBT in the middle?