These are special values needed for an Azure and 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. |
| Use External Srv | Support for External process to handle data query or inserts, This is customized process developed by 3rd party. Sample code to create this process is available by request. |
| Connection String | Azure File Storage Connection string to connect to an Azure folder where the Job file will be stored for the Offline Host to pull jobs from. |
| Share Name | Azure Share name for File Storage. |
| Work Folder | Folder in Azure Share that will be used for Job Files, if any. DD will create sub folders there with Host name of hosts that will be pulling jobs from here. If no folder is specified, the host folders will be created in the root of the share. |
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. |