Microsoft Dynamics AX Technical ConferenceFebruary 3–5, 2014Bellevue, WA

Data Import Export FrameworkMudit MittalPrincipal Solutions Architect

IntroductionWe are excited to share Microsoft Dynamics AX 2012 R3 with you…• This presentation contains Microsoft confidential information• Dynamics AX 2012 R3 is pre-release software and subject to change• Microsoft provides no license, express or implied, in this presentation• Please review and respect the disclaimer included in all printed

and electronically distributed materials

• Framework to import/export data for Microsoft Dynamics AX 2012.

• Moved to Foundation Layer

DIXF

• SourceExternal data source from where we want to import data into Microsoft Dynamics AX 2012 File – Text (delimited & fixed width), Microsoft Excel and XML.ODBC – database , Microsoft Excel, Microsoft Access, etc.

• StagingIntermediary table inside Microsoft Dynamics AX 2012

• TargetActual entity inside Microsoft Dynamics AX 2012 for which we want to import data from external data source. Example – customer, vendor, etc.

Terms

• Import entity data• Export entity data• Compare and Copy data between

companies• Copy entity data across different Microsoft

Dynamics AX environments

What can it do?

Entity

Entity

Configure

Compare

CopyMDMIntegration

Data Migration

ImportExport

Import Process

Microsoft Dynamics AX

Staging Target

Source

Architecture

Microsoft Dynamics AX Client

Microsoft Dynamics AX Client

AOSDIF Service

• Master entity – Customer, Vendor, Project, etc.

• Documents – Sales Order, Purchase Order, etc.

• Journals – Opening balances, Journals, etc.• Parameters – Functional parameters.• Reference– Units, Dimensions, etc.• Configuration data – System

configuration, Parameters, etc.

Out of box entities (150+)

System Configuration Data

Enterprise Portal BI-Analysis servicesReporting Services

Project Server Integration

Workflow AIF Batch settings

Document Management Email Parameters System Service

Accounts

Key features

Service Interface Entity types – entity, flat table, composite Sources – File, AX , ODBC

Mapper control Folder support Incremental runs - UPSERT

Enterprise data aware Parallel executing – Task bundling Compare and Copy

Demo

Data Import Export Framework

Questions?

What's next?• ILL401 Data Import/Export Framework

THANK YOU for attending! Your feedback is extremely important, please complete an evaluation using one of the following options:

• On the fly from the mobile event app• Communications Kiosks located in the Evergreen Foyer, Grand

Ballroom Foyer and Regency Foyer

• Via the Dynamics AX Technical Conference website: www.microsoft.com/dynamics/axtechconference

DisclaimerThis presentation contains Microsoft Confidential Information. Microsoft may use any suggestions, comments, or other feedback that you provide for any purpose without obligation. This presentation is provided for informational and training purposes only. It represents Microsoft’s view as of the presentation date. Microsoft cannot guarantee the accuracy of any information after the presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted as a commitment on Microsoft’s part. This presentation is provided “as-is”.

Microsoft Dynamics AX 2012 R3 is pre-release software under development. All dates, features, and descriptions specified are preliminary, are based on current expectations, and are subject to change at any time without notice.

Sample code included in this presentation is made available AS IS.  THE ENTIRE RISK OF THE USE OR THE RESULTS FROM THE USE OF ANY SAMPLE CODE REMAINS WITH THE USER.

MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION. NO LICENSE (EXPRESS OR IMPLIED, BY ESTOPPEL OR OTHERWISE) TO ANY INTELLECTUAL PROPERTY RIGHTS IS GRANTED BY THIS PRESENTATION.

© 2014 Microsoft Corporation. All rights reserved.

© 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

© 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.