SSIS and oData connection

(0) Share

Report

Posted on by Community Member

Hi,

I am trying to use SQL Server Integration Services with the oData Connection Manager to connect to Dynamics CRM. When authenticating, I am picking up the following message.

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)

Is there a work around (on the client side) to avoid the DTD error without writing C# code?

Thanks and regards

Steve

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Bruno Lucas 5,421 on at

Like (0)

Report
Copy link

Link copied!

Hi,

this is because the OData API requires OAuth authentication. SSIS Odata source will not handle the OData authentication .

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (2)

Report
Copy link

Link copied!

Hi Steve,

Nice answer by Bruno.

Have you used this:

In the detail file it mentions about Microsoft Dynamics CRM 2011 data source

www.microsoft.com/.../details.aspx

And also I found this article:

stackoverflow.com/.../ssis-connecting-to-crm-odata-endpoint-dtd-error

You might try to take a lok this:

www.rssbus.com/.../mscrm

Hope this helps.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Aileen,

Hi Aileen, Thanks for the note!

I have looked at all of these. Installed where applicable and we shall probably opt for a third party product.

regards Steve

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Steve,

I was able to connect to CRM 2013 Onpremise Organization Data Service using the odata source adaptor mentioned here - www.mssqltips.com/.../using-the-new-odata-source-in-sql-server-integration-services

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report
Copy link

Link copied!

SSIS doesn't support DTD in XML file. So remove the all DTD from your XML file

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

stuffandtacos.carfup.com/.../use-crm-dynamics-online-odata-endpoints-in-ssis

stuffandtacos.carfup.com/.../use-crm-dynamics-online-odata-endpoints-in-ssis-part2

Was this reply helpful? Yes No