Performance impact on database from remote source connection

[Ming_de]

Hi everyone,

For context, I need to aggregate data across multiple databases into an HDI container. To achieve this, I am creating remote source connections from several databases to a single database. This single database hosts an HDI container that facilitates data aggregation.

Currently, there will be around 4 databases (and corresponding remote source connections), with the possibility of more in the future. These 4 databases will frequently perform INSERT operations, and given that the remote source connections are real-time, these changes will be reflected in the single database as well.

I want to understand if there will be any performance-related issues for the single database under this setup. Any opinions or help would be greatly appreciated.

Thanks!