RSS

Data Import/Export Framework–Source Data format

25 Feb

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 Create custom entity mapping by using the wizard

File format at another time because that is confusing at first. Simply, think of it as your way of loading CSV file to AX database.

Advertisements
 

Tags: , , , ,

2 responses to “Data Import/Export Framework–Source Data format

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: