I think it's a very simple thing I am missing:
I have a database on-premises with 4 TB of data in one table - searching in that table using the PK and some other columns is fast and I only need 10 rows on a form as a sub-grid.
I read about the "On-Premises Data Gateway" that can be added in make.powerapps.com to the "Gateways" section and there is a matching database connector.
After installing and connecting the gateway I thought I have some type of "proxy" in my network, so that I can query data on-prem data in my common data model (now known as Microsoft Dataverse) using a virtual entity that simply points to that gateway. At least that would be the way how I would start implementing such a gateway.
What I can do is: import data using that connection into my CRM environment and refresh that data each 10 minutes - but, as I wrote above: the table of interest is HUGE and massive. I need something that can use the data gateway to query the data in realtime from the on-premises table instead of copying the data into the CRM environment.
So: how can I create a virtual entity that uses the "On-Premises Data Gateway" to query data from on-prem data sources on demand? Is there really no solution for that? Should I implement something by myself?
Currently, I do NOT have the opportunity to open ports from outside to my on-prem database or implement a custom service to act as a proxy.
