topic Re: How to extract/retrieve metadata from microsoft crm dynamics in Talend Studio

How to extract/retrieve metadata from microsoft crm dynamics

VK2 — Fri, 20 Oct 2017 14:57:18 GMT

Hi team,

I m willing to connect and retrieve metadata from Microsoft CRM Dynamics. Could you please help me how can we achieve this ?

I tried using DB connection--> Generic DB--> provided in below URL But couldn't successful, Please provide alternate approaches.

https://www.cdata.com/kb/tech/dynamicscrm-jdbc-talend.rst

Regards,

Meena

Re: How to extract/retrieve metadata from microsoft crm dynamics

Anonymous — Fri, 20 Oct 2017 15:20:09 GMT

Hi Meena,

Talend does have components specifically for connecting to Microsoft Dynamics CRM - tMicrosoftCrmInput and tMicrosoftCrmOutput - which allow you to fetch the data in a convenient, and relatively straightforward way, by selecting the type of "Entity" you're interested in (e.g Contact, Lead, Invoice) and specifying criteria/conditions for the records you are interested in. You can also create/update records.

In the standard DI product, these components can be found in the "Business" section of the component palette.

Unfortunately, I don't have a Microsoft CRM system I can connect to in order to build an example, but the component properties and use are hopefully fairly self-explanatory.

Regards,

Chris

Re: How to extract/retrieve metadata from microsoft crm dynamics

VK2 — Fri, 20 Oct 2017 18:02:37 GMT

Hi Chris,

Thank you for the quick response,

Yes I have used tMicrosoftCRMInput component, but the entity which i needed is not there in the List so i have selected the CustomEntitySet and given the Custom Entity Name but I need the schema to come automatically (which i don't want to enter manually because there are many columns).

Please find attached screenshots.

I tried DB connection for the schema Retrieval same as provided in the below URL

https://www.cdata.com/kb/tech/dynamicscrm-jdbc-talend.rst

Connection is successfully ( I have used CData Trial version for now) but when i right click and selected the schema retrieve i don't find any schema present.

I don't understand why i am not able to see the schema.

Could you please help me how can we achieve this ?

Please provide alternate approaches for the metadata.

Regards,

Meena.

DBConn.png
DBSchema.png
TestConnection.png

Re: How to extract/retrieve metadata from microsoft crm dynamics

Anonymous — Fri, 20 Oct 2017 18:32:29 GMT

Hi Meena,

I've previously used the SugarCRM components a lot, and also had to manually set up the schema for custom modules, and add any (and often many) custom fields for the standard modules, which is a real pain. They did work fine though, and ultimately it was worth the effort. Just make sure you export the schema once you're done, just in case!

I suspect the issue is that the user you're connect to SQL Server with doesn't have permissions to get the metadata from the CRM database, so maybe check that first, but if that's not the case, then we can start looking at other things.

Regards,

Chris

Re: How to extract/retrieve metadata from microsoft crm dynamics

VK2 — Fri, 20 Oct 2017 20:49:42 GMT

Hi Chris,

Sure, I will check the permissions for the user account in CRM.

I'm having one more doubt, Is there any way to get the metadata out of an API or from WSDL?

Please let me know, if there are any chances.

I will get back, once i got the confirmation about the permissions.

Thanks in Advance

Regards,

Meena.

Re: How to extract/retrieve metadata from microsoft crm dynamics

VK2 — Fri, 20 Oct 2017 21:08:09 GMT

Hi Chris,

The user I've connected to CRM is having full access,

Even others programs like .Net are able to pull the metadata from the CRM with the same user, which I'm using now.

what might be the cause that am not getting the schema from CRM.

Are there any chance to pull the metadata from CRM, please help me to achieve this.

Regards,

Meena.