Skip to main content

Posts

Showing posts from March, 2013

Data Import/Export Framework–Data format

Today I want to write a brief on the different data formats that are available in the Data Import/Export framework. File The File format allows for text (ie. csv) types to be imported. ODBC ODBC format allows for SQL type queries to be used. Imagine writing SQL statement to pull data from another database. AX AX format allows for exporting data in dat/def format. This is a nice addition because it allows you to move data to another AX instance. In other words, this pulls the AX entity data into the staging table and then you export it. Then you go to your other instance of AX you want to import into. Import the dat file and then process it. Check out TechNet on the source data formats. http://technet.microsoft.com/EN-US/library/jj225596.aspx#DefineSource I will try to write a little bit more about the AX format at another time because that is confusing at first. Simply, think of it as your way of moving entities from one AX database to another database.

Microsoft Dynamics AX 2012 Data Import/Export Framework

Small post today. Data Import/Export Framework came out the other week. See the link: http://blogs.msdn.com/b/axsa/archive/2013/03/13/microsoft-dynamics-ax-2012-data-import-export-framework-old-name-data-migration-framework-is-now-available-on-information-source.aspx Good to see the model is now in its rightful place in the fpk Layer. Not much has changed in terms of the menu and design concept. New format has been added. csv and odbc we know from previous but I haven’t explored AX format yet. That’s it for now. I will explore some more and post what I find.