What are my options for connection Microsoft SSRS to Domo?

PrathmeshKodilkar

I am working on a Support case where the customer wants to know what their available options are for connecting Microsoft SSRS to Domo.

They need to run a report in Domo from SSRS.

Any insights are much appreciated. Thanks in advance. 

GrantSmith

You may be able to automate sending an email and using the Dataset via Email connector - See https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/e-mail-delivery-in-reporting-services?view=sql-server-ver16

Alternatively, if you want to be more technical you may be able to write a custom connector and leverage SSRS's REST APIs: https://learn.microsoft.com/en-us/sql/reporting-services/developer/rest-api?view=sql-server-ver16

GrantSmith

You may be able to automate sending an email and using the Dataset via Email connector - See https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/e-mail-delivery-in-reporting-services?view=sql-server-ver16

Alternatively, if you want to be more technical you may be able to write a custom connector and leverage SSRS's REST APIs: https://learn.microsoft.com/en-us/sql/reporting-services/developer/rest-api?view=sql-server-ver16