how to add a data source to SSRS - reporting services 2014?

Question

For infomation as Create, Modify, and Delete Shared Data Sources (SSRS) but I want to get this done quickly, so when I have been requested to add a new data source to our reporting services:

This is the way I am currently doing it: I look for another data source that I already have - (example only - the real server name has been modified)

http://myreportingserver/Reports/Pages/DataSource.aspx?ItemPath=%2fData+Sources%2fOEL_UK

there I have already another data source working fine, I get the information like the connection string, and the credentials (user name of the account running the report) and modify accordingly for my new data source.

then, for creating a new data source I go to the page below and press new data source adding the relevant data.

Question

Isn't there another simpler way of creating a data sources?

I was thinking something like from the ReportingServices database there must be some table with the datasource records, and all the information. Just copying that info into another record, doing the appropriate changes - and I will have my new data source.

This question shows how to find data sources in the reporting services database

How can I tell which data sources are being used in SSRS?

Answer 1

With Visual Studio with SSDT-BI installed you can create new shared DataSources or copy/paste them. https://msdn.microsoft.com/en-us/library/ms155845(v=sql.120).aspx

Answer 2

Look into rs.exe (installed with SQL reporting services configuration). Is uses a vbscript syntax but it will allow you to do data source updates with command line/script.

https://msdn.microsoft.com/en-us/library/ms162839.aspx

Here is an example of the call to RS.EXE that you could put in a cmd or bat file. If there is only one instance of SSRS and it is in the default instance then exclude the "_instancename" from the URL.

rs -i c:\temp\SSRS_EnableRemoteErrors.rss -s http://reportservername/ReportServer_instancename

pause

Here is the script it calls, in this example the script will enable remote errors on the SSRS instance. There

Public Sub Main()
  Dim P As New [Property]()
  P.Name = "EnableRemoteErrors"
  P.Value = True
  Dim Properties(0) As [Property]
  Properties(0) = P
  Try
    rs.SetSystemProperties(Properties)
    Console.WriteLine("Remote errors enabled.")
  Catch SE As SoapException
    Console.WriteLine(SE.Detail.OuterXml)
  End Try
End Sub