Safyr® for Microsoft Dynamics AX Metadata Visualization and Discovery – powerful exploration software to access, understand and exploit your metadata.
Safyr® for Microsoft Dynamics AX is a powerful metadata visualization and discovery technology product that your data analysts and data scientists can use to gain insight into and exploit the data architecture in your own customized Microsoft Dynamics AX systems. This is a critical task for accelerating effective delivery of a wide range of information led projects. You utilise it to speed up the source data discovery process for many projects such as data catalog, data governance, data warehouse, data analytics, master data, data integration, data migration and more.
Microsoft Dynamics AX presents you with challenges when you come to try to make sense of its metadata. For example there are thousands of tables and attributes for you to navigate so finding the right ones for your project can be time consuming and difficult. In addition the relationships between the tables are not defined in the database system catalog. They are contained within the dictionary tables. This means you need a specialist tool to help you to make sense of the data model, analyse and find what you need and then use those results in other technologies to accelerate source data discovery.
Safyr is particularly valuable if you have significantly extended the set of standard Dynamics tables and/or have multiple instances of Dynamics AX to manage.
“This is seriously cool technology…… If you are a data modeller or an enterprise architect, or if you are building a data mart or involved in a data migration or archival project, or anything associated with these areas then you should take a serious look at Safyr.”
Read what Bloor say about Safyr for data catalogs here.
Safyr® for MS Dynamics AX 2012 is a powerful exploration technology product that your data analysts and data scientists can use to gain insight into and exploit the data architecture in your own customized MS Dynamics AX systems. This is a critical task for accelerating effective delivery of a wide range of information led projects.
Customers use Safyr to solve the 3 challenges associated with MS Dynamics AX metadata discovery.
Discovery: Locating the source of the useful, business ready metadata in your applications. There is very little of any value in the data system catalog. The useful metadata is in a series of data dictionary tables in the MS Dynamics application layer.
Scoping and curation: Once the metadata has been located, the next challenge is to find the table or tables necessary for your task and save them for use in other tools and systems.
Delivery: The final hurdle is to provision the metadata into other tools and technical formats. These include data catalog and governance solutions such as Collibra, Informatica EDC, Alation, Infogix, ASG and Adaptive as well as data modeling tools such as SAP PowerDesigner, ER/Studio, erwin. Or you might want to use the information in Excel, CSV, XML or JSON formats. Where you have multiple Dynamics instances, Safyr’s comparison features can be used to quickly identify the differences between these systems.
Learn more about Safyr for MS Dynamics AX 2012 below.
List all Microsoft Dynamics AX 2012 Tables
Safyr reveals details of all the tables in the Dynamics instance, including any ‘Custom’ tables.
It’s easy to search the tables and to see the numbers of relationships to other tables in the Dynamics system.
Show full details of a Dynamics AX Table
Each table can be expanded to show all the Fields, the Primary Key and Foreign Keys, all based upon the definitions drawn from the Dynamics environment.
See Parent and Child Tables for a Dynamics Table
Safyr extracts Relationship information to help the user understand how Dynamics AX joins tables. Using this information, details of the related tables for a given table can be displayed.
We can help with your Business Case for Safyr.
Visualize Dynamics Tables as a Data Model
Tables can be grouped into Subject Areas with Safyr and then visualised as a Data Model diagram, either using Safyr’s built-in ERDiagrammer, or a range of popular data modelling tools including ERwin, ER/Studio and PowerDesigner.