...

Note: Further details on the RS.exe utility can be found in the referenced document [1].

System Set-up

Universal Task name: Run SAP Data Service Job Related UAC XML Files for template and task: [2]

Software used:

• MS SQLSERVER 2016
• Report Builder in SQL Server 2016
• Windows Server 2012R2
• UAC 6.4 Build 40 (beta-release)
• UA 6.3.0.1 installed on the SAP Data Services Server

Proposed enhancements

A) A script for all possible RS.EXE scenarios should be generated:

1. Deploying / Publishing reports (done)
2. Moving reports
3. Exporting reports to a file
4. Adjust security
5. Cancel a running job
6. Configure SSRS system properties

B) Deploy reports using a SOAP Webservice

In the referenced document [1] the command to deploy a report via a SOAP webservice is described. This solution has the advantage that no Universal Agent would have to be deployed on the SQLSERVER.

Solution Description

The following describes how the Universal Task can be demonstrated, once it is set-up on the Stonebranch demo system.

1. Configure a new Report using Report Builder in SQL Server 2016

...

Image Added

The report configuration is written to the file system as *rdl file e.g.: rechnunsdaten.rdl

...

Image Added

2. Test the Report in Report Builder in SQL Server 2016

...

Image Added

Once it is tested in Report Builder in SQL Server 2016, you can deploy the report to the Reporting Server using Universal Task.

3. Configure the universal task deploy a Reporting to the Reporting Server

Universal Task template

Image Modified

Reporting Service Script to deploy a report:

Image Modified

Universal Template fields:

Image Modified

Universal Task

Image Modified

Dscription:

• REPORTNAME for the actual name of the report (=report file) to be deployed
• REPORTSERVER_FOLDER which describes the folder where the file should be deployed to (reportingserver webfolder)
• FILEPATH denotes the location of the rdl file.

4. Verify job execution in SAP Data Service Management Console

Log-On to the Reporting Webserver and check that the report has been deployed (see Universal Task Parameter reportserver): WALLDORF.

e.g. http://walldorf/Reports/browse/ (user:admin/Porsche944)

Browse to the folder, where the report should be deployed (see Universal Task Parameter: REPORTSERVER_FOLDER): /myreports

Image Modified

Document References

This document references the following documents:

Image Modified