SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

connection to microsoft dynamics crm

Reply
PROC Star
Posts: 549

connection to microsoft dynamics crm

[ Edited ]

Hi,

 

We are trying to connect to Microsoft dynamics crm through SAS and I have no idea how to do this. We would like to read and write to Microsoft dynamics. Has anyone  done something like this before and can provide some clues.

 

 

 

Super User
Posts: 5,919

Re: connection to microsoft dynamics crm

Since this is business application, you shouldn't read or write to it without the system administrators blessing. So in would start a dialogue with them as a first step.
Data never sleeps
PROC Star
Posts: 549

Re: connection to microsoft dynamics crm

[ Edited ]

you are right @LinusH. Discussions are going on with system administrators, meanwhile I am trying to find some documentation relating to the connectivity  and did not find any.

PROC Star
Posts: 549

Re: connection to microsoft dynamics crm

[ Edited ]

Can I do it using an API call any suggestions @ChrisHemedinger

 

Super User
Posts: 5,919

Re: connection to microsoft dynamics crm

It would help if you could describe your requirements a bit more - What do you need to achieve?
A part from the obvious SAS/ACCESS path there seem to be a couple of REST interfaces available.

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/data-entities/data-managem...
Data never sleeps
PROC Star
Posts: 549

Re: connection to microsoft dynamics crm

[ Edited ]

we need to read the data microsoft dynamics crm and then do scoring and then post the data back to microsoft dynamics crm. But currently we are looking how we can read the data into different tables. Please let me know, if you need any further information. Thank you very much for all the support.

PROC Star
Posts: 631

Re: connection to microsoft dynamics crm

Hi @kiranv_,

 

I guess you can connect to Microsoft Dynamics CRM through ODBC. Check this out

Thanks,
Suryakiran
Ask a Question
Discussion stats
  • 6 replies
  • 150 views
  • 2 likes
  • 3 in conversation