< Back
Update-TabularCubeDataSource
Post
NAME Update-TabularCubeDataSource
SYNOPSIS
Updates the tabular cube's connection to the source SQL database.
SYNTAX
Update-TabularCubeDataSource [-Server] <String> [-CubeDatabase] <String> [-SourceSqlServer] <String>
[-SourceSqlDatabase] <String> [-ImpersonationMode] <String> [[-ImpersonationAccount] <String>]
[[-ImpersonationPassword] <String>] [<CommonParameters>]
DESCRIPTION
Connects to the deployed tabular cube and updates the connection to the source SQL database.
Supports the newer PowerQuery style tabular cubes with CompatibilityLevel = 1400.
PARAMETERS
-Server <String>
SSAS Server Name or IP address. Include the instance name and port if necessary (e.g.
myserver\\\\myinstance,myport)
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CubeDatabase <String>
The name of the deployed tabular cube database.
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SourceSqlServer <String>
The name of the source SQL Server server or its IP address. Include the instance name and port if necessary.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SourceSqlDatabase <String>
The name of the database which will act as a source of data for the tabular cube database.
Required? true
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ImpersonationMode <String>
Defines how the cube will connect to the data source. Possible options are 'ImpersonateServiceAccount' which
connects to the SQL Server database using ,
or 'ImpersonateAccount' which uses a specific username/password. When using 'ImpersonateAccount' it is best
to use a domain based service account with a static password.
Required? true
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ImpersonationAccount <String>
The username of the account that will be used to connect to the SQL Server database. Required for
ImpersonationMode='ImpersonateAccount'.
Required? false
Position? 6
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ImpersonationPassword <String>
The password of the account that will be used to connect to the SQL Server database. Required for
ImpersonationMode='ImpersonateAccount'.
Required? false
Position? 7
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Returns true if the cube's data source was updated successfully.
NOTES
Written by (c) Dr. John Tunnicliffe, 2019 https://github.com/DrJohnT/DeployCube
This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Update-TabularCubeDataSource -Server localhost -CubeDatabase MyCube -SourceSqlServer localhost
-SourceSqlDatabase MyDB -ImpersonationMode ImpersonateServiceAccount;
RELATED LINKS
https://github.com/DrJohnT/DeployCube
SYNOPSIS
Updates the tabular cube's connection to the source SQL database.
SYNTAX
Update-TabularCubeDataSource [-Server] <String> [-CubeDatabase] <String> [-SourceSqlServer] <String>
[-SourceSqlDatabase] <String> [-ImpersonationMode] <String> [[-ImpersonationAccount] <String>]
[[-ImpersonationPassword] <String>] [<CommonParameters>]
DESCRIPTION
Connects to the deployed tabular cube and updates the connection to the source SQL database.
Supports the newer PowerQuery style tabular cubes with CompatibilityLevel = 1400.
PARAMETERS
-Server <String>
SSAS Server Name or IP address. Include the instance name and port if necessary (e.g.
myserver\\\\myinstance,myport)
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CubeDatabase <String>
The name of the deployed tabular cube database.
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SourceSqlServer <String>
The name of the source SQL Server server or its IP address. Include the instance name and port if necessary.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SourceSqlDatabase <String>
The name of the database which will act as a source of data for the tabular cube database.
Required? true
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ImpersonationMode <String>
Defines how the cube will connect to the data source. Possible options are 'ImpersonateServiceAccount' which
connects to the SQL Server database using ,
or 'ImpersonateAccount' which uses a specific username/password. When using 'ImpersonateAccount' it is best
to use a domain based service account with a static password.
Required? true
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ImpersonationAccount <String>
The username of the account that will be used to connect to the SQL Server database. Required for
ImpersonationMode='ImpersonateAccount'.
Required? false
Position? 6
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ImpersonationPassword <String>
The password of the account that will be used to connect to the SQL Server database. Required for
ImpersonationMode='ImpersonateAccount'.
Required? false
Position? 7
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Returns true if the cube's data source was updated successfully.
NOTES
Written by (c) Dr. John Tunnicliffe, 2019 https://github.com/DrJohnT/DeployCube
This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Update-TabularCubeDataSource -Server localhost -CubeDatabase MyCube -SourceSqlServer localhost
-SourceSqlDatabase MyDB -ImpersonationMode ImpersonateServiceAccount;
RELATED LINKS
https://github.com/DrJohnT/DeployCube