Skip to searchSkip to main content
SRNTS

Course Overview

Virtual Tables in Microsoft Dataverse allow users to access and display data from external systems without physically storing the data inside Dataverse. This training provides a complete understanding of Virtual Tables, including configuration, data integration, security considerations, custom data providers, and real-world implementation scenarios. Participants will learn how to connect external data sources and make them available within Dynamics 365 and Power Platform applications.

Audience

This training is designed for:

  • Microsoft Dynamics 365 Developers
  • Power Platform Developers
  • Solution Architects
  • Technical Consultants
  • Integration Specialists
  • Application Developers working with Dataverse
  • IT Professionals interested in external data integration

Pre-requisite

Participants should have:

  • Basic understanding of Microsoft Power Platform
  • Knowledge of Dataverse and Dynamics 365 concepts
  • Basic understanding of data integration and APIs
  • Familiarity with Power Apps and Model-Driven Apps
  • Basic knowledge of C# and Azure services (recommended but not mandatory)

Key Benefits

  • Understand Virtual Table architecture and components.
  • Learn to integrate external data sources without data replication.
  • Reduce data storage requirements in Dataverse.
  • Improve real-time access to external business data.
  • Configure and manage Virtual Tables in Dynamics 365 and Power Platform.
  • Implement secure and scalable integration solutions.
  • Gain hands-on experience through practical demonstrations and use cases

    • Curriculum


    Virtual Table Training Curriculum (07 Hours)

    Module 1: Introduction to Virtual Tables (1 Hour)

    • Overview of Microsoft Dataverse
    • What are Virtual Tables?
    • Virtual Tables vs Standard Dataverse Tables
    • Architecture and Components
    • Benefits and Limitations
    • Real-world Business Use Cases

    Module 2: Virtual Table Configuration Basics (1 Hour)

    • Prerequisites and Environment Setup
    • Enabling Virtual Table Functionality
    • Creating and Configuring Virtual Tables
    • Understanding Table Properties and Metadata
    • Publishing and Testing Virtual Tables
    • Troubleshooting Common Configuration Issues

    Module 3: Connecting External Data Sources (1.5 Hours)

    • Overview of Supported Data Providers
    • SQL Server Virtual Tables
    • OData Virtual Tables
    • Connecting External Systems
    • Authentication and Connection Management
    • Mapping External Data to Dataverse
    • Data Refresh and Synchronization Concepts

    Module 4: Security and Data Access (1 Hour)

    • Virtual Table Security Model
    • Role-Based Access Control
    • Dataverse Security Integration
    • Managing User Permissions
    • Data Visibility and Access Considerations
    • Security Best Practices

    Module 5: Using Virtual Tables in Power Platform (1 Hour)

    • Virtual Tables in Model-Driven Apps
    • Working with Forms and Views
    • Using Virtual Tables in Power Apps
    • Integration with Power Automate
    • Business Process Considerations
    • User Experience Optimization

    Module 6: Advanced Virtual Table Concepts (1 Hour)

    • Custom Virtual Table Data Providers
    • External Data Provider Architecture
    • Performance Optimization Techniques
    • Handling Large Datasets
    • Error Handling and Monitoring
    • Best Practices for Enterprise Implementations

    Module 7: Hands-on Lab and Real-World Implementation (0.5 Hour)

    • Creating a Virtual Table from an External Source
    • Configuring Forms and Views
    • Testing Data Access and Security
    • Common Troubleshooting Scenarios
    • Real-World Project Implementation Walkthrough
    • Q&A and Training Summary

    Total Duration: 07 Hours.