Overview
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.
Quick Start
In this section we will show you how to set up a Dynamics AX Connection Manager to access Dynamics AX.
You must have the Microsoft Dynamics AX .NET Business Connector installed for the connection manager to work.
- Right-click on the Connection Manager canvas.
- Select New Connection from the pop-up list.
- When the list of connection managers appears, expand the Type column, if necessary, so you can see the complete names of the connection managers.
- Scroll down the list to find the Dynamics AX connection manager and select it.
- Once the connection manager dialog opens, type in your User name.
- Click on the Advanced tab and enter the name of your Dynamics AX Application Object Server.
- Click on the Server tab and then click on Test Connection.
- When you see Test Connection succeeded, click OK.
- Click OK to close the connection manager dialog.
Congratulations! You have successfully configured a Dynamics AX connection manager.
Parameters
Server
Use the Server page of the Dynamics AX Connection Manager dialog to specify properties for connecting to Dynamics AX server.
- Test Connection
- Confirm connection manager configuration by clicking Test Connection.
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.
Advanced
Use the Advanced page of the Dynamics AX Connection Manager dialog to specify additional properties if your server configuration is different from the default.
Specify Business Connector Proxy user. This parameter is optional.
Specify Business Connector Proxy password. This parameter is optional.
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.
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.
Knowledge Base
- Where can I find the documentation for the Dynamics AX Connection?
- Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
What's New
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.