Setup a AX Connection using AX Connection Manager

SSIS Integration Toolkit AX Connection Manager is an SSIS connection manager that can be used to establish connections with Microsoft Dynamics AX Server. 

AX connection manager allows you to specify how you want to connect to your AX server. 

To add a AX connection to your SSIS package, right-click in the Connection Manager area, and choose "New Connection..." from the context menu. You will be prompted the following window, where you can choose the "DynamicsAX" item to add the connection.

new connetion

Add AX Connection Manager

AX Connection Manager contains the following three pages which configure how to connect to Microsoft Dynamics AX server.

  • General
  • Advanced Settings
  • More Info

General page

The General page of AX Connection Manager allows you to specify the general settings of the connection. Specifically, this is where you enter authentication information for your Dynamics AX connection.

AX Connection Manager

User Name

User Name option allows you to specify the Windows user account that you want to use when connecting to Dynamics AX server. Note that the user name should be a Windows domain account instead of the actual Dynamics AX user account. 

User Domain

User Domain option is used to specify the active directory domain of the Windows user. 

Test Connection

After all the connection information has been provided, you may click the "Test Connection" button to test if the user can successfully login to the AX server. 

Advanced Settings page

The Advanced Settings page of AX Connection Manager allows you to specify some advanced settings of the connection. 

AX Connection Manager

Proxy Account - User Name

Specify the .NET Business Connector proxy account's user name that is used for the AX connection. This is an optional parameter.

Proxy Account - Password

Specify the .NET Business Connector proxy account's password. This is an optional parameter.

Proxy Account - Domain

Specify the .NET Business Connector proxy account's Windows domain name. This is an optional parameter.

Object Server Name

Specify the Microsoft Dynamics AX Application Object Server (AOS) used for the connection. This is an optional parameter.

Configuration Name

Specify the name of Microsoft Dynamics AX configuration to be used for the connection. This is an optional parameter.

Company

Specify the company to be used for the connection. This is an optional parameter.

Language

Specify the language to be used for Dynamics AX labels for the connection session. An example of such language is "en-us". This is an optional parameter.

More Info page

More Info page shows some basic information about the toolkit. In this page, you can find the version information of the toolkit.

AX Connection Manager