Skip to content

Latest commit

 

History

History
200 lines (157 loc) · 4.8 KB

Update-TabularCubeDataSource.md

File metadata and controls

200 lines (157 loc) · 4.8 KB
external help file Module Name online version schema
DeployCube-help.xml
DeployCube
2.0.0

Update-TabularCubeDataSource

SYNOPSIS

Updates the tabular cube's connection to the source SQL database.

SYNTAX

Update-TabularCubeDataSource [-Server] <String> [-CubeDatabase] <String> [[-Credential] <PSCredential>]
 [-SourceSqlServer] <String> [-SourceSqlDatabase] <String> [-ImpersonationMode] <String>
 [[-ImpersonationAccount] <String>] [[-ImpersonationPwd] <String>] [[-DataSource] <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.

EXAMPLES

EXAMPLE 1

Update-TabularCubeDataSource -Server localhost -CubeDatabase MyCube -SourceSqlServer localhost -SourceSqlDatabase MyDB -ImpersonationMode ImpersonateServiceAccount;

EXAMPLE 2

Update-TabularCubeDataSource -Server localhost -CubeDatabase MyCube -SourceSqlServer localhost -SourceSqlDatabase MyDB -ImpersonationMode ImpersonateAccount -ImpersonationAccount "DOMAIN\user" -ImpersonationPwd "Password" -DataSource DataSource2;

PARAMETERS

-Server

SSAS Server Name or IP address. Include the instance name and port if necessary (e.g. myserver\\myinstance,myport)

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-CubeDatabase

The name of the deployed tabular cube database.

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Credential

A PSCredential object containing the credentials to connect to the AAS server.

Type: PSCredential
Parameter Sets: (All)
Aliases:

Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SourceSqlServer

The name of the source SQL Server server or its IP address. Include the instance name and port if necessary.

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 4
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SourceSqlDatabase

The name of the database which will act as a source of data for the tabular cube database.

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ImpersonationMode

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.

Type: String
Parameter Sets: (All)
Aliases: AuthenticationKind

Required: True
Position: 6
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ImpersonationAccount

The username of the account that will be used to connect to the SQL Server database. Required for ImpersonationMode='ImpersonateAccount'.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 7
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ImpersonationPwd

The password of the account that will be used to connect to the SQL Server database. Required for ImpersonationMode='ImpersonateAccount'.

Type: String
Parameter Sets: (All)
Aliases: ImpersonationPassword

Required: False
Position: 8
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-DataSource

The name of the data source that will be updated. Optional, use when there are multiple data sources in the deployed tabular cube database.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 9
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

Returns true if the cube's data source was updated successfully.

NOTES

Written by (c) Dr. John Tunnicliffe, 2019-2021 https://github.com/DrJohnT/DeployCube This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT

RELATED LINKS

https://github.com/DrJohnT/DeployCube