MS Dynamics CRM Connection and Query

[Jeremy Whilde]

This is just a question to see if this is remotely possible using WB.

Is it possible to connect to MS Dynamics CRM 4.0 or 2011 server in order to query contact data?

found the following http://msdn.microsoft.com/en-us/library/ff681567.aspx

Which implies a connection string similar to ODBC could be used, however not sure about how the
app.config or web.config  files work.

Is this possible with WinBatch? Has anyone done something like this? or do we need a middleware connection layer written in something else?

We need to be able to connect and query both the web version and the onsite server version of Dynamics.

Thanks JW

[td]

Don't have any experience working with the CRM SDK but it appears to be dotNet based.  Since WinBatch hosts the CLR (dotNet runtime) you should be able to do most of what you can do in C# using WinBatch.   The catch is that you will need to find a C# example in the SDK or some other place that does what you want and then convert it to the WinBatch equivalent. 

We can certainly help you with the conversion part anyway.