Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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