Dynamics 365 BC / NAV

Business Central Data Integration

via SSIS Integration Toolkit

Integrate and migrate data to and from Business Central and NAV with any other application or data source including HubSpot, Trello, Google Analytics, and SurveyMonkey, to name just a few.

  Download   Purchase

Dynamics 365 NAV / BC data integration with KingswaySoft's SSIS Integration Toolkit

What other applications can you sync with Dynamics 365 BC / NAV?
Click here for more solutions.

Synchronize ERP Data

Synchronize Dynamics 365 NAV/BC with CRM, database, warehouse, reporting, and operational systems so business data remains current across applications. Retrieve data through OData, REST, or SOAP endpoints, and use filtering, ordering, row limits, batch settings, and selected fields to control extraction.

Synchronize Dynamics 365 NAV / BC data with CRM and business systems using SSIS
SSIS workflow automation for Dynamics 365 NAV / BC and connected systems

Support NAV/BC Write Workflows

Write data to Dynamics 365 NAV/BC using Create, Update, Delete, and Upsert actions. Use primary keys or manually specified matching fields to identify records, define how multiple matches should be handled, and configure batch size and multithreaded writing where supported.

Replicate Data

Dynamics 365 NAV / BC data replication for archival and business intelligence

Data Archival

Retrieve Dynamics 365 NAV/BC records into SSIS for archival, reporting, migration, and downstream processing. Use source objects, page filtering, OData conditions, child objects, max row controls, and selected fields to manage the data that is moved.

Retrieve Dynamics 365 NAV / BC data for analytics and data warehouse use

Data Analytics

Prepare Dynamics 365 NAV/BC data for BI and analytics across reporting platforms. Use SSIS workflows to move finance, sales, inventory, customer, and operational data into databases, warehouses, and other reporting destinations.

Business Central & NAV Data Integration is available in SSIS Integration Toolkit

Download Purchase Help Manual

Video Tutorial

Get Started with Dynamics 365 NAV / Business Central Components

Learn how to quickly connect, read, write, and synchronize Dynamics 365 NAV / Business Central data using KingswaySoft SSIS Components.

See Dynamics 365 NAV Video

Youtube Video - Getting started with SSIS Dynamics 365 NAV / Business Central Components

Key Features

  • Seamlessly connect, read from, and write to Dynamics 365 Business Central or Dynamics NAV Server directly within your SSIS packages.

  • Perform Create, Update, Upsert, and Delete operations on your NAV data.

  • Enjoy flexible connectivity options including OData, SOAP, and REST endpoints.

  • Ensure compatibility with various NAV server versions, from 2009 R2 up to the latest Business Central releases.

  • Benefit from secure authentication with both Basic and OAuth types, featuring robust token management.

  • Utilize customizable batch processing and multi-threaded writing support for efficient data transfer.

  • Access advanced filtering capabilities with an intuitive OData Query Designer or XML-based page filtering for SOAP connections.

  • Ensure data integrity with comprehensive record matching options, including primary keys and manually specified keys.

  • Gain granular control over error handling with options to redirect failed rows to a dedicated error output.

  • The Premium Service Lookup Component provides advanced lookup capabilities by searching records in Dynamics BC/NAV instances.

Business Central / NAV:
Data Integration Made Easy

Our solution is easy to use, offering codeless integration between Microsoft Dynamics 365 NAV/BC and other applications, databases, and business systems. Built for Microsoft SQL Server Integration Services, KingswaySoft's Dynamics 365 NAV/BC integration solution helps teams retrieve, write, match, and prepare NAV/BC data through dedicated SSIS components. With support for OData, REST, and SOAP endpoints, OAuth authentication, filtering, child objects, ChangeSet processing, multithreaded writing, record matching, and Premium Service Lookup, users can build NAV/BC integrations with greater control and visibility.

Our Dynamics 365 BC / NAV integration solution is available within the SSIS Integration Toolkit, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Dynamics 365 BC / NAV with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

Data Integration Scenarios

Integrate Dynamics 365 with Anything

Connect Dynamics 365 with popular services, APIs,
and databases using KingswaySoft’s prebuilt integration connectors.

Integrate Dynamics 365 with Azure Data Lake
Integrate Dynamics 365 with Azure Data Lake
Integrate Dynamics 365 with Azure Functions
Integrate Dynamics 365 with Azure Functions
Integrate Dynamics 365 with Azure Service Bus
Integrate Dynamics 365 with Azure Service Bus
Integrate Dynamics 365 with Excel
Integrate Dynamics 365 with Excel
Integrate Dynamics 365 with LinkedIn
Integrate Dynamics 365 with LinkedIn
Integrate Dynamics 365 with Power BI
Integrate Dynamics 365 with Power BI
Integrate Dynamics 365 with QuickBooks
Integrate Dynamics 365 with QuickBooks
Integrate Dynamics 365 with Salesforce
Integrate Dynamics 365 with Salesforce
Integrate Dynamics 365 with SharePoint
Integrate Dynamics 365 with SharePoint
Integrate Dynamics 365 with Microsoft Teams
Integrate Dynamics 365 with Microsoft Teams
Integrate Dynamics 365 with XML
Integrate Dynamics 365 with XML

More ERP Components

Our ERP components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular ERP solution. In addition to Dynamics 365 BC / NAV, we support the following ERP services:

SSIS Acumatica Connector
Acumatica
SSIS Extensiv Connector
Extensiv
SSIS Microsoft Dynamics 365 FO/AX Connector
Microsoft Dynamics 365 FO/AX
SSIS Microsoft Dynamics 365 Supply Chain Management Connector
Microsoft Dynamics 365 Supply Chain Management
SSIS Microsoft Dynamics GP Connector
Microsoft Dynamics GP
SSIS Microsoft Dynamics SL Connector
Microsoft Dynamics SL
SSIS NetSuite Connector
NetSuite
SSIS Odoo Connector
Odoo
SSIS SAP Connector
SAP

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!

Contact Us