Data Import/Export Framework Walkthrough: Installation

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:

  1. Installation
  2. Architecture
  3. Importing data to an out of the box target entity
  4. 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.

Install

In first step of the wizard, the installer will check if you have the minimal requirements.

Capture4

Designate a user account to run the Data Import/Export Framework service. Enter the user account of AOS service.

Capture5

Press Next.

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”

Capture7

Capture8

4 – Restart the AOS service

Capture6

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.

Capture9

This step should take a few minutes to complete.A info log is displayed at the end.

Capture10

6 – Restart the AOS Service

Capture6

7 – Open Dynamics AX client, now the Dynamics AX Navigation pane should have the option of Data Import/Export Framework.

Capture11

Stay tuned for next posts

Advertisements