I have a database that is in a private network. The database is not publicly accessible (you have to be on the local network to access it). We would like to use an ETL tool like FiveTran to export the data and load it into another database that is in a different network (in a near real-time manner ~5-10 mins).
I image this is a problem what many have faced before and I wanted to hear what other people have done in the past or hear other solutions that people would be willing to suggest. Are there any ETL tools that support VPN connections?
Source database: postgres Target database: Snowflake