SqlBIManager

1.1.0.0

SqlBIManager.psd1

                                #

# Module manifest for module 'SqlBIManager'

#

# Generated by: Administrator

#

# Generated on: 26-1-2018

#

@{

# Script module or binary module file associated with this manifest.

RootModule = 'SqlBIManager.psm1'

# Version number of this module.

ModuleVersion = '1.1.0.0'

# Supported PSEditions

# CompatiblePSEditions = @()

# ID used to uniquely identify this module

GUID = '4417c6ed-df72-46e7-9602-dac182f9a37a'

# Author of this module

Author = 'Sjoerd van Noort'

# Company or vendor of this module

CompanyName = 'Rubicon'

# Copyright statement for this module

Copyright = '(c) 2018 Sjoerd van Noort. All rights reserved.'

# Description of the functionality provided by this module

Description = 'Deployment of SSAS tabular databases and SSIS packages. Requires SqlServer and ActiveDirectory modules.'

# Minimum version of the Windows PowerShell engine required by this module

PowerShellVersion = '5.0'

# Name of the Windows PowerShell host required by this module

# PowerShellHostName = ''

# Minimum version of the Windows PowerShell host required by this module

# PowerShellHostVersion = ''

# Minimum version of Microsoft .NET Framework required by this module. This prerequisite is valid for the PowerShell Desktop edition only.

DotNetFrameworkVersion = '4.5'

# Minimum version of the common language runtime (CLR) required by this module. This prerequisite is valid for the PowerShell Desktop edition only.

# CLRVersion = ''

# Processor architecture (None, X86, Amd64) required by this module

# ProcessorArchitecture = ''

# Modules that must be imported into the global environment prior to importing this module

RequiredModules = @('SqlServer')

# Assemblies that must be loaded prior to importing this module

# RequiredAssemblies = @()

# Script files (.ps1) that are run in the caller's environment prior to importing this module.

# ScriptsToProcess = @()

# Type files (.ps1xml) to be loaded when importing this module

# TypesToProcess = @()

# Format files (.ps1xml) to be loaded when importing this module

# FormatsToProcess = @()

# Modules to import as nested modules of the module specified in RootModule/ModuleToProcess

# NestedModules = @()

# Functions to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no functions to export.

FunctionsToExport = @('Use-SbmLog'

    , 'Write-SbmLogInformation'

    , 'Connect-ASServer'

    , 'ConvertTo-AsmlDatabase'

    , 'Get-ASDatabase'

    , 'Clear-ASDatabase'

    , 'Publish-AsmlDatabase'

    , 'Read-AsmlDatabase'

    , 'Write-AsmlDatabase'

    , 'Write-ASDatabaseCreateReplaceScript'

    , 'Set-AsmlDatasource'

    , 'Add-AsmlRoleMember'

    , 'Clear-AsmlRoleMember'

    , 'ConvertTo-AsmlRoleMember'

    , 'Select-AsmlRoleMember'

    , 'Connect-SsisCatalog'

    , 'Get-SsisFolder'

    , 'Get-SsisProject'

    , 'Publish-SsisProject'

    , 'Export-SsisProject'

    , 'Get-SsisParameter'

    , 'Set-SsisParameter'

    , 'Clear-SsisParameter'

    , 'Get-SsisEnvironment'

    , 'Get-SsisEnvironmentVariable'

    , 'Set-SsisEnvironmentVariableValue'

)

# Cmdlets to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no cmdlets to export.

CmdletsToExport = @()

# Variables to export from this module

VariablesToExport = '*'

# Aliases to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no aliases to export.

AliasesToExport = @()

# DSC resources to export from this module

# DscResourcesToExport = @()

# List of all modules packaged with this module

# ModuleList = @()

# List of all files packaged with this module

# FileList = @()

# Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell.

PrivateData = @{

    PSData = @{

        # Module dependency on modules not in PSGallery

        ExternalModuleDependencies = @('ActiveDirectory')

        # Tags applied to this module. These help with module discovery in online galleries.

        Tags = @('Deploy','Deployment', 'SSAS', 'SSIS', "SQL", "Continuous", "Delivery", "Tabular", "asdatabase", "ispac")

        # A URL to the license for this module.

        # LicenseUri = ''

        # A URL to the main website for this project.

        # ProjectUri = ''

        # A URL to an icon representing this module.

        # IconUri = ''

        # ReleaseNotes of this module

        ReleaseNotes = 'Added examples for diffent scenarios deploying ssas tabular databases; setting connection strings, removing, replacinf adding role members.

        Added examples automating get latest from TFS, Building visual studio solutions, generating SQL migration scripts.

        Publish-AsmlDatabase now has "RetainRoleMembers" and "RetainDataSources" switches enabling to publish the database schema from development, while keeping

        the configured connection details and role members on the UAT or production server.

        Added Clear-AsmlRoleMember to avoid carrying development users to UAT or production server.

        Get-SsisParameter now returns extra column "ParameterValue" containing derived parameter value (design default, literal value, or referenced environment variable).

        Added Set-SsisParameter to set project or package parameter value.

        Added Clear-SsisParameter to reset project or package parameter to design default.

        Added Get-SsisEnvironment

        Added Get-SsisEnvironmentVariable

        Added Set-SsisEnvironmentVariableValue

        Fixed setting memberName in ConvertTo-AsmlRoleMember'

    } # End of PSData hashtable

} # End of PrivateData hashtable

# HelpInfo URI of this module

# HelpInfoURI = ''

# Default prefix for commands exported from this module. Override the default prefix using Import-Module -Prefix.

# DefaultCommandPrefix = ''

}