Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet


Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Tuesday, July 10, 2012

AX 2012 - Data Migration Framework (Beta) Released





I hope everyone is doing great this fine Dynamics Day! I thought I would warm back up the writing presses, if you will, with some exciting news. Microsoft has released to InformationSource the Beta release of the Microsoft Dynamics AX 2012 Data Migration Framework



The above is from the Data Migration User's guide, which you can find at the following location.: Data Migration Framework User Guide [AX 2012]

Further you can download the beta release for this new framework, located at InformationSource from the following link: Microsoft Dynamics AX 2012 Data Migration Framework (Beta) Download. Keep in mind that you do need PartnerSource or CustomerSource access for this download. Further please keep in mind this is Beta.

The approach that this data migration framework is something that we at IDB Solutions have been using for now two years working with Microsoft Dynamics AX 2012. The basics are simple, you de-normalize the datasets that make up the Data model in AX 2012 with targeted staging tables. Then you have X++ code that work against the staging tables, to fill the normalized, and sometimes super normalized, datasets of AX 2012.



The configuration aspect, or process for this framework is spelled out below. This was also taking from the above referenced user's guide.:
  • 1) Determine entities in source system
  • 2) Define the source data format
  • 3)Identify entities to place in processing group
  • 4) Define the processing group
  • 5) Source to Staging (Entity Map)
  • 6) Staging to Target (Entity Map)


Further there is also a Model file that needs to be installed into your target instance of AX 2012. You can do this, with the following example - based on the AXUtil application.: 'axutil import /file: "C:\Program Files\Microsoft Dynamics AX 2012 Data Migration Framework (CTP)\DataMigrationFramework.axmodel"'. You can find this as part of the above referenced user guide, in the install section.

I'm in the process of downloading this now for use on my clients AX 2012 projects. I plan on having a follow up post on my thoughts of the framework, ease of use, extending it and more.

That's all for this kick off post, and check back soon as I continue to cover this new framework, as well as more cloud stories, a continue focus on EP and of course BI on the brain!Till Next Time!
Follow Me @:
RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , ,

7 Comments:

Anonymous Jeroen said...

Hi Brandom,

Thanks alot for this and other posts on this topic.

"Just to show that Microsoft does plan on really helping to enable this framework to have a multitude of sources, you can see proof in the naming of .Net assemblies that come as part of the install. Specifically the below screen shot of the ‘Microsoft.Dynamics.AX.DMF.SSISHelper’ .Net assembly reference."

I'm just evaluating this software too; and find in the video tutorial (also on InformationSource)explains that the 'run' button should execute with the help of SSIS integration. No words that it isn't there yet??
Can you clarify please?

Kind regards,
Jeroen

3:17 AM  
Anonymous Anonymous said...

Hi Jeroen

SSIS is used for source to staging step independent of the source type.
At the moment source type supported in Beta is File, but there is more stuff coming after Beta , one of them is having other source types like Ax and ODBC.

Regards
Mudit

5:17 PM  
Anonymous Jeroen said...

@Mudit,

Thanks, got it. I'm very anxious about this new stuff after the beta!

By the way, is there a place to leave feedback on this beta?

Regards
Jeroen

2:53 PM  
Anonymous Anonymous said...

Hello everyone,

I get an exception when I press the "Get Staging Data" Button.
Can someone help? Thanx a lot.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Exception: DMF002 ---> Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Das Flat File Source-Element ist in der PipelineComponentInfos-Auflistung nicht vorhanden.
---> System.Runtime.InteropServices.COMException: Das Flat File Source-Element ist in der PipelineComponentInfos-Auflistung nicht vorhanden.

at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPipelineComponentInfos100.get_Item(Object Index)
at Microsoft.SqlServer.Dts.Runtime.PipelineComponentInfos.get_Item(Object index)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.PipelineComponentInfos.get_Item(Object index)
at Microsoft.Dynamics.AX.DMF.SSISHelper.DMFPackage.AddFlatFileSource(MainPipe dataFlowTask, String name)
at Microsoft.Dynamics.AX.DMF.SSISHelper.DMFPackage.AddControlFlowComponent(String backupTable, List`1 packageColumns, String entityname, String definitiongroup, String executionid, List`1 lstFlatFileErrorColumns, List`1 lstOLEDBErrorColumns, String errorTableName)
--- End of inner exception stack trace ---
at Microsoft.Dynamics.AX.DMF.SSISHelper.DMFEntity.MigrateEntity()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Dynamics.AX.ManagedInterop.ClrBridgeImpl.InvokeClrInstanceMethod(ClrBridgeImpl* , ObjectWrapper* objectWrapper, Char* pszMethodName, Int32 argsLength, ObjectWrapper** arguments, Boolean* argsAreByRef, Boolean* isException)
TYPE:
System.Reflection.TargetInvocationException

9:31 AM  
Anonymous Anonymous said...

@Jeroen
For feedback, bugs, feature suggestions, please use the feedback link in information source just below the data migration framework option.

Regards
Mudit

2:12 AM  
Anonymous Vincent Saul said...

After a “Three Hour Tour” this has been completed on my VmWare Windows Server 2008 R2 64-bit virtual machine with 16GB for allocated memory.

I downloaded the installation image for Data Migration Framework Beta to a local network share then followed to completion the instructions at http://technet.microsoft.com/EN-US/library/jj225595.

The most time consuming step during the whole process was step 5 where the “Compile and synchronize” and “Compile into .Net Framework CIL” are executed.

Cheers,
Vincent Saul
vsaul at lyonsmagnus dot com

5:25 PM  
Blogger Samuel said...

how do i dowanload data migration framework

5:49 AM  

Post a Comment

Links to this post:

Create a Link

<< Home


Copyright 2005-2011, J. Brandon George - All rights Reserved