Dynamics AX Connection

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

All Downloads ----- Join VIP ----- Questions?


Dynamics AX Connection Manager is SSIS Connection Manager for establishing Dynamics AX connections. The connection manager is based on Microsoft Dynamics AX .NET Business Connector. Use the API to build components based on Dynamics AX Connection Manager.


Use the Dynamics AX Connection Manager dialog to specify properties for connecting to Dynamics AX server.

Server Options

User name

Specify user name to access Dynamics AX server. Do not use the Microsoft Dynamics AX user name; use the NT alias that is connected to the Microsoft Dynamics AX account. This parameter is optional.


Specify the domain associated with the Windows user. This parameter is optional.


Specify if all clients should use the same connection. This property has the options listed in the following table.

Value Description
True All clients use same connection (default).
False Every client use different connection.
Test Connection

Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Proxy User Name

Specify Business Connector Proxy user. This parameter is optional.

Proxy User Password

Specify Business Connector Proxy password. This parameter is optional.

Proxy Domain

Specify Business Connector domain. This parameter is optional.


Specify company you want to select for the session. This parameter is optional.


Specify language to use for Microsoft Dynamics AX labels. For example, "en-us". This parameter is optional.

Object Server

Specify Microsoft Dynamics AX Application Object Server (AOS) to connect to. For example, InstanceName@ServerName:PortNumber. This parameter is optional.


Specify name of the Microsoft Dynamics AX configuration to use while logging on. This parameter is optional.