All Apps
Menu

Technical Integration

Download drag and drop

Technical Integration

This document provides detailed technical information about integrating the Drag & Drop extension with existing Business Central environments, third-party systems, and custom development scenarios.

Business Central Integration Framework

AL Object Integration

Extension Object Model: The Drag & Drop extension integrates seamlessly with Business Central's AL object model through:

Page Extensions: - Systematic extension of standard Business Central pages - Consistent FactBox integration pattern across all supported entities - Event-driven context management for record relationships - Minimal impact on existing page customizations

Table Integration: - Utilizes Business Central's standard Document Attachment table - No custom table additions or modifications required - Maintains data integrity through standard Business Central frameworks - Preserves audit trail and change tracking capabilities

Codeunit Architecture: - Modular design enables integration with existing business logic - Event-driven architecture supports custom workflow integration - Standard AL patterns ensure compatibility with future Business Central updates - Clear separation of client and server-side processing

Permission Set Integration

Security Framework Alignment: - Leverages Business Central's role-based access control - Integrates with existing permission sets and user groups - Granular control over functionality access - Supports complex organizational security requirements

Permission Inheritance: - Document attachment permissions inherit from source record permissions - Multi-company security follows standard Business Central patterns - Integration with custom security models supported - Audit and compliance tracking through standard Business Central mechanisms

API and Extensibility Integration

Business Central API Compatibility

Standard Business Central APIs: - Document attachments accessible through Business Central's standard APIs - OData and REST endpoint support for external system integration - Maintain API compatibility for existing integrations - Support for PowerBI, PowerApps, and Flow integrations

Custom API Development: - Extension points available for custom API development - Integration with Business Central's published event framework - Support for webhook and callback integrations - Real-time data synchronization capabilities

Webhook and Event Integration

Business Central Events: - Integration with standard Business Central event framework - Custom event subscribers supported for workflow integration - Real-time processing capabilities for immediate business responses - Asynchronous processing support for large file operations

External System Notifications: - Configurable webhook support for external system notifications - Document upload events can trigger external workflows - Integration with Microsoft Power Platform for enhanced automation - Support for custom notification and alert systems

Third-Party System Integration

Document Management System Integration

SharePoint Online Integration:

Configuration Pattern:
1. Business Central serves as document relationship manager
2. SharePoint provides document storage and collaboration
3. Hybrid approach maintains Business Central workflow benefits
4. Deep linking preserves document context

Enterprise Document Management: - Integration patterns for major document management platforms - Bi-directional synchronization capabilities - Metadata preservation across systems - Workflow integration maintenance

ERP Integration Scenarios

Multi-System Environments: - Document attachment synchronization across ERP systems - Central document repository with distributed access - Cross-system audit trail maintenance - Unified user experience across platforms

Legacy System Integration: - Migration strategies for existing document management systems - Data preservation and historical access maintenance - Incremental migration approaches - User training and change management support

Cloud Storage Integration

Microsoft 365 Integration: - OneDrive for Business synchronization capabilities - Teams integration for collaborative document management - Outlook integration for email attachment workflows - Power Platform integration for enhanced automation

Third-Party Cloud Storage: - Generic cloud storage integration patterns - Security and compliance considerations - Performance optimization for remote storage - User experience consistency across storage platforms

Custom Development Integration

AL Development Patterns

Extension Development Guidelines:

// Example integration pattern for custom page extension
pageextension 50100 "Custom Customer Ext" extends "Customer Card"
{
    layout
    {
        addafter(Control1)
        {
            part("QTEAM DropArea Custom"; "QTEAM DropArea")
            {
                ApplicationArea = All;
                SubPageLink = "Table ID" = const(18),
                              "No." = field("No."),
                              "Document Type" = const(Customer);
            }
        }
    }
    
    trigger OnAfterGetCurrRecord()
    begin
        CurrPage."QTEAM DropArea Custom".Page.SetRecordData(18, Rec."No.", 0, "Customer");
    end;
}

Event Subscriber Implementation:

// Example event subscriber for document upload handling
[EventSubscriber(ObjectType::Codeunit, Codeunit::"QTEAM DropArea Management", 'OnAfterFileCommit', '', false, false)]
local procedure OnAfterFileCommit(TableId: Integer; DocumentNo: Code[20], DocumentType: Text; FileName: Text)
begin
    // Custom business logic after file upload
    if TableId = Database::Customer then
        HandleCustomerDocumentUpload(DocumentNo, FileName);
end;

Custom Page Integration

FactBox Integration Patterns: - Consistent placement strategies for optimal user experience - Custom page adaptation guidelines - Performance optimization for complex pages - Mobile responsiveness considerations

Custom Entity Support: - Pattern for extending Drag & Drop to custom tables - Relationship management for custom entities - Security and permission considerations - Testing and validation procedures

Performance Integration Considerations

Database Performance

Optimization Strategies: - Document Attachment table indexing considerations - Query optimization for large attachment volumes - Database maintenance procedures for optimal performance - Storage optimization strategies

Capacity Planning: - Storage growth projection based on usage patterns - Database sizing considerations for attachment storage - Backup and recovery impact planning - Performance baseline establishment and monitoring

Network Performance

Bandwidth Optimization: - File transfer optimization techniques - Progressive upload capabilities for large files - Network latency consideration in user experience design - Mobile and remote access optimization

Content Delivery Optimization: - Caching strategies for frequently accessed documents - Content compression and optimization techniques - Geographic distribution considerations for global organizations - Performance monitoring and alerting systems

Security Integration

Authentication Integration

Azure Active Directory Integration: - Single Sign-On (SSO) support for seamless user experience - Multi-factor authentication compatibility - Conditional access policy support - Identity governance and compliance integration

Third-Party Authentication: - Integration patterns for non-Microsoft authentication systems - API key and certificate-based authentication support - OAuth 2.0 and SAML integration capabilities - Security token management and renewal

Data Security Integration

Encryption Integration: - Integration with Business Central's encryption framework - Custom encryption requirements for sensitive documents - Key management and rotation procedures - Compliance with industry-specific encryption standards

Data Loss Prevention (DLP): - Integration with Microsoft 365 DLP policies - Custom DLP rule development and enforcement - Sensitive data classification and handling - Audit and compliance reporting integration

Monitoring and Analytics Integration

Business Intelligence Integration

Power BI Integration: - Document attachment analytics and reporting dashboards - User adoption and usage pattern analysis - Storage utilization and performance monitoring - Business process efficiency measurement

Custom Reporting Integration: - Integration with existing Business Central reporting framework - Document attachment inclusion in standard reports - Custom report development for document management insights - Real-time monitoring and alerting capabilities

System Monitoring Integration

Application Insights Integration: - Performance monitoring and alerting - User behavior analytics and optimization insights - Error tracking and resolution automation - Capacity planning and resource optimization

Custom Monitoring Solutions: - Integration patterns for enterprise monitoring platforms - Custom metric collection and reporting - Proactive issue detection and resolution - Performance trend analysis and optimization

Migration and Upgrade Integration

Data Migration Strategies

Existing Document Migration: - Automated migration tools for existing document attachments - Data validation and integrity verification procedures - Incremental migration approaches for minimal business disruption - Rollback and recovery procedures for migration issues

System Upgrade Integration: - Business Central version upgrade compatibility maintenance - Extension update and migration procedures - Data preservation during system upgrades - User training and change management for updated functionality

Integration Testing Strategies

Comprehensive Testing Framework: - Unit testing for AL code modifications - Integration testing for third-party system connectivity - Performance testing under realistic load conditions - User acceptance testing for workflow integration

Automated Testing Integration: - Continuous integration pipeline integration - Automated regression testing for extension updates - Performance benchmark testing and validation - Security and compliance testing automation

This comprehensive technical integration guide provides the foundation for successfully integrating the Drag & Drop extension with complex Business Central environments and external systems while maintaining performance, security, and compliance requirements.