locked
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?

    Thanks


    Hassan


    • 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.

    and/or

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

    and/or

    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

    Don

    Monday, January 8, 2018 1:08 AM