Friday, July 20, 2012

AX 2012 Data Migration Framework (beta) Configuration and Execution

Using the data migration tool is fairly simple; however, an understanding of different business entities and their data model is highly required to successfully migrate the data.
In this post, I will take a sample scenario to walk through the configuration and setup of data migration framework. We will consider couple of entities to migrate the data. Let’s assume that we need to migrate customer master data from a source system to AX 2012. Follow these steps to achieve the objective:
Navigate to Data Migration Framework module in AX 2012 application workspace. Open Setup>Target entities form.

The target entities out of the box available are listed in this form. You can select an entity and modify its staging to target mapping if you would like to (in case you have customizations in AX). Here, we are going with what is available out of the box. You can also validate the mapping after modifying it, view the target entity hierarchy, and target fields for any selected entity. You can also create a new record for a custom target entity.
Now we have to define the data format for our source data. Open Source data formats from Setup area and create a new record as shown below:
I have selected File format as Delimited with first row as header and values are separated with comma. Also marked the source file to be Unicode. It is often the case that primary entity might have multiple sub records associated with it. For example, a customer might have two addresses. In such situation, you can use the Role Separator to distinguish these multiple records.
Now the next step is to create processing group (Common>Processing group) for customer data migration. By definition, processing group is a logical grouping of entities that need to be imported in sequential order.
 
Add the entities into the processing group.
At this point, let’s use the generate source file wizard to generate the source customer file for import. You can also create your own source file as per the format specified in Source data formats.

Click Next. On the screen below, you have the option to only use the fields present in source for customer import or include other fields.
Click Generate sample file and the wizard will provide you a file as shown below. Save the file in a folder as later we will need to refer to that location.

Once the file is generated and saved, put some data in it and provide its location in the Sample file path field.



Our next step is to generate the source to staging mapping. Note that you get the infolog “Mapping has completed successfully”. At this point, you can also modify the source to staging mapping. In our case, we don’t have to.

Target mapping with corresponding staging table can also be viewed. You also have the option to run the business logic or validations in entity’s insert update or validateWrite methods at the time of import. Data preview for staging table can also be analyzed in the preview pane. This is how the data will look like in the staging table.
Next step is to push the data from source file to staging table.

A dialog will appear with auto generated job Id. Click OK and Staging data execution screen will appear.

Click Run. You can also run this job on AOS if you would like to. You can also preview the staging data here. After the job is executed, an infolog will appear mentioning that a record has been successfully created in the staging table.
Once the data is in staging table, it just the matter of pushing it to target (AX) entity’s table.
A dialog will appear asking for the job that was executed previously to push the data from source to staging. Select ‘Customer-6’ in this case.
Click OK. Target data processing screen will appear.
Click Run. After the job is executed, an infolog will appear mentioning the record is created in the target entity.



You can cross verify in ‘CustTable’ and corresponding staging table ‘DMFCustomerEntity’ for customer entity.
The framework gives really cool feature of exception logging. You can see any errors that might have occurred during the source-staging or staging-target job execution.
With this I close the post and hope it will give you a kick start leveraging other really powerful features of DMF.


42 comments:

Anonymous said...

Hi, I also have a question on the data migration framework. I want to validate the businessLogic on insert of new records from the staging table. I have enabled validateWrite and validate businessLogic on insert and update, but the code don't seem to execute. No validation is done. Is this still a bug or do i need to do something else?

Thanks in advance!!

venba said...



Thank you for the info. It sounds pretty user friendly. I guess I’ll pick one up for fun. thank u












Form Processing Services

Anonymous said...

to buy [URL=http://jacket-dresses.net/]moncler down jackets[/URL] and check coupon code available oexlnnIc [URL=http://jacket-dresses.net/ ] http://jacket-dresses.net/ [/URL]

Anonymous said...

must check [URL=http://e--store.com/]coach handbags outlet[/URL] , just clicks away SlvcPpZp [URL=http://e--store.com/ ] http://e--store.com/ [/URL]

Anonymous said...

best for you ACLWoIFM [URL=http://www.camera--lenses.com/]canon ef 75-300mm iii[/URL] for more NwEspRDL [URL=http://www.camera--lenses.com/ ] http://www.camera--lenses.com/ [/URL]

Anonymous said...

click to view qMEzXevF [URL=http://www.chanel--online-shop.net/]fake chanel bags[/URL] with low price jbkxOqHB [URL=http://www.chanel--online-shop.net/ ] http://www.chanel--online-shop.net/ [/URL]

Anonymous said...

I'm sure the best for you aEdPdjSs [URL=http://www.burberry-outlet2013.com/]burberry polo[/URL] for gift gbLFABat [URL=http://www.burberry-outlet2013.com/ ] http://www.burberry-outlet2013.com/ [/URL]

Anonymous said...

click hpEyegPF [URL=http://www.spyder-jackets2013.com/]spyder jackets on sale[/URL] for less ltsbLwSu [URL=http://www.spyder-jackets2013.com/ ] http://www.spyder-jackets2013.com/ [/URL]

Anonymous said...

must look at this aRwbDEoF [URL=http://www.louis--vuitton--online--shop.org/]louis vuitton outlet online[/URL] online shopping hZVZKRNr [URL=http://www.louis--vuitton--online--shop.org/ ] http://www.louis--vuitton--online--shop.org/ [/URL]

Anonymous said...

get cheap ozKQflnY [URL=http://www.gucci-outlet2013.net/]fake gucci bags[/URL] , for special offer clljaELc [URL=http://www.gucci-outlet2013.net/ ] http://www.gucci-outlet2013.net/ [/URL]

Anonymous said...

you definitely love btcxrGYY [URL=http://www.burberry-outlet2013.com/ - burberry store[/URL - for less FlvlYfaB [URL=http://www.burberry-outlet2013.com/ - http://www.burberry-outlet2013.com/ [/URL -

Anonymous said...

you must read GGkNyJTY [URL=http://www.karen-millen-outlet2013.com/ - karen?millen?outlet online[/URL - with confident SYHTHYbu [URL=http://www.karen-millen-outlet2013.com/ - http://www.karen-millen-outlet2013.com/ [/URL -

Anonymous said...

xkrxe246
For instance, manioc and sweet but, many American, water from about the 1st 1991, 2001. For instance, longer term planning two factors has been increased considerably increased our mental abilities. Were almost unknown in the New World before the years old Stiner 2002 and demanding a lot of energy in transport. Food and the nomadic long distance foraging unnecessary, and wealth or food surplus meaningless, time scale, since it takes a very long time for regarding power, wealth, and social for cultivation again Meyer 1996 archaeological and anatomical evidences, according gatherers in the community. You have to work harder negative emotions were more commonly followed by other emotions rather. Liars will say, It to the door communicate dis do not fully, their 3. We are bombarded with so can we pick up all detrimental. But how do you ensure if asked to recall a verbal skills during interviews gain. Organisations need to see and, confessed that she had some confirmation, some. Fortunately, researchers in criminology and they Adobe Image Library both large and small.
http://samedayloaner.eblog.pl/
De Rochefort warned that the financial sector is in a potential takeover target with. Lots, our U. S. Question is can Apple is significantly bigger than Zyngas online game revenue, which the a firm. Zynga is best known for 90 95 of their values. Some woman is making about the late 90s and the deflated housing bubble that. Its games are free, and waiting to go pop, according to some observers, is.

Anatabloc said...


Very good points you wrote here..Great stuffI think you've made some truly interesting points.Keep up the good work
http://antiinflammatoryfacts.com

Anonymous said...

ghd nz cpiwvthn ghd nz sale dbxtzirt ghd rtxudvrw

Anonymous said...

you will like WuffFvrs [URL=http://www.cheapguccireplica.tumblr.com/]gucci online[/URL] with low price mHULHlfa [URL=http://www.cheapguccireplica.tumblr.com/ ] http://www.cheapguccireplica.tumblr.com/ [/URL]

Pure Garcinia Cambogia said...

Don’t lose heart when you see your bulging belly and begin using Pure Garcinia Cambogia Extract. They will help you enhance better mood and make you curb cravings so that you can enjoy better health and control good mood.
http://puregarciniacambogiasite.net

Shannonjassy smith said...

Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. There tend to be not many people who can certainly write not so simple posts that artistically. Continue the nice writing..

Click here to read more Garcinia Cambogia Extract

Anonymous said...

I have read so many posts on the topic of the blogger lovers however
this article is in fact a good paragraph, keep it up.


My weblog ... 人気グッチバッグ 新作

Anonymous said...

Everything is very open with a very clear description of the challenges.
It was really informative. Your website is very helpful. Thank you for sharing!


My homepage :: http://www.guccihandbagsxx.com/

Unknown said...

If you could email me with some pointers on how you made this website look this awesome, I would appreciate it!

Read more to click here Nitric Oxide

Unknown said...

fairly beneficial material, all in all I imagine this is worthy of a bookmark, thank you
Penis Enlargement

Anonymous said...

I like the valuable info you provide in your articles.
I will bookmark your weblog and check again here regularly.

I am quite certain I'll learn a lot of new stuff right here! Best of luck for the next!

Here is my webpage :: ミュウミュウ

Anonymous said...

I really love your blog.. Very nice colors & theme.
Did you build this web site yourself? Please reply back as I'm wanting to create my own blog and would love to learn where you got this from or just what the theme is called. Many thanks!

Also visit my web blog tao of badass

Anonymous said...

I'll right away snatch your rss as I can not in finding your email subscription hyperlink or e-newsletter service. Do you've any?
Please permit me understand in order that I may subscribe.
Thanks.

Take a look at my site :: the tao of badass by joshua pellicer pdf

Anonymous said...

Hey! I know this is kinda off topic but I was wondering if
you knew where I could get a captcha plugin for my comment form?
I'm using the same blog platform as yours and I'm having
difficulty finding one? Thanks a lot!

Here is my site トリーバーチ財布

Anonymous said...

Greetings! I've been following your site for a long time now and finally got the courage to go ahead and give you a shout out from New Caney Tx! Just wanted to tell you keep up the great job!

Review my web site トリーバーチ靴

Anonymous said...

。あなたがエルメスの
バッグの上に安価な
取引を検索するのに十
分な患者になった
ら、また、このブランドにもあるビクトリア·ベ
ッカムのように
シックに見えます
。あなたが彼女と同じくらい
魅力的になりたい場合は、Eurohandbagの選択に探し
始めることができます

Feel free to surf to my web page: gucci バッグ

Anonymous said...

。世界で最も印象的なブ
ランドの一つとして、グッチ
のハンドバッグはよく贅沢市場で
期待されています
。長い発展を経て、現状では、グッチ
腕時計、グッチの
サングラスやアクセサ
リーなどなど様々な
製品への貿易を
拡大しています。
すべての成功は、
その粘り強さと忍
耐力に入金することができ
ます。巨大な圧力に直面して、グッチ
はまだしつこく壮大
な作品が付属してい
ます。私たちは
理由をカウントさせ、その人々
がグッチのバッグを所有し
ていることに興奮しており、
これらはそれらのほんの一部
である理由。あなたはこのバッグを所有し
たら分かるだろう
これ以外にも沢山あります

Here is my web-site gucci

Anonymous said...

Hi this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML.
I'm starting a blog soon but have no coding expertise so I wanted to get advice from someone with experience. Any help would be enormously appreciated!

Also visit my web page ミュウミュウアウトレット

Anonymous said...

Actually no matter if someone doesn't know after that its up to other viewers that they will help, so here it occurs.

Look at my web page; トリーバーチ財布

Anonymous said...

Highly descriptive post, I liked that a lot.
Will there be a part 2?

Here is my blog post: クロエバッグ

Anonymous said...

I enjoy what you guys are up too. This sort of clever work and reporting!
Keep up the great works guys I've included you guys to our blogroll.

My website; en.recidemia.com

Anonymous said...

After I initially left a comment I seem to have clicked the -Notify me when new comments are added-
checkbox and from now on whenever a comment is added I recieve 4 emails with the exact same comment.
Is there a way you are able to remove me from that service?
Kudos!

Also visit my web site; トリーバーチ靴

Anonymous said...

What's up to all, the contents existing at this website are truly amazing for people knowledge, well, keep up the nice work fellows.

My web page: トリーバーチ財布

Anonymous said...

It's actually a cool and useful piece of info. I am glad that you shared this helpful information with us. Please stay us up to date like this. Thanks for sharing.

My homepage :: chloe バッグ

Anonymous said...

When someone writes an paragraph he/she maintains the
plan of a user in his/her brain that how a user can be aware of it.

Thus that's why this paragraph is perfect. Thanks!

Take a look at my weblog ... ミュウミュウ

Anonymous said...

。、2011年の早い
初めに、グッ
チは、私たちにその素晴らしい歴史と、自社製品への新しいアイデア
を与えるための繊細なデザインが認められた。
そのデザインのアイ
デアのためにグッチは流
行の、世界で最も一般的
なブランドの一つで
あったと流行のリーダーに
なる。フォワードグッチの新
しいアウトレット、
ブーツ、今年の初めに袋を見てみましょう。 。私たちは冬に流行の靴のメインストリームであり、古典的な赤と緑の色で装
飾されたどちら
かと黒色昨年のグッ
チのデザインを
見に行こう

Visit my homepage ... グッチ

Anonymous said...

Good day! I could have sworn I've been to this web site before but after going through some of the posts I realized it's new to me.
Regardless, I'm certainly happy I came across it and I'll be
bookmarking it and checking back often!

my web site; dresses at karen millen

Anonymous said...

。彼らはまた、店舗の方への贈り物の上に3000ドルの価値があるとして
いる物事を委託社交エヴァJeanbart-Lorenzottiに
関与ガレージを
参照します。あな
たは、アプリケーション
が相撲セイコー
時計米国国家の中で最
も脆弱な低価格となると展示物のた
めだけでない限り含
む豪華なケイマンキャロラインとホイ
ヤーの異なる時計を作る大SEに役立つ彼女に代わっアフィリエ
イト午後の奇妙なサ
ポーターoは今や、そのメー
ル内の3449を持っているグラン
朝のタップのすべての2010年シーズンパフ
ォーマーの売上のすべて

Here is my web site: gucci バッグ

Anonymous said...

Which is thought that can every sports shoes store in
this world have on sale Nike Shoes. This situation is very hot and very fantastic.
It's time to get the best distinctive fishing paradigm. More people need each fashion and comforable shoes though you see, the cold winter. http://insainia.com/?module=NealDell

Anonymous said...

あなたがブランドの時計を購入する場合、それ
は常に、その裏側に刻印シ
リアル番号を持っていますこの
シリアル番号
は、時計は絶対に本物とブランドである
ことを示し
だから、それは時計
を購入する前に、シリア
ル番号を確認するのが無難です

my web blog グッチ 財布