topic MS CRM connector in QlikView https://community.qlik.com/t5/QlikView/MS-CRM-connector/m-p/90118#M14664 <HTML><HEAD></HEAD><BODY><P>We are in the process of converting from CRM 2011 to D365 (Cloud).&nbsp; We have purchased the D365 connector, however we have noticed it's very slow.&nbsp; A simple comparison would be it take 30 minutes to pull a total of 111K rows of data from miscellaneous tables using FETCHXML.&nbsp; On a nightly bases I pull 11 million rows in 80 minutes.&nbsp; Am I missing something or is the fetchxml really this slow vs. on prem SQL DB.</P><P>Thanks</P></BODY></HTML> Thu, 28 Jun 2018 11:11:50 GMT tmumaw 2018-06-28T11:11:50Z MS CRM connector https://community.qlik.com/t5/QlikView/MS-CRM-connector/m-p/90118#M14664 <HTML><HEAD></HEAD><BODY><P>We are in the process of converting from CRM 2011 to D365 (Cloud).&nbsp; We have purchased the D365 connector, however we have noticed it's very slow.&nbsp; A simple comparison would be it take 30 minutes to pull a total of 111K rows of data from miscellaneous tables using FETCHXML.&nbsp; On a nightly bases I pull 11 million rows in 80 minutes.&nbsp; Am I missing something or is the fetchxml really this slow vs. on prem SQL DB.</P><P>Thanks</P></BODY></HTML> Thu, 28 Jun 2018 11:11:50 GMT https://community.qlik.com/t5/QlikView/MS-CRM-connector/m-p/90118#M14664 tmumaw 2018-06-28T11:11:50Z