Schleupen.CS.AP.BI.DataWarehouse.PowerShell

Create-CSDataWarehouseViewOrTable -SessionToken <String> -SqlCommand <String> [<CommonParameters>]

Create-CSDataWarehouseViewOrTable -SessionToken <String> -FullFileName <String> 
[<CommonParameters>]

Create-CSDataWarehouseViewOrTable -SessionToken $sessionToken -sqlCommand $sqlCommand

Delete-CSDataWarehouseDdlInfo [-SessionToken] <String> [-Ids] <Object> [<CommonParameters>]

Delete-CSDataWarehouseDdlInfo -SessionToken $st -Ids $info.Id

Delete-CSDataWarehouseEtlInfo [-SessionToken] <String> [-Ids] <Object> [<CommonParameters>]

Delete-CSDataWarehouseEtlInfo -SessionToken $st -Ids $info.Id

Initialize-CSDataWarehouse [-SessionToken] <String> [[-DomainDescriptionName] <String>] 
[-RecreateAllTablesAndViews] [<CommonParameters>]

Initialize-CSDataWarehouse -SessionToken $st

Initialize-CSDataWarehouseEntityInfos [-SessionToken] <String> [<CommonParameters>]

Initialize-CSDataWarehouseEntityInfos -SessionToken $st

Initialize-CSDataWarehouseOnAllRelevantElements [-RecreateAllTablesAndViews] [<CommonParameters>]

Initialize-CSDataWarehouseOnAllRelevantElements

Invoke-CSDataWarehouseCreateOrUpdateDdlInfo -SessionToken <String> -Bezeichnung <String> [-Bereich 
<String>] -Layer <String> -DdlSql <String> [<CommonParameters>]

Invoke-CSDataWarehouseCreateOrUpdateDdlInfo -SessionToken <String> -Bezeichnung <String> [-Bereich 
<String>] -Layer <String> -DdlSqlFullFileName <String> [<CommonParameters>]

$info = CSDataWarehouseCreateOrUpdateDdlInfo -SessionToken $sessionToken -Bezeichnung Beispiel -TableName Zieltabelle -Layer DataMart -DdlSql 'INSERT INTO Zieltabelle SELECT * FROM Quelltabelle'

Invoke-CSDataWarehouseCreateOrUpdateEtlInfo -SessionToken <String> -Bezeichnung <String> 
[-Beschreibung <String>] -TableName <String> -Layer <String> [-WithTruncate] -EtlSql <String> 
[-ExecutionIntervalMinutes <Int32>] [-PrecedingEtlInfoId <Object>] [-IsDisabled] [-SourceSchema 
<String>] [-TargetSchema <String>] [<CommonParameters>]

Invoke-CSDataWarehouseCreateOrUpdateEtlInfo -SessionToken <String> -Bezeichnung <String> 
[-Beschreibung <String>] -TableName <String> -Layer <String> [-WithTruncate] -EtlSqlFullFileName 
<String> [-ExecutionIntervalMinutes <Int32>] [-PrecedingEtlInfoId <Object>] [-IsDisabled] 
[-SourceSchema <String>] [-TargetSchema <String>] [<CommonParameters>]

$info = CSDataWarehouseCreateOrUpdateEtlInfo -SessionToken $sessionToken -Bezeichnung Beispiel -TableName Zieltabelle -Layer DataMart -EtlSql 'INSERT INTO Zieltabelle SELECT * FROM Quelltabelle'

Invoke-CSDataWarehouseSqlScript [-SessionToken] <String> [-Script] <String> [<CommonParameters>]

Invoke-CSDataWarehouseSqlScript -SessionToken $sessionToken -Script '-- Example'

New-CSDataWarehouseDdlInfo -Bezeichnung <String> [-Bereich <String>] -Layer <String> -DdlSql 
<String> [<CommonParameters>]

New-CSDataWarehouseDdlInfo -Bezeichnung <String> [-Bereich <String>] -Layer <String> 
-DdlSqlFullFileName <String> [<CommonParameters>]

$info = New-CSDataWarehouseDdlInfo -Bezeichnung Beispiel -TableName Zieltabelle -Layer DataMart -DdlSql 'INSERT INTO Zieltabelle SELECT * FROM Quelltabelle'

New-CSDataWarehouseDomainDescription [-SessionToken] <String> [-FileList] <FileInfo[]> 
[-Description] <String> [<CommonParameters>]

New-CSDataWarehouseDomainDescription -SessionToken $sessionToken -FileList gci -Path $scriptDir | Where-Object { $_.Name -match 'Schleupen.CS.AP.ZD.Personen.Personenrolle_3.0.json' } -Description "Personenmodell"

New-CSDataWarehouseEtlInfo -Bezeichnung <String> [-Beschreibung <String>] -TableName <String> 
-Layer <String> [-WithTruncate] -EtlSql <String> [-ExecutionIntervalMinutes <Int32>] 
[-PrecedingEtlInfoId <Object>] [-IsDisabled] [-SourceSchema <String>] [-TargetSchema <String>] 
[<CommonParameters>]

New-CSDataWarehouseEtlInfo -Bezeichnung <String> [-Beschreibung <String>] -TableName <String> 
-Layer <String> [-WithTruncate] -EtlSqlFullFileName <String> [-ExecutionIntervalMinutes <Int32>] 
[-PrecedingEtlInfoId <Object>] [-IsDisabled] [-SourceSchema <String>] [-TargetSchema <String>] 
[<CommonParameters>]

$info = New-CSDataWarehouseEtlInfo -Bezeichnung Beispiel -TableName Zieltabelle -Layer DataMart -EtlSql 'INSERT INTO Zieltabelle SELECT * FROM Quelltabelle'

Remove-CSDataWarehouseDdlInfoByBereich [-SessionToken] <String> [-Bereich] <String> 
[<CommonParameters>]

Remove-CSDataWarehouseDdlInfoByBereich -SessionToken $st -Bereich VPA

Remove-CSDataWarehouseDomainPatch [-SessionToken] <String> [-DomainDescriptionName] <String> 
[<CommonParameters>]

Remove-CSDataWarehouseDomainPatch -SessionToken $st -DomainDescriptionName 'Schleupen.CS.AP.ZD.Personen.Person_3.8'

Remove-CSDataWarehouseEtlInfoByLayer [-SessionToken] <String> [-Layer] <String> 
[<CommonParameters>]

Remove-CSDataWarehouseEtlInfoByLayer -SessionToken $st -Layer BusinessVault

Remove-CSDataWarehouseEtlInfoByLayerAndSourceSchema [-SessionToken] <String> [-Layer] <String> 
[-SourceSchema] <String> [<CommonParameters>]

Remove-CSDataWarehouseEtlInfoByLayer -SessionToken $st -Layer DataMart -SourceSchema ap_bi_dop

Save-CSDataWarehouseDdlInfo [-SessionToken] <String> [-DdlInfos] <Object> [<CommonParameters>]

Save-CSDataWarehouseDdlInfo -SessionToken $st -DdlInfos $info

Save-CSDataWarehouseEtlInfo [-SessionToken] <String> [-EtlInfos] <Object> [<CommonParameters>]

Save-CSDataWarehouseEtlInfo -SessionToken $st -EtlInfos $info

Select-CSDataWarehouseDdlInfo [-SessionToken <String>] [-MaxResults <Int32>] -Layer <String> 
[<CommonParameters>]

Select-CSDataWarehouseDdlInfo [-SessionToken <String>] [-MaxResults <Int32>] -Bereich <String> 
[-Layer <String>] [<CommonParameters>]

Select-CSDataWarehouseDdlInfo [-SessionToken <String>] [-MaxResults <Int32>] -Bezeichnung <String> 
[-Layer <String>] [<CommonParameters>]

Select-CSDataWarehouseDdlInfo [-SessionToken <String>] [-MaxResults <Int32>] [<CommonParameters>]

Select-CSDataWarehouseDdlInfo -SessionToken $st

Select-CSDataWarehouseDdlInfo -SessionToken $st -Bezeichnung "Beispiel"

Select-CSDataWarehouseDdlInfo -SessionToken $st -Layer BusinessVault

Select-CSDataWarehouseEtlInfo [-SessionToken <String>] [-MaxResults <Int32>] -Layer <String> 
[<CommonParameters>]

Select-CSDataWarehouseEtlInfo [-SessionToken <String>] [-MaxResults <Int32>] -Bezeichnung <String> 
[<CommonParameters>]

Select-CSDataWarehouseEtlInfo [-SessionToken <String>] [-MaxResults <Int32>] [<CommonParameters>]

Select-CSDataWarehouseEtlInfo -SessionToken $st

Select-CSDataWarehouseEtlInfo -SessionToken $st -Bezeichnung "Beispiel"

Select-CSDataWarehouseEtlInfo -SessionToken $st -Layer BusinessVault

Select-CSDataWarehouseProtocolInfo [-SessionToken] <String> [[-MaxResults] <Int32>] 
[[-ErstelltVon] <Object>] [[-ErstelltBis] <Object>] [<CommonParameters>]

Select-CSDataWarehouseProtocolInfo -SessionToken $st

Select-CSDataWarehouseProtocolInfo -SessionToken $st -MaxResults 50

Select-CSDataWarehouseProtocolInfo -SessionToken $st -ErstelltVon '01.01.2023 00:00:00' -ErstelltBis '02.01.2023 00:00:00'

Select-CSDataWarehouseState [-SessionToken] <String> [<CommonParameters>]

Select-CSDataWarehouseState

Select-CSDataWarehouseTableFieldsAsControllerCode [-SessionToken] <String> [-Schemaname] <String> 
[-Tablename] <String> [<CommonParameters>]

Select-CSDataWarehouseTableFieldsAsControllerCode -SessionToken $st -$Schemaname zdk -Tablename Kreditinstitut

Select-CSDataWarehouseTableFieldsAsJson [-SessionToken] <String> [-Schemaname] <String> 
[-Tablename] <String> [<CommonParameters>]

Select-CSDataWarehouseTableFieldsAsJson -SessionToken $st -$Schemaname zdk -Tablename Kreditinstitut

Set-CSDataWarehouseDomainPatch [-SessionToken] <String> [-DomainDescriptionName] <String> 
[[-PatchSql] <String>] [<CommonParameters>]

Set-CSDataWarehouseDomainPatch -SessionToken $st -DomainDescriptionName 'Schleupen.CS.AP.ZD.Personen.Person_3.8' -PatchSql '-- SQL-Skript --'

Set-CSDataWarehouseState [[-Dummy] <String>] [<CommonParameters>]

Select-CSDataWarehouseState

Test-DomainDescriptionIsValid [-Filepath] <String> [<CommonParameters>]

Test-DomainDescriptionIsValid -Filepath "c:\temp\domain_description.json"

Test-DWHAdapterConfigurations [-withoutException] [-withAutocomplete] [[-sig] <String>] 
[[-adapterName] <String>] [[-parameters] <Object>] [[-errors] <Collection`1>] [[-elementIds] 
<Collection`1>] [[-systemUsageIds] <Collection`1>] [<CommonParameters>]

# Prüft die DWHZDPAdapter Konfigurationen ohne Fehler auszugeben und legt fehlende Jobs und Konfigurationen an.

Test-DWHAllSIAdapterConfigurations [-withoutException] [-withAutocomplete] [[-elementIds] 
<Collection`1>] [[-systemUsageIds] <Collection`1>] [<CommonParameters>]

# Testet alle DWH SI Konfigurationen. Es werden keine fehler ausgegeben. Fehlende Konfigurationen werden angelegt.

Update-DWHAdapterConfiguration [[-sig] <String>] [[-elementConfigurationParameters] <Object>] 
[-createIfNotExists] [<CommonParameters>]

# Prüft die DWHZDPAdapter Konfigurationen ohne Fehler auszugeben und legt fehlende Jobs und Konfigurationen an.

Update-DWHAllAdapterConfigurations [-createIfNotExists] [<CommonParameters>]

# Aktualisiert die Konfiguration aller DWH-Adapter oder legt sie an, falls sie noch nicht existiert.

Write-CSDemandsForDataWarehouse [-SessionToken] <String> [-Recursive] [-WithService] [[-BatchSize] 
<Int32>] [<CommonParameters>]

Write-CSDemandsForDataWarehouse -SessionToken $st

Write-CSDemandsForDataWarehouse -SessionToken $st -WithService -BatchSize 1000

Write-CSDemandsForDataWarehouse -SessionToken $st -Recursive