topic Re: QlikView and MS Dynamics AX ERP in QlikView

QlikView and MS Dynamics AX ERP

Mon, 02 Jul 2012 07:52:14 GMT

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.

Re: QlikView and MS Dynamics AX ERP

Mon, 02 Jul 2012 08:41:29 GMT

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.

Re: QlikView and MS Dynamics AX ERP

Mon, 02 Jul 2012 09:55:58 GMT

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.

Re: QlikView and MS Dynamics AX ERP

Mon, 02 Jul 2012 10:24:27 GMT

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.

Mikael

Re: QlikView and MS Dynamics AX ERP

gershova — Mon, 02 Jul 2012 11:03:57 GMT

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

Re: QlikView and MS Dynamics AX ERP

Emmanuelle__Bustos — Tue, 09 Feb 2016 18:50:23 GMT

@Vicente Clemente

You should mark this post as Solved! It korked for me with the @gershova 's answer