Extract Data from Microsoft Dynamics CRM in BODS

[system]

Hello,

Could anyone explain , how to extract data from Microsoft Dynamics CRM in BODS. Again I will load this data into SAP HANA.

Thanks in Advance
Shravan

---

shravan_bo (BOB member since 2006-04-25)

[system]

On premise, cloud? Need more info than that mate!

---

ABILtd (BOB member since 2006-02-08)

[system]

Here’s how my journey went:-

120×120 10.4 KB

Hi All. I’ve created a Web Service SOAP datastore and I’m trying to import the ‘Create’ function from the Microsoft Dynamics CRM IOrganizationService web service. I’m getting a BODI-1111469 error. I’m using DS4.2sp6. Any ideas most gratefully received. The main text of the error is this:- An error occurred while importing metadata: %1 (BODI-1111469)The adapter XML for function contains parsing errors in the object: : <Error importing XML Schema from file <adapter_schema_in.xsd>:<XML parse…

Eventually, one of my colleagues wrote a wrapper around the IOrganisationService webservice and I was able to load and extract data. But the process is very slow.

---

Nemesis (BOB member since 2004-06-09)

[system]

Backed db for Microsoft Dynamics CRM is sql serevr.
Data is stored in sql server, best to pull data from there itself.

---

n78882 (BOB member since 2010-09-17)

[system]

@n78882

Backed db for Microsoft Dynamics CRM is sql serevr.
Data is stored in sql server, best to pull data from there itself.

Have you actually done this?

The backend is Azure, which is cloud based and Microsoft don’t let you connect directly.

---

Nemesis (BOB member since 2004-06-09)

[system]

Old version was in ms sql server - we did extract directly from back-end.

If its Azure now - you can create a ODBC connection and can extract data.

---

n78882 (BOB member since 2010-09-17)