Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to connect QlikView with MS Dynamics AX ERP. How can I connect them?
Is there any specific connector for it?
Thanks in advance,
Alicia.
Hi Alicia,
as far as I know there is no specific connector for this, you will have to use a ODBC connection for Dynamics AX.
br
Hello Mikael,
Thank you for your early answer.
Could SQL Server driver be the driver for this connection? Please can you provide me the steps to create the connection ?.
Thank again,
BR.
Alicia.
Hi,
yes use SQL driver. Set up a ODBC system DSN and use that in the script editor. The script should look like this;
ODBC Connect to [your datasource];
Where [your datasource] is the name of your ODBC connection, hope this helps. There is a load to read about ODBC if you need help setting it up.
BR
Mikael
I am using the Data Link Property window to create this string at the beginning of my project (it's run when you press button Connect in your Script sheet).
I select Microsoft OLE DB Provider for SQL Server and then follow for the questions from the QV
So I get the following strings:
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ThisIsMyAXDatabaseName;Data Source=ThisIsMySQLServerName;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ThisIsMyComputureName;Use Encryption for Data=False;Tag with column collation when possible=False];
But I guess that some parameters can depend on your security properties.
So there is no special connector, you have to select data direct from AX tables. If you need a help in this area you can use this link for http://msdn.microsoft.com/en-us/library/aa852568.aspx
there are list of AX tables which fields and description
@Vicente Clemente
You should mark this post as Solved! It korked for me with the @gershova 's answer