Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

SQL Connector

Rue de Net SQL Connector is an extension for Microsoft Dynamics 365 Business Central that automatically copies data from Business Central tables to external data stores. It lets you keep a near real-time copy of selected data for use in, for example, reporting with Power BI or other analytics tools.

Overview

SQL Connector transfers data from Business Central to an external data store such as Azure SQL or Fabric.

  • You choose any Business Central table and decide which fields to include.
  • You connect to one or more external data stores.
  • A dedicated dashboard shows the transfer status, the number of pending, failed and completed operations, and the status of the job queue entries.
  • You get an email notification when an operation fails.

How it works

  1. A server setup defines the connection to an external data store. See Server Setup.
  2. A table setup says which tables and fields to synchronize and to which server. See Table Setup.
  3. The extension monitors inserts, modifications, deletions and renames in Business Central and creates the corresponding commands in data packages in the processing log. See Processing Log and Deletion Log.
  4. Job queue entries run the transfer at configurable intervals and send the packages to the external data store. See Automation.

Benefits

  • Automatic data transfer without manual effort.
  • A reliable processing queue with retry on failures.
  • Support for multiple companies and multiple databases.
  • A detailed overview of all operations and the SQL commands behind them.
  • Notifications when synchronization fails.