locked
SSIS using ODATA Source to connect to CRM 2015 Online RRS feed

  • Question

  • Hi,

    I am unable to connect using SSIS OdataSource with CRM Online 2015 Organization service.

    https://XXX.api.crm5.dynamics.com/XRMServices/2011/OrganizationData.svc

    Has anyone successfully implemented it ? I am unable to connect to CRM Online using Odata Source in SSIS.

    I get the following error:

    For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method. (System.Xml)

    ------------------------------
    Program Location:

       at System.Xml.XmlTextReaderImpl.Throw(Exception e)
       at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res)
       at System.Xml.XmlTextReaderImpl.ParseDoctypeDecl()
       at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
       at System.Xml.XmlTextReaderImpl.Read()
       at Microsoft.SqlServer.IntegrationServices.OData.UI.ODataConnectionManagerForm.TestConnectionMiddle(Object callback)

    I came across this forum - http://stackoverflow.com/questions/25881389/ssis-connecting-to-crm-odata-endpoint-dtd-error

    "It says SSIS ODataComponent" does not do OAuth and I will need to implement "RSSBUS CRM Component" instead.


    • Edited by Sath13 Friday, March 13, 2015 6:30 AM
    Friday, March 13, 2015 5:09 AM

All replies

  • I'm not sure if you can access the OrganizationData.svc from SSIS - among other issues I don't think you can pass the authentication data. I would suggest you use the SOAP endpoint (Organization.svc) instead


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Monday, March 16, 2015 4:39 PM
    Moderator
  • playing with

    • crm online
    • azure active directory
    • ssis
    • C# (script component)
    • xml transformation

    you can achieve it. Our company created a blog post for that. sorry for not posting the whole solution here, it's kind of long

    Part 1 Part 2


    • Edited by fcamous Thursday, March 24, 2016 6:04 PM
    Thursday, March 24, 2016 6:04 PM