ReportingService2010.CreateDataSource Method (String, String, Boolean, DataSourceDefinition, Property )

Applies To: SQL Server 2016 Preview

Creates a new data source in a report server database or SharePoint library.

Namespace:   ReportService2010
Assembly:  ReportService2010 (in ReportService2010.dll)

Syntax

[SoapHeaderAttribute("TrustedUserHeaderValue")]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", 
    RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
public CatalogItem CreateDataSource(
    string DataSource,
    string Parent,
    bool Overwrite,
    DataSourceDefinition Definition,
    Property[] Properties
)

public:
[SoapHeaderAttribute("TrustedUserHeaderValue")]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", 
    RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", 
    Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
CatalogItem^ CreateDataSource(
    String^ DataSource,
    String^ Parent,
    bool Overwrite,
    DataSourceDefinition^ Definition,
    array<Property^>^ Properties
)

[<SoapHeaderAttribute("TrustedUserHeaderValue")>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
[<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource",
    RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)>]
member CreateDataSource : 
        DataSource:string *
        Parent:string *
        Overwrite:bool *
        Definition:DataSourceDefinition *
        Properties:Property[] -> CatalogItem

<SoapHeaderAttribute("TrustedUserHeaderValue")>
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)>
<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource",
    RequestNamespace := "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    ResponseNamespace := "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
    Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)>
Public Function CreateDataSource (
    DataSource As String,
    Parent As String,
    Overwrite As Boolean,
    Definition As DataSourceDefinition,
    Properties As Property()
) As CatalogItem

Parameters

• DataSource
  Type: System.String

  The name for the data source including the file name and, in SharePoint mode, the extension (.rsds).

• Parent
  Type: System.String

  The fully qualified URL for the parent folder that will contain the data source.

• Overwrite
  Type: System.Boolean

  A Boolean expression that indicates whether an existing data source with the same name in the location specified should be overwritten.

• Definition
  Type: ReportService2010.DataSourceDefinition

  A DataSourceDefinition object that describes the connection properties for the data source.

• Properties
  Type: ReportService2010.Property[]

  An array of Property objects that defines the property names and values to set for the data source.

Return Value

Type: ReportService2010.CatalogItem

A CatalogItem object for the newly created data source.

Remarks

The table below shows header and permissions information on this operation.

If the .rsds extension is excluded from the data source name, an rsFileExtensionRequired error will be returned. If an .odc extension is given, an rsNotSupported error is returned.

If errors occur, the data source is not created.

The length of the Parent parameter cannot exceed 260 characters; otherwise, a SOAP exception is thrown with the error code rsItemLengthExceeded.

The Parent parameter cannot be null or empty or contain the following reserved characters: : ? ; @ & = + $ , \ * > < | . ". You can use the forward slash character (/) to separate items in the full path name of the folder, but you cannot use it at the end of the folder name.

Examples

Legacy Code Example

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;

class Sample
{
    static void Main(string[] args)
    {
        ReportingService2010 rs = new ReportingService2010();
        rs.Url = "http://<Server Name>" + 
            "/_vti_bin/ReportServer/ReportService2010.asmx";
        rs.Credentials = 
            System.Net.CredentialCache.DefaultCredentials;

        string name = "AdventureWorks.rsds";
        string parent = "http://<Server Name>/Docs/Documents/";

        // Define the data source definition.
        DataSourceDefinition definition = new DataSourceDefinition();
        definition.CredentialRetrieval = 
            CredentialRetrievalEnum.Integrated;
        definition.ConnectString = 
            "data source=(local);initial catalog=AdventureWorks";
        definition.Enabled = true;
        definition.EnabledSpecified = true;
        definition.Extension = "SQL";
        definition.ImpersonateUserSpecified = false;
        //Use the default prompt string.
        definition.Prompt = null;
        definition.WindowsCredentials = false;

        try
        {
            rs.CreateDataSource(name, parent, false, 
                definition, null);
        }
        catch (SoapException e)
        {
            Console.WriteLine(e.Detail.InnerXml.ToString());
        }
    }
}

Imports System
Imports System.Web.Services
Imports System.Web.Services.Protocols

Class Sample

    Public Shared Sub Main()

        Dim rs As New ReportingService2010()
        rs.Url = "http://<Server Name>" + _
            "/_vti_bin/ReportServer/ReportService2010.asmx"
        rs.Credentials = _
            System.Net.CredentialCache.DefaultCredentials

        Dim name As String = "AdventureWorks.rsds"
        Dim parent As String = "http://<Server Name>/Docs/Documents/"

        ' Define the data source definition.
        Dim definition As New DataSourceDefinition()
        definition.CredentialRetrieval = _
            CredentialRetrievalEnum.Integrated
        definition.ConnectString = _
            "data source=(local);initial catalog=AdventureWorks"
        definition.Enabled = True
        definition.EnabledSpecified = True
        definition.Extension = "SQL"
        definition.ImpersonateUserSpecified = False
        'Use the default prompt string.
        definition.Prompt = Nothing
        definition.WindowsCredentials = False

        Try
            rs.CreateDataSource(name, parent, False, _
                definition, Nothing)
        Catch e As SoapException
            Console.WriteLine(e.Detail.InnerXml.ToString())
        End Try

    End Sub

End Class

See Also

ReportingService2010 Class
ReportService2010 Namespace

Return to top