Microsoft provided an extension to Microsoft Dynamics AX that smooth’s the import / export process. Without this framework, importing data to some specific tables implied using X++.
I will try to publish a series of posts about Dynamics AX Data Import/Export Framework, covering:
- Importing data to an out of the box target entity
- Importing to a custom target entity
Installation Step by Step
1 – First you must download the extension package from informationsource, unzipt it and execute setup.
2 – The installation process is split into 3 main components :
- A component must be installed on a server running MS SQL Integration Services.
- A component must be installed on a server running AOT.
- A component must be installed on a workstation having the Dynamics AX client
Since I’m running all the services on a single box in a virtual machine, I have selected all components.
In first step of the wizard, the installer will check if you have the minimal requirements.
Designate a user account to run the Data Import/Export Framework service. Enter the user account of AOS service.
3 – The components are now installed, now the model files must be imported into Dynamics AX
Import the Model file from a command line using AXUTIL. The modal file is located inside the folder of the client component.
Note that there is a matching folder in “C:\Program Files\ Microsoft Dynamics AX 2012 Data Import Export Framework Client Component” for each supported version of Dynamics AX.
- AX 2012 -> Folder 2012.
- AX 2012 Feature Pack -> Folder 2012 FP.
- AX 2012 R2 -> Folder 2012 R2.
For Dynamics AX 2012 R2 execute : axutil import /file: “C:\Program Files\ Microsoft Dynamics AX 2012 Data Import Export Framework Client Component \2012 R2\model\DataImportExportFramework.axmodel”
4 – Restart the AOS service
5 – Open the Dynamics AX Client, and a screen should popup to you. Select “Compile and synchronize” option. The next step is to do a full CIL compile.
This step should take a few minutes to complete.A info log is displayed at the end.
6 – Restart the AOS Service
7 – Open Dynamics AX client, now the Dynamics AX Navigation pane should have the option of Data Import/Export Framework.
Stay tuned for next posts