SSRS SharePoint Integrated Mode Report Migration to Azure O365 SPO Options

References:

https://technet.microsoft.com/en-us/library/sharepoint-online-service-description.aspx#bkmk_tableo365

https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-show-ssrs-reports-in-sharepoint-online/1d94a167-6ac7-49f3-9201-c6d04df4ff9a?auth=1

http://mitrai.com/tech-guide/ssrs-report-server-configuration-on-azure-virtual-machines/

http://www.axioworks.com/2018/08/display-sql-server-reporting-services-reports-in-sharepoint-online/?utm_source=collab365&utm_medium=collab365today&utm_campaign=daily_digest

Support Matrix

Summary of Options:

Option 1: Preserve SSRS Reports:

Migrate from On-Prem SSRS to O365 SSRS

Benefit: Preserve RDL’s, do not have to re-develop reports

Disadvantage: O365 SPO does not support SSRS Integrated Mode, Need new or add an SSRS app server instance, possible difficulties with SSO between O365 and SSRS

Option 2: Replace SSRS Reports :

Replace RDL Report with SharePoint Excel Services, PowerBI or equivalent.

Benefit: Implement reports using new technology, integrated with SPO, reduced migration strain of not needed addiitonal app server,

Disadvantage: Re-code from scratch each report, risky.

Details:

Option 1: Keep SSRS: Migrate from On-Prem SSRS to O365 SSRS

1. Document SSRS App Server Migration:

From

Product: SSRS

Environment: OnPrem

Mode: SharePoint Integrated Mode

Version: SQL Server 2012 SP1 : Detected on Report View Web Part: Version=11.0.3000.0

To

Product: SSRS

Environment: OnPrem

Mode: Native

Version: SQL 2016(?, TBD)

2. VM Hosting Environment Migration:

a. Create Azure SSRS VM

i. New Azure VM:

1. Install SQL Server

2. Install / Config SSRS per this ref

ii. Existing Azure VM with SQL Role:

1. Enable SSRS

2. Configure SSRS Instance per section Configure Sql Reporting Service

b. Azure SSRS Native instance is online!

i. https://[host]/ReportServer/

3. OMS Report Site and Report Migration : Migrate the OMS RDL from OnPrem SSRS Integrated to Azure SSRS Native

a. Publish Reports to Azure SSRS Native:

i. Migrate the RDL from OnPrem SSRS Integrated to Azure SSRS Native

ii. Download RDLs from https://iportal.seacorholdings.com/reports/OMS%20Reports

iii. Create VS.Net BI sln to enclose

iv. Upload the RDLs to Azure SSRS Native per this reference, section To Create and Publish Reports to the Azure Virtual Machine

b. OMS Report Site : Create OMS Reports in SharePoint Online :

i. Create “OMS Reports” sub site

4. Integrate Azure SSRS Native and O365 SPO

a. Integrate Reports from SSRS Azure into SPO

b. Add SharePoint Site Page with PageViewer per this ref

5. Concerns:

1. SSO from Azure SSRS to O365 SPO

2. Lack of SharePoint

Option 2: Replace SSRS Reports :

1. Develop New Reports to replace OMS

a. Convert to Excel

i. https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-show-ssrs-reports-in-sharepoint-online/1d94a167-6ac7-49f3-9201-c6d04df4ff9a?auth=1

b. Rewrite RDLs as SPO Excel Services

c. Rewrite RDLs as Power BI Desktop

d. Publish Reports to SPO OMS Reports Site

Option 2: Replace SSRS Reports :

1. Develop New Reports to replace OMS

a. Convert to Excel

i. https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-show-ssrs-reports-in-sharepoint-online/1d94a167-6ac7-49f3-9201-c6d04df4ff9a?auth=1

b. Rewrite RDLs as SPO Excel Services

c. Rewrite RDLs as Power BI Desktop

d. Publish Reports to SPO OMS Reports Site