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.
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
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.
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.
