Data Config
These are special values needed for a database process that runs in the background. You can activate or deactivate some Data Director functionality here.
Field | Description |
---|---|
Ignore Extra Fields | Ignores any extra fields in the job that are not available in the source or destination databases. |
Decimal Fix | Fixes rounding issues with decimal data transfer. F05 indicates 5 decimal places. When dealing with large decimal values that do not need high decimal places, set this value to BIG. BIG will only use 4 decimal places, which leaves mores space for the main value. |
SQL Timeout | SQL Command Timeout. Gets or sets the wait time before terminating the attempt to execute a command and generating an error. |
Use Trunc | If jobs include Delete all data, using Trunc will speed up the delete process in large tables. This only works on SQL databases and the table cannot have any foreign keys for this to work. |
IsoLevel | Default locking and row versioning behavior of Transact-SQL statements issued by a connection to SQL Server. |
Timeout | The idle timeout for the database connection to stay open after job processing. If set to 0, the database connection is not kept alive, but may still slow down processing. Each database thread will take up 1 user session on the Database server. |
NAV SQL Replace Chr | The character to replace in Table/Field names to _ when using SQL to access NAV/BC Database. If empty, defaults will be used, otherwise put in the characters that should be replaced with _ Defaults are: NAV 2009 [.'/] NAV 201x [.'/%] No replacement [X] |
FOB Timeout | FOB Import/Export Processing Timeout (only for NAV 2013 or newer). |
Use WS | Use LS Central Web Services for Source location when LS Central is located in the cloud and SQL database is not directly reachable. |
Batch Size | Default batch size of data rows when replicate from and to LS Central Web Services. This batch size can be modified by setting the batch value in the Integer field in the Scheduler Job - Object Setup section. |
Timeout | Connection timeout to wait for LS Central Web Service to respond to request. |
CFront | Supports CFront to communicate with NAV 2009 or older. When selected, extra number of DDDatabase86 processes will be executed, depending on the Data Thread Limit. If not selected, only x64 version of the DDDatabase process will run. |
CU Permission | The CodeUnit used to set the permission for the Data Director to access the Database. |
CFront Path | The path where CFront Files are located for Dynamic NAV Database Access. |
Send License | Send new or updated NAV license to DD Hosts. This will only update the NAV license that DD uses, not update the NAV Server / Client installation. |
In the lsretail.config file there are extra values that are not visible in the Configuration Tool:
ThrTimeOut | Used with CFront to kill a thread that has been idle for x minutes. |
TSTimeOut | Used with CFront to kill a Trans Server call that has been idle for x seconds. |
SUpd | If set to True, DD will use one statement to update or insert a record, instead of running either insert or update, which causes DD to try update first, if fail then do insert. This does not work on all tables and depends on how they are set up in the SQL Database. |
CentralUserGuid | Used to insert into $SystemModifiedX fields in LS Central if the value is missing in replication data, like when sending data from older versions. |