Just came across your post now and wonder if you have found a way to connect to MS CRM Dynamics.
I thought drop some kind of tip off. Recently noticed that for a client of ours who uses an online based CRM and wanted to connect to it with QlikView, the CRM provide used a software called XAMP (Not pretty sure of how i spelt it) to pull or download data from the online CRM periodically and installing ODBC to provide QlikView with access.I do believe MS Dynamics has an ODBC/OLEDB Connectors out there.
I do hope it helps
Re: How to connect to Microsoft Dynamics CRM