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!
Labels: AX 2012, AX 2012 Data Migration Framework, Data Migration, Dynamics AX, Dynamics AX 2012, InformationSource, Master Data, MDM, Microsoft
posted by brandon | 8:28 AM
7 Comments:
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
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
@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
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
@Jeroen
For feedback, bugs, feature suggestions, please use the feedback link in information source just below the data migration framework option.
Regards
Mudit
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
how do i dowanload data migration framework
Post a Comment
<< Home