Discover all the capabilities that make BC2SQL Sync the ultimate solution for Business Central data integration
Seamless API connectivity
Secure authentication with Microsoft Business Central APIs using industry-standard protocols
Works with Microsoft Business Central SaaS and OnPremise installations
Connect to sandbox, production, and custom Business Central environments
Real-time connection testing and API response validation
Flexible data transformation
Configure Business Central entities to sync with database tables
Detailed field mapping with data type conversion and validation
AI-powered field mapping using Levenshtein distance for automatic Business Central to database field matching
Automatic conversion of database-specific types to standard categories (String, Integer, Decimal, Boolean, Date, DateTime)
Efficient table pagination for Entity Mappings and Sync Jobs with 10 items per page
Pre and post-sync SQL scripts for advanced data processing
Universal database compatibility
Full support for Microsoft SQL Server with T-SQL syntax
Complete compatibility with MySQL and MariaDB databases
Native PostgreSQL support with advanced features
Reliable data synchronization
Automated sync jobs with flexible scheduling options
Efficient incremental synchronization based on timestamps
Live status tracking and comprehensive logging
Cutting-edge capabilities that set BC2SQL Sync apart from traditional integration tools
Intelligent record selection using random sampling instead of first records, ensuring representative data analysis for schema generation.
Automatic generation of CREATE TABLE scripts based on Business Central API JSON structure, supporting multiple database types.
Advanced entity duplication with option to include or exclude field mappings, streamlining configuration workflows.
Built-in version tracking system with API endpoint and web interface for monitoring application versions and updates.
Responsive Bootstrap-based interface with intuitive navigation, real-time updates, and mobile-friendly design.
Comprehensive security with user authentication, role-based access control, and secure API communication protocols.
AI-powered field mapping using Levenshtein distance algorithm for automatic matching of Business Central fields with database columns.
Automatic conversion of database-specific data types to standard categories ensuring successful synchronization across SQL Server, MySQL, and PostgreSQL.
Efficient table pagination for Entity Mappings and Sync Jobs with 10 items per page, improving performance for large datasets.
Discover how our comprehensive feature set can transform your Business Central integration