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

Running Microsoft Dynamics AX 2012 R2 Demo VM in VirtualBox

Munib Ahmed posted an excellent step by step guide how to run an existing virtual machine on Hyper-V into Virtualbox. http://dynamicsnavax.blogspot.com/2011/04/how-to-run-ax2012-hyperv-on-virtualbox.HTML

This guide allows you for example to run the Microsoft Dynamics AX 2012 R2 Demo VM http://blogs.technet.com/b/dutchpts/archive/2012/12/23/microsoft-dynamics-ax-2012-r2-demo-vm-available.aspx in any workstation or laptop without Hyper-V.

After configuring this virtual machine uand opening Dynamics AX client in the Role Center you will get an error message like this.

AX 1

The reason for this error message, is due a configuration that is lost by opening it in Virtual Box.

Steps to overtake the issue:
1 – Add a new internal networking card in virtual box

Network

Configure Windows new network card with ip address 10.20.12.101

IP
Now, refresh the Role Center and you should get a page like this.

Role Center