Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Server Setup

The server setup defines connections to external data stores. Table setups then reference these server configurations. You can set up multiple connections to synchronize data to different databases. To open the list you can search for "SQL Connector Server Setup" or select the "Server Setup" action available on most pages in the system.

Server List

The list shows all configured connections along with key information. Note that it is best to edit these settings through the card that opens when clicking on the primary key of an entry in the list.

ColumnDescription
Primary KeyUnique code identifying this connection (e.g. SQLDEV, PROD)
DescriptionFree-text description of the connection
Max Retry AttemptsHow many times to retry a failed dispatch
ServerServer address
DatabaseDatabase name
User NameUsername used for authentication
App PathAzure Function endpoint path
Trust Server CertificateWhether to trust a self-signed certificate (for dev environments)
Send failure notification toEmail address that receives error notifications

Actions on list page

ActionDescription
Test ConnectionTests the connection to the server via the selected transfer method

You can also navigate directly to synchronization tables, processing log, deletion log and automation from the list page.

The FactBox displays a list of tables linked to this server setup.

Server Card

Click the primary key of an entry in the list to open the detailed setup card.

General

FieldDescription
Primary KeyUnique code identifying this connection (e.g. SQLDEV, PROD)
DescriptionFree-text description of the connection
Payload FormatFormat of data packages. Currently only T-SQL is supported
Transport MethodHow data packages are delivered. Currently only Azure Function is supported

Server Connection

FieldDescription
ServerServer address
DatabaseDatabase name
User NameSQL login. Leave empty when using Managed Identity
PasswordSQL password (stored in secure storage, displayed as ***). Leave empty when using Managed Identity
Trust Server CertificateWhether to trust a self-signed certificate (for dev environments)
Connection StringAlternative: enter a full connection string instead of individual fields (stored in secure storage)

Azure Function

FieldDescription
App PathAzure Function endpoint URL (e.g. https://<function-app>.azurewebsites.net/api/ExecuteSQLCommand)
App KeyAzure Function API key for authentication (stored in secure storage, displayed as ***). The key can be found in the Azure Portal under Function App → App Keys → Host keys (or Function keys)

Notifications & Retries

FieldDescription
Send failure notification toEmail address that receives notifications when synchronization fails
Notification LevelWhen to send notifications: Failures only (default), All or None
Notification MethodNotification channel. Default: Email
Max Retry AttemptsNumber of retries before giving up on a failed dispatch
Stop Package on ErrorWhen enabled, pending entries for a package type are blocked if that package currently has failed entries
Log Retention DaysHow long processing log entries are kept. Set to 0 to disable automatic cleanup. (default: 30 days)
Delete Log Retention DaysHow long deletion log entries are kept. Set to 0 to disable automatic cleanup. (default: 30 days)

Advanced Settings

FieldDescription
HTTP Timeout (ms)Maximum time to wait for a response from Azure Function (default: 300,000 ms / 5 minutes, minimum: 5,000 ms)
Compress PayloadWhen enabled, the data package is GZip-compressed before being sent
Decimal PrecisionSQL DECIMAL precision for decimal fields (default: 38, range: 1–38)
Decimal ScaleSQL DECIMAL scale for decimal fields (default: 20, range: 0–38)

Batch Size Advisor

Settings used to generate batch size suggestions.

FieldDescription
Target Payload (KB)Maximum payload size used for batch size estimation (default: 4,096 KB / 4 MB, minimum: 256 KB)
Safety Margin %Safety margin subtracted from payload and timeout limits during estimation (default: 20%, range: 0–50%)
Transfer Rate (bytes/ms)Assumed transfer speed used for timeout-based batch size estimation (default: 500 bytes/ms, minimum: 50)
Default Batch FallbackFallback batch size when estimation cannot determine a better value (default: 200, minimum: 1)

Actions on card

ActionDescription
Test ConnectionTests the connection to the server via the selected transfer method

Credential Security

  • Passwords, API keys and connection strings are never stored as plain text in the database.
  • They are stored in Isolated Storage, a key vault in Business Central specifically designed for secret values.
  • The interface displays *** when a secret value has been set, and an empty field when nothing is stored, but the value is not exportable.