Configuring Data Director Part 2

Introduction

In the last part, we saw how to install Data Director, configure Network connections and modify Host file.

In this part, we will see the SQL Server and Business Central side of configurations and how to test if everything is configured properly.

Pre-requisites

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

References

Data Director User Guide

Configuration

SQL Server

  • Set the Authentication Mode for the Server Instance to “SQL Server and Windows Authentication.”

Image

  • Go to your Server Instance and create a new Login.

Image

  • Make sure to set the User Mapping to your database.

Image

  • Go to your Database and create a new User.

Image

Image

  • Make sure to set the “Membership” to “db_owner”

Image

  • To confirm if the SQL User has been configured properly,

Image

  • Set the Authentication Mode to SQL and try to login with the newly created User.

Image

  • If you are able to login successfully, then we move to the next part.

Distribution Location

  • Set the “Data Director Mode” to TCP and the “Distribution Server” to point to the current system. It is advisable to set this value as the IP of the current system or the host-name if you have defined it in the hosts file.

Image

  • Then set the “Distribution Server URL” in the following pattern https:///DDWebservice. Set the User ID and password of that system in the “Distribution Server User ID” and “Distribution Server Password” field.

Image

  • Then set the values in the “Replication” tab as follows:
    • Company Name: Name of the Company
    • User ID: UserID of the SQL User we created previously.
    • Password: Password of the SQL user we created previously.
    • Db. Server Name: The server name and server instance in the <SERVER-INSTANCE> format.
    • Db. Path & Name: Name of the SQL Database
    • Version: The version of the SQL Server you are using.
    • Net Type: Set it as “tcp”

Image

  • To check if this has been configured properly, click on “Test Connection” on the top left and a success message should pop-out.

Image

  • Do the same configuration for both Head Office and Stores, make sure the modify the Distribution Locations accordingly.

  • Now, search for “Scheduled Jobs” in BC, let say “Items” for instance, and make the following changes:

Image

  • Now, click on “Run Now” at the top left, you should get some message.

  • Open “Job Monitor” to confirm if the job has run successfully.

Image

Conclusion

Thus, we saw how to configure Data Director and test if everything is configured properly.

Happy Coding!