On Prem SSRS to Third Party CRM (IFD) using FetchXML RRS feed

  • Question

  • Hi All,

    Is it possible to connect my local SSRS report server (FetchXML) to connect IFD CRM in cloud, using report manager in SSRS?I am feeling not possible?



    • Edited by Hassanz Wednesday, December 6, 2017 4:32 AM
    Wednesday, December 6, 2017 4:29 AM

All replies

  • Hi,

    You will need to have your on-premise environment networked into the cloud environment with the appropriate permissions.


    The SQL server you are connecting to would required the FetchXML "plugin" to be installed. (SQL natively does not understand FetchXML).


    The login you use should also be on the target server, it looks like the user is not there.

    You may also require a reverse proxy to allow the information back in to your on premise environment.

    just some idea's


    Monday, January 8, 2018 1:08 AM