Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Table Setup

Here you can select which Business Central tables to synchronize with external data stores and configure how the synchronization works. To open the list you can search for "SQL Connector Table Page", and it is also accessible through the "Tables for synchronization" actions in various places in the system.

Table List

Table list

ColumnDescription
CodeUnique identifier for this table setup
DescriptionDescriptive name of the table
Table No.Number of the Business Central table being synchronized
Table nameSystem name of the table (automatic)
Table captionThe name used as the table name in the external data store (editable, special characters are automatically cleaned)
Row Version CheckpointInternal tracking value (Row Version) indicating synchronization status. Records changed after this value will be exported in the next synchronization.
Record Last Modified AtShows when the record corresponding to the change stamp was last modified.

The FactBox on the right side displays synchronization statistics for the selected table.

Synchronization statistics

Table Card

Click on the code of an entry in the list to open the card page.

Table card

General

FieldDescription
CodeUnique identifier for this table setup
DescriptionDescriptive name of the table
Table No.Number of the Business Central table being synchronized. Use the lookup to browse available tables. When selected, the system offers default values (200 records per data package, 10,000 records per job, automatic server assignment and automatic field assignment).
Table NameSystem name of the table (automatic)
Table CaptionThe name used as the table name in the external data store (editable, special characters are automatically cleaned)

Synchronization

FieldDescription
EnableActivates the table for synchronization. Warnings are displayed if no server setup is linked, no fields are configured, or the table structure has not been created. You can continue despite warnings.
Server CodeWhich server setup to use (lookup on server list)
Records per MessageHow many records are placed in each data package (minimum: 1). Affects the size and processing time of data packages.
Records per JobMaximum number of records per job queue run (minimum: 1). Limits how much work a single run performs, including a forced full sync.
Row Version CheckpointInternal timestamp (Row Version) indicating synchronization status. The synchronization exports records with a higher timestamp than this value in the next run.
Record Last Modified AtShows when the record corresponding to the change stamp was last modified. This value can be changed to move the synchronization pointer back in time.
Force Full SyncWhen enabled, the next run bypasses the table filters, resets Row Version Checkpoint to 0, and queues a command to truncate the SQL table. The run still processes no more than Records per Job records. The flag resets when processing starts, before queued commands are delivered; later runs use the normal filters.

Schema

FieldDescription
Table Structure CreatedShows whether the table structure is marked as created. SQL Connector sets this when it adds the create-table command to the processing log; it does not confirm that the command has been delivered to the external database.
Last Delete Log EntryNumber of the last processed deletion log entry

Advanced

FieldDescription
Include Company in KeyIncludes the BC company name in the record primary key. Useful in environments with multiple companies where the same table is exported from several companies to the same database.
Export Enum/Option as TextWhen enabled, option/enum fields are exported as readable text instead of numeric values.
Skip Default Values On InsertWhen enabled, fields that have their default value are omitted from insert payloads. This reduces payload size but requires the target table to define its own default values.

Fields

At the bottom of the card, a list of fields to be exported is displayed. See more in Field Setup.

Fields

Sync Statistics (FactBox)

The FactBox displays real-time figures for the selected table, similar to the list page.

Synchronization statistics

Progress

MetricDescription
Total RecordsTotal count in BC table
Records SyncedRecords that have already been exported based on Row Version Checkpoint
Records RemainingRecords still to be exported based on Row Version Checkpoint
0DT RecordsRecords where the system field SystemModifiedAt = 0DT

Batch Settings

FieldDescription
Records per MessageBatch size for this table
Records per JobRecord limit per job for this table

Processing Log

StatusDescription
PendingPending entries for this table
In progressEntries being dispatched
FailedFailed entries
BlockedEntries blocked because a prior entry for the same package failed
CompletedSuccessful entries

Click on each status to open a filtered processing log.

On the table card below the synchronization statistics, processing log entries for the table are visible with available actions: Process Entry, Process All Unprocessed Entries.

Actions on Table Card

Schema

ActionDescription
Create TableQueues a command to create the table structure on the connected server. Only visible when the structure is not marked as created under Schema.
Add Missing ColumnsAnalyzes fields in the BC setup and creates ALTER TABLE ADD commands for the external data store.

Management

ActionDescription
Recreate TableDrops the external table and recreates it. Requires confirmation. Resets the timestamp and deletion log pointer under Schema.
Drop Removed ColumnsAnalyzes columns in the SQL table that no longer have corresponding BC fields and creates ALTER TABLE DROP COLUMN commands. Shows a confirmation with a list of columns to be removed.
Force Full Re-syncSets a flag so the next run clears the table and re-exports all data.

Data

ActionDescription
Export DataScans for changed records and queues data packages in the processing log. The data packages are not sent immediately. Use "Process All Unprocessed Entries" from the dashboard or processing log to send them. Also happens automatically with appropriately configured job queue entries.
FiltersOpens table filters to limit which records are exported. See more here
Suggest Batch SizeAnalyzes the field setup and estimated record sizes to recommend optimal values for Records per data package.
Preview Payload SizeCreates a sample data package and reports its estimated size.