Forum Discussion
On Premises Data Gateway
Using a SQL database as data source, tried to publish and failed. Realised i need to set up On-Premises Data Gateway so installed on my laptop and managed to get this to work. Unfortunately realised after some time that when i turn my laptop off the dashboards ive shared using this data source stop working.
Background: I work for a very large company with very poor IT who have aboslutely no idea and i have basically no technical knowledge. What would i need to do/ask our IT to do in order to make this data source available 24/7.
(I have access to SQL sever and SSMS program through VDI)
Tia,
1. setup on-prem data gateway enterprise not personal
2. ask to have a dedicated vm able to communicate with your sql server network
3. ask to have enough resources to manage your workload (minimum requirement Install an on-premises data gateway | Microsoft Learn -> verify if your workload is not to much for minimum requirements and adjust in case)
4. ask this vm to be always on
5. ask to patch the vm on a regular basis
6. ask to patch che gateway on a regular basis
7. verify if you need and can create a cluster of multiple vms to grant HA of your gateway
2 Replies
1. setup on-prem data gateway enterprise not personal
2. ask to have a dedicated vm able to communicate with your sql server network
3. ask to have enough resources to manage your workload (minimum requirement Install an on-premises data gateway | Microsoft Learn -> verify if your workload is not to much for minimum requirements and adjust in case)
4. ask this vm to be always on
5. ask to patch the vm on a regular basis
6. ask to patch che gateway on a regular basis
7. verify if you need and can create a cluster of multiple vms to grant HA of your gateway
Hi Vik89uk ,
The gateway is suitable for installing on stable online machines, when you open reports based on Direct Query and Live connection, you need to load data through the gateway.
You can refer to Install an on-premises data gateway | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
