December 7, 2017 at 9:48 am
Hi, Can anyone help please?
I am attempting to extract data from Microsoft Dynamics CRM into SQL Server 2016. I have set up an Odata connection, but when I set up the Odata source nothing is returned in the Collection, it thinks about it for a long time and will stop with the message 'Unable to load collection for the connection...'. I am using the url 'https://disco.crm4.dynamics.com/XRMServices/2011/Discovery.svc?wsdl' which is specified from the Dynamics settings. I can get some data returned using the url 'https://disco.crm4.dynamics.com/api/discovery/v8.2/' in the Odata connection. The login I am using is the 'Microsoft Dynamics CRM Online' option. I have tried this with User access and Admin access with the same result. I have searched and found examples for the Northwind DB with SQL 2012 and others accessing SharePoint, but nothing for Dynamics and SQL 2016. Anyone tried this and been successful? Any helpful suggestions appreciated.
December 7, 2017 at 11:11 am
Is this a remotely hosted solution, or do you have direct network access to the servers hosting Dynamics?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 8, 2017 at 1:43 am
Hi,
The Dynamics server is remotely hosted.
December 11, 2017 at 3:37 am
Hi,
I have come across this article, https://community.dynamics.com/crm/b/zsoltzombiksblog/archive/2016/02/18/dynamics-crm-integration-tools-ssis. This basically indicates that the SSIS Odata connection is a no go and a third party option is the way to go.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply