In today’s fast-paced digital economy, Japan-based companies demand integrated, agile systems that break down data silos and improve cross-platform visibility. At Sysamic KK, we specialize in helping global businesses operating in Japan leverage Microsoft Dynamics 365 Business Central to its fullest potential. One advanced feature that significantly enhances data accessibility is the use of synthetic relationships in virtual tables, connecting Business Central with Dataverse and other Dynamics 365 applications.
This blog explores how synthetic relationships work, why they matter for enterprises in Japan, and how Sysamic KK can help implement them for seamless data connectivity and increased operational efficiency.
Why It Matters: Business Value for Japan Enterprises
Many organizations in Japan rely on a mix of ERP, CRM, and industry-specific tools. Without a unified data model, valuable insights can remain trapped in silos. By utilizing synthetic relationships and virtual tables, businesses can:
- Make Business Central data visible across Dynamics 365 apps such as Sales, Field Service, or Customer Insights.
- Avoid unnecessary duplication by linking synchronized and unsynchronized datasets.
- Provide users with consistent, real-time access to Business Central data from within their preferred Dynamics apps.
This approach helps Japan-based companies—especially those with global operations—build smarter, more responsive systems without the need for custom development.
Two Approaches to Data Integration
When connecting Microsoft Dynamics 365 Business Central with Dataverse, you have two key integration methods:
- Data Synchronization: Copies data between Business Central and Dataverse.
- Virtual Tables: Keeps the data in Business Central while making it accessible in Dataverse through a real-time link.
To unlock more potential, you can combine these methods by introducing synthetic relationships—a technique that links synchronized tables with virtual ones, expanding access without expanding your data footprint.
Setting Up Synthetic Relationships: Step-by-Step
Step 1: Enable Virtual Tables
Start by navigating to the Available Virtual Tables page in Business Central. Use the Enable action to activate virtual table access.
Step 2: Configure the Relationship
Go to the Dataverse Connection Setup page. Select Virtual Tables, then click on Synthetic Relations.
Use the New Synthetic Relation wizard to start the process:
- Select a native Dataverse table (e.g., CRM Account) representing synchronized data.
- Select a virtual Dataverse table (e.g., Purchase Invoice).
- Define the number of fields you’ll use to connect these tables (up to three).
Step 3: Map Fields
Specify which fields from the native and virtual tables will be used to establish the relationship. This step ensures that the data correlation is meaningful and accurate.
Step 4: Validate and Finish
After validation, the system creates the synthetic relationship and necessary keys. You can further manage and model relationships directly in Dataverse if needed.
Real-World Impact: A Japan-Based Use Case
Imagine a multinational company operating in Japan using Dynamics 365 Sales and Business Central. By setting up a synthetic relationship between the CRM Account and Sales Shipments (virtual table) in Business Central, their sales team can open an account record and instantly view related shipments—without leaving their CRM interface.
This seamless visibility improves customer service, shortens sales cycles, and enhances decision-making across departments—all with zero code.
Why Sysamic KK?
As a Japan-based Microsoft partner, Sysamic KK brings a deep understanding of both local business practices and global ERP-CRM architecture. Our team is well-versed in implementing Business Central integrations tailored for the Japanese market—ensuring compliance, performance, and long-term scalability.
We help our clients go beyond out-of-the-box setups by enabling advanced capabilities like synthetic relationships and virtual tables, bridging data across platforms while maintaining security and efficiency.
For companies operating in Japan, leveraging synthetic relationships between Business Central and Dataverse is more than a technical enhancement—it’s a strategic move. It enables connected business processes, boosts data transparency, and helps teams work smarter across systems.
Let Sysamic KK guide you in unlocking the full potential of your Dynamics 365 investment in Japan.