80425 Intelligent Data Management Framework in Microsoft Dynamics AX 2012 2 Days
About this Course
This two-day instructor-led training (ILT) course provides a thorough look at Intelligent Data Management Framework for Microsoft Dynamics AX 2012. The topics covered in the course include installation, configuration, scheduling management and troubleshooting.
Audience Profile
This course is intended for database and system administrators, who are responsible for the administration and maintenance of the Microsoft Dynamics AX application and the Microsoft SQL Server database.
At Course Completion
After completing this course, students will be able to:
- Describe the importance of data management and the different types of data management that are available
- Describe the capabilities of the Intelligent Data Management Framework for Dynamics AX 2012
- Define the concepts and terminology of Intelligent Data Management Framework
- Describe the architecture of the Intelligent Data Management Framework
- Explain planning for an implementation using the Intelligent Data Management Framework
- List the topologies supported by the IDMF
- Identify the prerequisites for installing IDMF
- Demonstrate the process to install IDMF
- Demonstrate the process to complete the post-installation tasks and configure IDMF
- Demonstrate how to use the Analysis dashboard
- Examine the Analysis details workspace
- Demonstrate how to manage indexes
- Describe the show system health functionality
- Describe the performance functionality
- Describe the Configuration functionality
- Explain the differences between master data and transactional data
- Describe how to create an archive object
- Describe how to create a purge object
- Summarize scheduling and status management
- Use scheduling and status management to analyze the production and archive databases
- Use scheduling and status management to perform health checks against a production replica database
- Use scheduling and status management to synchronize metadata and master data from the production database to the archive database
- Describe the capabilities of IDMF for scheduling and managing the status of purge, archive, and restore archive operations
- Create a schedule and view the status of a schedule
- Archive data from the production database to an archive database
- Restore data from an archive database to the production database
- Describe how to configure database and email settings.
- Explain how to configure thresholds and alerts.
- Describe how to manage exception lists for archive and purge objects.
- Identify the framework options available in IDMF.
- Demonstrate how to view and create application health check queries.
- Describe how to configure master data tables.
- Troubleshoot issues that occur when you install IDMF, by using the Configuration workspace or creating or managing scheduled jobs
Course Outline
Module 1: Introduction
This module examines the different aspects of data management that an enterprise must consider. We then look at how the Intelligent Data Management Framework (IDMF) for Microsoft Dynamics AX can help with making data management easier. Finally we look at the planning process for including data management as part of an implementation.
Lessons
- Overview of Data Management
- Intelligent Data Management Framework
- Concepts and Terminology
- Architecture
- Planning for Implementations
After completing this module, students will be able to:
- Describe the importance of data management and the different types of data management that are available
- Describe the capabilities of the Intelligent Data Management Framework for Dynamics AX 2012
- Define the concepts and terminology of Intelligent Data Management Framework
- Describe the architecture of the Intelligent Data Management Framework
- Explain planning for an implementation using the Intelligent Data Management Framework
Module 2: Installation and Configuration
This module examines the general topologies that are supported by IDMF. Then it describes the prerequisites for installing IDMF. After that, it shows you the steps that you must follow to install IDMF and runs the post-installation tasks to set up and configure IDMF for first use.
Lessons
- Introduction
- Prerequisites
- Installation
- Post-Installation Tasks
- Uninstallation and Troubleshooting
Lab : Install the Microsoft Intelligent Data Management Framework for Microsoft Dynamics AX 2012Lab : Complete the Post-Installation Tasks
After completing this module, students will be able to:
- List the topologies supported by the IDMF
- Identify the prerequisites for installing IDMF
- Demonstrate the process to install IDMF
- Demonstrate the process to complete the post-installation tasks and configure IDMF
Module 3: Analysis
This module examines the different features of the analysis functionality of the IDMF.
Lessons
- Introduction
- Analysis Dashboard
- Analysis Details
- Managing Indexes
- System Health
- Performance
After completing this module, students will be able to:
- Demonstrate how to use the Analysis dashboard
- Examine the Analysis details workspace
- Demonstrate how to manage indexes
- Describe the show system health functionality
- Describe the performance functionality
Module 4: Configuration
With the Configuration functionality of the Intelligent Data Management Framework (IDMF) for Microsoft Dynamics AX 2012, you can create and modify archive objects and purge objects.This module examines the different features of the Configuration functionality of IDMF.
Lessons
- Overview
- Master Data and Transactional Data
- Creating an Archive Object
- Creating a Purge Object
Lab : Create an Archive ObjectLab : Create a Purge Object
After completing this module, students will be able to:
- Describe the Configuration functionality
- Explain the differences between master data and transactional data
- Describe how to create an archive object
- Describe how to create a purge object
Module 5: Scheduling and Status Management
The scheduling and status management capabilities of the Intelligent Data Management Framework (IDMF) for Microsoft Dynamics AX can be used to create schedules for analyzing the production and archive databases, perform health checks using the production replica database, and synchronize metadata and master data from the production database to the archive database. In addition, you can use IDMF to purge, archive, and restore archived data.
Lessons
- Overview
- Analysis Snapshots
- Health Check
- Synchronization
- Purging and Archiving
Lab : Create a Periodic System Health Check ScheduleLab : Archive Production OrdersLab : Restore Production Orders
After completing this module, students will be able to:
- Summarize scheduling and status management
- Use scheduling and status management to analyze the production and archive databases
- Use scheduling and status management to perform health checks against a production replica database
- Use scheduling and status management to synchronize metadata and master data from the production database to the archive database
- Describe the capabilities of IDMF for scheduling and managing the status of purge, archive, and restore archive operations
- Create a schedule and view the status of a schedule
- Archive data from the production database to an archive database
- Restore data from an archive database to the production database
Module 6: Maintenance and Administration
The Administer menu of the Intelligent Data Management Framework (IDMF) for Microsoft Dynamics AX 2012 lets administrators efficiently maintain their Microsoft Dynamics AX database and guarantees smooth functioning of the application.This module examines the different features of the Administer menu.
Lessons
- Configuration
- Messages
- Managing Exceptions
- Framework Options
- Application Health Check
- Configuring Master Data Tables
- Database Maintenance
After completing this module, students will be able to:
- Describe how to configure database and email settings.
- Explain how to configure thresholds and alerts.
- Describe how to manage exception lists for archive and purge objects.
- Identify the framework options available in IDMF.
- Demonstrate how to view and create application health check queries.
- Describe how to configure master data tables.
Module 7: Troubleshooting
In this module, you will learn to troubleshoot common issues when you work with the Intelligent Data Management Framework (IDMF) for Microsoft Dynamics AX 2012.
Lessons
- Troubleshoot Installation Issues
- Troubleshoot IDMF Application Issues
After completing this module, students will be able to:
- Troubleshoot issues that occur when you install IDMF, by using the Configuration workspace or creating or managing scheduled jobs