Today I have learned how to do reverse engineering in Microsoft Dynamics Ax application.
For this you require one more software application MS office Visio 2007/2010.
Step to follow:
1. You have to create a project by taking the objects in which you want to see UML/ER diagram.
2. Then click reverse Engineer button.
3. Select the location and the diagram type and the project type and click ok.
4. If you select the UML diagram then it will create a .vsd format file.
5. It will call directly the Visio application and create the UML structure.
6. Under Model Explorer we can find the Static Model >Top Package>Project name.
7. You can drag and drop to the blank page and it will create diagram based on the relationship.
8. If you select the ER model then it will create a .ERX format file.
9. To read that file you have to go to the visio application.
10. Click File > New > Software and Database (or Database if you are using Microsoft Office Visio) > Database Model Diagram.
11. On the Database menu, point to Import, and then click Import Erwin ERX file.
12. In the dialog box, click the Browse button, navigate to the location of the .erx file that you generated from the Reverse Engineering tool, select the file, and then click OK.
13. On the Database menu, point to View, and then click Tables and Views.
14. Drag items from the Table and Views window onto the diagram surface.
15. After you have added a table to the diagram, you can right-click the table in the diagram, and then click Show Related Tables. This will add all the related tables from the Tables and Views window that
are not already in the diagram.
For this you require one more software application MS office Visio 2007/2010.
Step to follow:
1. You have to create a project by taking the objects in which you want to see UML/ER diagram.
2. Then click reverse Engineer button.
3. Select the location and the diagram type and the project type and click ok.
4. If you select the UML diagram then it will create a .vsd format file.
5. It will call directly the Visio application and create the UML structure.
6. Under Model Explorer we can find the Static Model >Top Package>Project name.
7. You can drag and drop to the blank page and it will create diagram based on the relationship.
8. If you select the ER model then it will create a .ERX format file.
9. To read that file you have to go to the visio application.
10. Click File > New > Software and Database (or Database if you are using Microsoft Office Visio) > Database Model Diagram.
11. On the Database menu, point to Import, and then click Import Erwin ERX file.
12. In the dialog box, click the Browse button, navigate to the location of the .erx file that you generated from the Reverse Engineering tool, select the file, and then click OK.
13. On the Database menu, point to View, and then click Tables and Views.
14. Drag items from the Table and Views window onto the diagram surface.
15. After you have added a table to the diagram, you can right-click the table in the diagram, and then click Show Related Tables. This will add all the related tables from the Tables and Views window that
are not already in the diagram.
Some important Links:
http://www.blueink.biz/DataModelingVisio.aspx
http://en.wikipedia.org/wiki/Cardinality_(data_modeling)
http://www.blurtit.com/q775064.html
http://www.nearinfinity.com/blogs/lee_richardson/an_entity_relationship_diagram_example.html
http://www.blueink.biz/DataModelingVisio.aspx
http://en.wikipedia.org/wiki/Cardinality_(data_modeling)
http://www.blurtit.com/q775064.html
http://www.nearinfinity.com/blogs/lee_richardson/an_entity_relationship_diagram_example.html
Arrowsol Training offers you a way to training materials, classroom training, E-Learning, certification exams, Microsoft Press Books, and more for Microsoft Dynamics.
ReplyDeleteMicrosoft Dynamics Training | Microsoft Dynamics online Training | Microsoft Dynamics Training online
i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. reverse mortgage in Colorado
ReplyDelete