Configuring Data Director Part 1

-

Introduction

Data Director is one of the applications from LS Retail and it is essential to keep the data between the POS, Stores and HO in sync.

Data Director is used to move data between databases, generally used with MS SQL Server but it is not limited to it and can be used with databases like MySQL as well.

A rule of thumb is that If the database supports ODBC then the Data Director should be able to use it.

Read the “Data Director User Guide” for more information.

Pre-requisites

  • Microsoft Dynamics 365 Business Central
  • LS Central
  • Data Director V3.02

References

Configuration

Data Director Installation

Open the data director installation package.



Select or deselect the components as you need, if you’re setting up Data Director for a new system the following are sufficient.


If you have not changed the “Default Web Site” name in IIS, then you can leave this step unchanged.


Click install and wait for a few seconds.


To test if the Data Director service is running properly, go to “http://localhost/DDWebService/DDJson.svc/Ping” and if the returned response looks like this then it is properly installed.


In some cases, I have found that there are issues when we try to run the job we get this error;


Go to - “C:\Program Files (x86)\LS Retail\Data Director 3\bin”, set a filter on “Type” and choose “Application Extension” and copy all the files there, 
then go to “C:\Program Files\Microsoft Dynamics 365 Business Central\160\Service\Add-ins\LSRetail\DD\Control” if this path does not exist, 
then create it and paste all the files there, this should resolve that issue.






Network Configuration
Go to the Networking tab in your azure portal and create “Inbound” and “Outbound” port rules allowing the following ports.
16860 - TCPS - For secured Data Director
16850 - TCP - For Data Director
16803 - If your Data Director is using Cfront processing then this port is required, otherwise you can skip it.
80 - It is useful in debugging and testing data director connections.


Similarly, go to “Windows Defender Firewall with Advanced Security” and create Firewall rules, both inbound and outbound for the same ports.



Host FileGo to “C:\Windows\System32\drivers\etc"
Modify the “hosts” file and add the IP Host-name like the below example.
Do note that, you need admin privileges, to modify this file.



Conclusion

Thus, we saw how to install Data Director, configure Network connections and modify Host file.
In the next part we will configure SQL Server and Business Central so that we can finally use Data Director.

Happy Coding!


Comments

Post a Comment

Popular posts from this blog

Using Notifications in Business Central via AL

-
Image
Introduction Notifications in Business Central are alerts that appears in the Notification bar based on User actions. Notifications stack up from top to bottom, lasting until the user dismisses them, including those from sub-pages.  Validation errors are prioritized and shown before other notifications. We can use this to alert the user regarding something without taking all the user's notification towards it, in the way messages or errors do. They also have the option to allow Users to make a corrective action by embedding the action button directly into the notification. Let's see how it works. Source Code Pre-requisites Business Central OnPrem/Cloud. References Notification - Business Central Docs Configuration Here, for an example, I've created one simple page which takes two inputs. 1. The message that is to be shown in the notification. 2. The message to be shown after the User clicks on the action embedded in the notification.     And I have two actions which I'l...
Read more

Actionable Error Messages in Business Central

-
Image
Introduction Error handling is an important concept in every technical field.  It helps programs deal with unexpected problems and mistakes smoothly.  It makes sure software works reliably and doesn't crash unexpectedly.  Error handling also helps developers find and fix issues quickly, making the software better for users. Plus, it gives users clear messages when something goes wrong, making their experience smoother. It shows that the team has considered the scenario and has measures in place for it indicating a well designed solution. Microsoft has an amazing document which lists the things to keep in mind for writing resilient code. In Business Central, we have try functions to handle errors and error function to show those errors to the Users.  In this blog, we'll learn how we can enhance the error messages so that the Users can resolve the errors themselves or at the very least we can point them towards where the error is. Pre-requisites Business Central OnPrem...
Read more

Configure Gmail SMTP service in Business Central without "Allow Less Secure" setting

-
Image
 Introduction Business Central has great email features like sending email, editing it with Rich Text, adding attachments, etc, but to send emails, you'll need to connect it with services like Outlook or Gmail. There is no outlook side configuration that is to be done if you are using Microsoft Outlook however if you are using Google's Gmail then there's a litte change that has happened on the configuration end. Starting May, 2022, Google has removed the "Allow Less Secure Apps" settings from the Google Accounts, which was essential is using Gmail to send emails from Business Central. However, to replace that we have "App Passwords" which we can use instead. Also, just something to keep in mind, Google is going to remove this from the "Google Workspace" accounts as well by Sept, 2024 so it would be wise for you to migrate your configurations to use app passwords. Reference 1.  How to Setup Email in Business Central 2.  Google Support - Less sec...
Read more