The LS Data Director (DD) is a product of LS Retail ehf. and is closely tied to LS Central and the company's POS point-of-sale application. The Data Director plays an integral part in enabling the system to function as a whole in a distributed environment.
The Data Director is an application specialized in moving data between databases in a fast and efficient way. It works intimately with the Microsoft Business Central platform, but it is not limited to that platform. It can just as easily move data between other databases, such as MS SQL Server and MySQL. Generally, if the database supports the Microsoft OleDB or ODBC interface, the Data Director should be able to use it.
The Data Director is a flexible tool that can be adapted to a variety of data transfer scenarios. The most commonly used configurations are for:
- Moving data between the head-office, stores, and POS terminals in a Business Central based retail organization.
- Moving data from Business Central based databases into a data warehouse running on Microsoft SQL Server.
Definition of terms
The following is a list of terms and titles often used in connection with the Data Director with a brief explanation:
| Term | Description |
|---|---|
| DD | Acronym for the Data Director. |
| DD Service | This is the server component of the Data Director that keeps all other DD processes alive and monitors the health of the system. If any process goes down, DD Service restarts the process, if possible. The DD Service runs as a service on the host computer. |
| Destination Database/Data | This is the database into which you want to write data. |
| Host Computer | The computer running the service part of the Data Director. |
| Package | A package contains the data being transferred between the databases. A package has a destination Data Director and a destination database, which can be one or many, depending on how it was created. This essentially represents a unit of work for the Data Director. |
| Scheduler | The Scheduler is used for scheduling Data Director activities at predefined intervals, such as sending sales data to a Head Office database every hour. The Scheduler can be run in a Dynamics NAV client, Dynamics NAV/BC Application Server (NAS), or DD Scheduler Service. |
| Scheduler Database | This is the Dynamics NAV/BC or LS One Site Manager database that contains all the details regarding tasks that the Data Director should perform (when to send, which tables, which fields, and so on). The Data Director log and the Scheduler can also be configured to reside in the same database. |
| Source Database/Data | This is the database from which you want to read data. |
| TransAutomClient.dll | Used by LS Retail for sending queries to the Data Director. |
See also