Rue de Net SQL Runner

Rue de Net SQL Runner is a managed Azure Function that acts as a secure execution bridge between Microsoft Dynamics 365 Business Central and your SQL Server databases.

How it works:

• The Rue de Net Fabric & SQL Connector (Delta Sync) extension in Business Central detects record changes and generates SQL commands
• Commands are sent as JSON payloads via HTTPS to this Azure Function
• The function executes the SQL statements against your target SQL Server

Key capabilities:

• Full and incremental (delta) data synchronization
• Upsert, delete, and DDL operations (CREATE TABLE, DROP TABLE)
• Secure credential handling — connection strings passed via HTTP headers, never stored in payloads
• Runs on Azure Functions consumption plan (pay only for what you use)

What gets deployed:

• Azure Function App
• App Service Plan (Consumption/Serverless)
• Storage Account
• Application Insights with Log Analytics

Prerequisites:

• The Rue de Net Fabric & SQL Connector (Delta Sync) extension installed in your Business Central environment

A SQL Server database accessible from Azure (Azure SQL, SQL Server with public endpoint, or via VNet. Alternatively you can use Managed Identity off the Azure Function and add it as an external user to the SQL database.)

Ideal for organizations that need near-real-time, one-way data replication from Business Central to SQL Server for reporting, analytics, or integration purposes.