Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView and MS Dynamics AX ERP

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.

5 Replies
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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

gershova
Partner - Contributor III
Partner - Contributor III

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

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

@Vicente Clemente

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