OPENQUERY acts as a portal for data storage on external servers, enabling SQL Server to communicate with various databases spread over the network.

The creation of a linked server, which serves as a link between the local SQL Server instance and the remote data source, is the fundamental idea underlying OPENQUERY. OPENQUERY enables the execution of SQL statements on the distant server directly from within SQL Server, as if the data were local, once the linked server is configured.

Learn more: https://blog.devart.com/openquery-in-sql-server.html