August 8, 2018 at 11:26 am
After an excellent article about how to get the XML for SSRS Data Sources, I found that the XML output is not saving credentials. This will allow our team to have Data Source definition code used for continuous deployment.
I need guidance on how to deploy the credentials, as in what tags should be used.
Example code for Data Sources without Integrated Security is below:<DataSourceDefinition xmlns="http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource">
<Extension>OLEDB-MD</Extension>
<ConnectString>Data Source=YourSsasHere;Initial Catalog=YourDatabaseHere</ConnectString>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>
August 8, 2018 at 11:27 am
andre.quitta - Wednesday, August 8, 2018 11:26 AMAfter an excellent article about how to get the XML for SSRS Data Sources, I found that the XML output is not saving credentials. This will allow our team to have Data Source definition code used for continuous deployment.I need guidance on how to deploy the credentials, as in what tags should be used.
Example code for Data Sources without Integrated Security is below:
<DataSourceDefinition xmlns="http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource">
<Extension>OLEDB-MD</Extension>
<ConnectString>Data Source=YourSsasHere;Initial Catalog=YourDatabaseHere</ConnectString>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>
The URL for the article didn't post:
http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-database/
August 8, 2018 at 12:18 pm
andre.quitta - Wednesday, August 8, 2018 11:27 AMandre.quitta - Wednesday, August 8, 2018 11:26 AMAfter an excellent article about how to get the XML for SSRS Data Sources, I found that the XML output is not saving credentials. This will allow our team to have Data Source definition code used for continuous deployment.I need guidance on how to deploy the credentials, as in what tags should be used.
Example code for Data Sources without Integrated Security is below:
<DataSourceDefinition xmlns="http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource">
<Extension>OLEDB-MD</Extension>
<ConnectString>Data Source=YourSsasHere;Initial Catalog=YourDatabaseHere</ConnectString>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>The URL for the article didn't post:
http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-database/
The credentials get saved but you can't query for them - they are encrypted. The SSRS encryption key is used for encrypting that type of data.
You should be using the web services API if you need to programmatically deploy data sources (or if you use the rs.exe utility). It will take care of where to put all of the pieces of the data source as data sources may also be in the DataSource table, not just in the Catalog. Some versions specific pieces are in the database as well which would need to be accounted for. Many of those things have had some changes on the different versions of SSRS. All of the undocumented things like that are managed and supported if you are using the API.
Sue
August 8, 2018 at 2:26 pm
Sue,
Thanks for your reply.
I've looked through various RS.EXE web pages and I don't see examples on how to create a new Data Source with credentials (user name & password). Do you know where I might find something like that?
Regards
Andre
August 8, 2018 at 3:34 pm
andre.quitta - Wednesday, August 8, 2018 2:26 PMSue,Thanks for your reply.
I've looked through various RS.EXE web pages and I don't see examples on how to create a new Data Source with credentials (user name & password). Do you know where I might find something like that?
Regards
Andre
The rs.exe utility just uses the same web services so you may want to check the methods. Here is a link to the CreateDataSource method.
ReportingService2010.CreateDataSource
Here is one example:
reporting-services-automation/CreateDataSource.rss
Powershell is also an alterntive if you'd rather use that. There is a module for reporting services called ReportingServicesTools. You can use the New-RsDataSource cmdlet
Sue
August 8, 2018 at 4:07 pm
These are both really good. Will discuss with my Release Manager and my Architect which direction.
Thanks very much.
Andre
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply