Discussion Board for collaboration on QlikView Scripting.
Working with QlikView version 10 and I need to rescue data from CRM software from Microsoft - Dynamics CRM 4.0.
Does anyone have any experience with this to give any tips?
Qlikview 10 can connect to MS Dynamics CRM via SQL Server ODBC/OLEDB, some sample tables include:
each table will have an id field for linking the tables together
I interfaced QV 9 with Baan, Nav, DimaSys, ... But I have no expereince with a Dynamics AX interface.
Can you explain a little bit more what you said to Mauber?
Jacques from Belgium
Connection to MS Dynamics AX can be achieved using the standard ODBC/OLEDB drivers from Microsoft, this will expose the underlying tables to QlikView which can then be added to your script as required.
Thank you for reacting so quikly.
I understand that an ODBC link will allow me to view all AX tables. However, is there a possibility to have some explanation to understand for a specific information (e.g. all invoices and credit notes) which field in which table I need to use?
In your response to Mauber you mentioned Filtered Tables. Could this help me?
This connection string may help you:
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=domain\user;Initial Catalog=Name_MSCRM;Data Source=SERVER\DATABASE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=YourWksID;Use Encryption for Data=False;Tag with column collation when possible=False];