Display ServiceNow data in CRM 2013 RRS feed

  • Question

  • Hi,

    Does anyone have experience in displaying ServiceNow data in CRM 2013?  I am trying to build an SSRS report and query data from ServiceNow to the report.  However, T-SQL statement seems not working with ServerNow ODBC connection.  For instance, Select * From incident Where Status = 'Closed' works, but Select * From incident Where Status = @status does not work.  ServiceNow must have it special syntax to specify a variable in SQL Statement.  Does anyone know how to specify a parameter or variable in SQL statement for ServiceNow?  Thanks.

    Monday, November 10, 2014 10:55 PM