Install the AX 2012 R2 CU7 Data import/export framework for SQL Server 2014

To use the Data import/export framework for Microsoft Dynamics AX 2012 R2 cumulative update 7 (CU7) with SQL Server 2014 Integration Services or later, you must install AX 2012 R2 CU7, and then apply the update KB 3018235.

The following instructions apply for an environment in which SQL Server 2014 or a later version is installed. If you are running SQL Server 2008 or SQL Server 2012 Integration Services, you can install the Data Import/Export Framework for Dynamics AX 2012 R2 CU7 by using the update installer. For more information, see Install the Data Import/Export Framework binary updates (CU7). To see which versions of Integration Services are supported with the Data Import/Export Framework, see the Microsoft Dynamics AX 2012 System Requirements.

Before you begin

  1. Download the CU7 hotfix package, and extract it to a local folder. To extract the download, follow the instructions in the Download and extract an update from CustomerSource, PartnerSource, or Lifecycle Services.
  2. Download the hotfix package for KB 3018235, and extract it to a local folder.

Install the AX 2012 R2 CU7 Data import/export framework for use with SQL Server 2014 Integration Services

On the computer that is running Integration Services, follow these steps.

  1. Run Windows PowerShell.
  2. Navigate to the Support folder of the hotfix package.
  3. Run the following script:

    Install-DIXFService.ps1.
    
  4. Follow the on-screen instructions.

  5. You will be asked to locate the Data Import/Export Framework service MSI from Microsoft Dynamics AX 2012 R2 CU7. This file can be found in the MSI\DIXF_Service_x64 or MSI\DIXF_Service_x86 folder. If the script is unable to locate the corresponding MSP, you will be asked to locate it. The MSP can be found in the MSI\DIXF_Service_x64 or MSI\DIXF_Service_x86 folder in the hotfix package folder (KB 3018235). You will be asked if you want the Data Import/Export Framework Service to be installed under the Network Service account. If you answer No, you will be asked to enter the username (DOMAIN\username format) and password to run the service. Installation should start.

Verify installation

By default the script’s log will be written to a file that is named InstallDIXFService-<date>_<time >.log. Verify that the file reports a successful installation. If the installation fails, the log produced by the MSI is named DIXFService_install -<date>_<time >.log. Search for it, and investigate the listed issues.

Install the Data import/export framework Client and Server Components

After installation of pw_DMF Service component has completed, install the Data Import/Export Framework Client and AOS components the ordinary way.

  1. Install the CU7 version of the components on the appropriate computers. See Install the Data Import/Export Framework binary updates (CU7).
  2. Apply hotfix KB 3018235 on the appropriate computers.

Optional: Create a silent installation Windows PowerShell script

If you supply the Install-DIXFService.ps1 script with the appropriate parameters you can use the script to do a silent installation. The following table provides a brief description of the parameters that are available and how to use them.

Parameter name Description
UseNetworkService This is a switch:
  • If you want to install the service under the Network Service account, include UseNetworkService in your command.
  • If UseNetworkService is specified, any value specified for ServiceAccount and ServicePassword will be ignored.
ServiceAccount Specifies the account the service will be run under. This parameter must be supplied if UseNetworkService is not used. This should be in DOMAIN\username format.
ServicePassword Specifies the password for account that the service will run under. This parameter must be supplied if UseNetworkService is not used.
MSIFileName Required The path of the dixf_service_<architecture>.msi file from the Microsoft Dynamics AX 2012 R2 CU7 hotfix. This can be a relative or absolute path.
MSPFileName The path of the dixf_service_<architecture>.msp file. If the Install-DIXFService.ps1 script is run from the Support folder in a hotfix package, this parameter is not required, because the script should be able to find the file automatically.
LogFileName The path of the log file for the script. If this parameter is not set, the current directory is used.
MSIExecLogFileName The path of the log file for MSIExec, which is where the actual installation log can be found. If this parameter is not set, the current directory is used.

Example 1: Install under Network Service and use default log file paths

Install-DIXFService.ps1 -UseNetworkService -MSIFileName "C:\CU7Package\MSI\dixf_service_x64\dixf_service_x64.msi"

Example 2: Install as a specific user and specify log file paths

Install-DIXFService.ps1 -ServiceAccount "MYDOMAIN\myuser" -ServicePassword "VerySecure.1234" 
-MSIFileName "C:\CU7Package\MSI\dixf_service_x64\dixf_service_x64.msi" 
–LogFileName "C:\MyLogs\DIXFService-script-log.txt" -MSIExecLogFileName "C:\MyLogs\DIXFService-MSIExec-log.txt"

See also

Configure the version of SQL Server Integration Services used by the Data import/export framework in an environment with multiple versions (DIXF)