Daily use: Extraction from Business Central to Azure SQL Database
Select tables and fields
Once the connection to App registration, Storage account and SQL database is verified, you can select the tables and fields that you want to synchronize on the Data Warehouse Connector Setup page.
Once you’re happy with the table/field setup, press the Export command and/or set up a scheduled export.
Advanced options
Advanced options include:
- Selecting a Decimal field for a table to be used as a checksum field. If selected, the Business Central Data Warehouse Connector will compare the checksum as well as the record count before marking the table with “Data Warehouse checksum OK.”
- Selecting a custom Schema Name for the tables in your data warehouse. The default value is [dbo] like in the Business Central database.
