Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    David Ocampo
    Access 2010 and RightNow Connect
    Topic posted February 8, 2012 by David OcampoRed Ribbon: 250+ Points, last edited February 10, 2012 
    661 Views, 3 Comments
    Title:
    Access 2010 and RightNow Connect
    Content:

    Has anyone ever used Access to retrieve information from RightNow? We currently export data to Access for a variety of reasons and I thought that it would be easier to simply connect to RightNow and retrieve this info.

    Any help is appreciated!

    Comment

     

    • Ryan McCullough

      David,

      I believe the only way to use Access to retrieve data from RN is using ODBC. According to http://cx.rightnow.com/app/answers/detail/a_id/4522, ODBC has been deprecated as of 12/31/2011.

      Are you asking for an alternative to using ODBC to retrieve data from RN into MS Access?

    • David Ocampo

      Ryan,

      Thanks for the info. According to Technet, Access 2010 can

      Connect to a Web service as an external data source

      You can now connect to a Web service as an external data source. You will need a Web service definition file provided by the Web service administrator. After you install the definition file, you can link to Web service data as a linked table.

       

      I thought I could use the Connect API to retrieve data.

    • Ryan McCullough

      I wasn't aware that MS Access 2010 has this ability. You can try it, but I have reservations about this working due to the polymorphism used in the CWSS WSDL.