Cake.SSRS

Cake.SSRS is set of aliases for Cake that help simplify deploying objects to SQL Server Reporting Services. Release notes can be found here.

Information

	Stable	Pre-release
GitHub Release	-
NuGet

Build Status

Develop	Master

Code Coverage

Discussion

If you have questions, search for an existing one, or create a new discussion on the Cake GitHub repository, using the Extension Q&A category.

About

This Addin only contains the functionality needed to upload the most common object types to SSRS (Reports, DataSets, and DataSources). Pull requests are accepted if you need additional functionality. Don't forget to include the unit tests with it.

Usage

Creating a Folder

SsrsCreateFolder("AdventureWorks", "/", new SsrsConnectionSettings
    {
        ServiceEndpoint = "http://localhost/reportserver/ReportService2010.asmx",
        UseDefaultCredentials = true,
		ProxyCredentialType = ProxyCredentialType.Ntlm,
		ImperonsationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation,
		SecurityMode = SecurityMode.TransportCredentialOnly
    });

Upload a Report

SsrsUploadReport("./path/to/report.rdl", "/AdventureWorks",
    new Dictionary<string, string>
    {
            ["Description"] = "Description for the Report"
    },
    new SsrsConnectionSettings
    {
        ServiceEndpoint = "http://localhost/reportserver/ReportService2010.asmx",
        UseDefaultCredentials = true,
		ProxyCredentialType = ProxyCredentialType.Ntlm,
		ImperonsationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation,
		SecurityMode = SecurityMode.TransportCredentialOnly
    });

Upload a Shared DataSet

SsrsUploadReport("./path/to/dataset.rsd", "/AdventureWorks",
    new Dictionary<string, string>
    {
            ["Description"] = "Description for the DataSet"
    },
    new SsrsConnectionSettings
    {
        ServiceEndpoint = "http://localhost/reportserver/ReportService2010.asmx",
        UseDefaultCredentials = true,
		ProxyCredentialType = ProxyCredentialType.Ntlm,
		ImperonsationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation,
		SecurityMode = SecurityMode.TransportCredentialOnly

    });

Upload a DataSource

SsrsUploadDataSource("./path/to/datasource.rds", "/AdventureWorks",
    new Dictionary<string, string>
    {
            ["Description"] = "Description for the DataSource"
    },
    new SsrsConnectionSettings
    {
        ServiceEndpoint = "http://localhost/reportserver/ReportService2010.asmx",
        UseDefaultCredentials = true,
		ProxyCredentialType = ProxyCredentialType.Ntlm,
		ImperonsationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation,
		SecurityMode = SecurityMode.TransportCredentialOnly
    });

Search for an Item

var catalogItem = SsrsFindItem ( 
    new FindItemRequest
    {
        Folder = "/AdventureWorks",
        ItemName = "My_Report_Name",
        Recursive = false
    },
    new SsrsConnectionSettings
    {
        ServiceEndpoint = "http://localhost/reportserver/ReportService2010.asmx",
        UseDefaultCredentials = true,
		ProxyCredentialType = ProxyCredentialType.Ntlm,
		ImperonsationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation,
		SecurityMode = SecurityMode.TransportCredentialOnly
    });