On-premises data gateway management via PowerShell (Public Preview)
We are happy to announce the public preview of a new set of PowerShell cmdlets which will enable automation of gateway management tasks. Please review the online documentation for additional details
Note: These cmdlets require PowerShell core 6.2.2 or higher
The cmdlets are available on PowerShell Gallery and can be installed in an elevated PowerShell session:
Install-Module -Name DataGateway
The entre list of cmdlets can be found using the following cmd
Get-Command -Module DataGateway*
Examples and descriptions are included in the cmdlets and you can access them using:
We also plan to make an online version of the documentation available for these cmdlets soon.
Following are PowerShell cmdlets which can be used for administering gateway clusters and members:
- Get-DataGatewayCluster: Lists all gateway clusters for the current user or a specific one based on the passed parameters
- Get-DataGatewayClusterStatus: Returns the cluster status along with additional properties
- Get-DataGatewayInstaller: Lists users authorized to install and register gateways within the tenant
- Get-DataGatewayTenantPolicy: Returns the gateway installation and registration policy for the tenant.
- Add-DataGatewayClusterUser: Add a specific user to a gateway cluster for specific permissions
- Set-DataGatewayCluster: Set properties of an existing gateway cluster
- Set-DataGatewayInstaller: Modify list of users who can install and register new gateways on the tenant
- Set-DataGatewayTenantPolicy: Set the gateway installation and registration policy for the tenant
- Remove-DataGatewayCluster: Remove a gateway cluster
- Remove-DataGatewayClusterMember: Remove a gateway member from the corresponding gateway cluster
- Remove-DataGatewayClusterUser: Remove a user from a gateway cluster
In addition, wherever applicable, these cmdlets can be run under a tenant level scope. This would of course require the user to be a global Office 365 admin or a Power BI service admin. For instance, the following cmdlet would return all gateways within your tenant.
Get-DataGatewayCluster -Scope Organization
Similarly, running the same command without the scope parameter or with the “Individual” scope would return the list of gateways, you are administrator of.
Get-DataGatewayCluster -Scope Individual
Another new cmdlet, which allows tenant admins to restrict installation of on-premises data gateway ins standard mode is as follows. The tenant admin can then allow specific users to install using the Set-DataGatewayInstaller cmdlet.
Set-DataGatewayTenantPolicy -ResourceGatewayInstallPolicy Restricted
Only the following cmdlets support the scope of Organization:
We will be enriching these cmdlets with additional management operations in the upcoming releases.
Note: You have the option of using Azure Data Studio with the PowerShell extension to work with these cmdlets.
Please continue to send us feedback for what new capabilities you’d like to see in the future.