Configuring Data Replication Using Data Director and Scheduled Jobs in LS

-

Introduction

In this blog, we will be seeing Scheduled Job configuration for Data Replication using Data Director.
Scheduled Jobs comprise of two parts: the Job Header and Sub-jobs.

In the Job Header, we define different parameters for the Jobs like, Error Handling methodology, To and From Locations, Compression Types, Scheduling details and the sub-jobs.

In the Sub Jobs, we define where to get the schemas of the table, the tables to replicate, methods of replication, filters on the data to be replicated, linked tables, etc.

Pre-requisites

  • Microsoft Dynamics 365 Business Central
  • LS Central

References

Configuration

General

Job ID :- A unique Identifier for this Scheduled Job.

Scheduler Job Type Code:- It is a kind of category for this Job, we can use this category as a filter when we configure NAS Services.

Subjobs Defined By Job:- Specifies where system is supposed to fetch sub-jobs from for this Job. Generally it is the same as “Job ID” but LS allows you to create a job with its sub-jobs defined in another job.

Location Settings


In this tab, we specify where the Data is supposed to come from and where the data is supposed to go. 

There are multiple ways to configure this,From Multiple Locations to Single LocationSet the “From Dist. Restrictions to “Include List”.

Click on Navigate -> Jobs -> Sender Location List.

Add all the locations that you want to pull the data from.

Set “Distribution Restrictions” to “Single Location”

Set the Location in “To-Location Code” field.

From Single Location to Multiple Locations - This is the similar to the previous one simply reversing where we set the values.Set “From Dist. Restrictions” to Single Location and set the location.

Set “Distribution Sublocations” to “Included in Replic.”, this field is used to specify whether Data should be sent to sublocations(POS Terminals) or not.

Set “Distribution Restrictions” to “Include List” and Go to Navigate > Jobs > “Receiver Locations Include/Exclude.”

Add all the locations you want to send the Data to.

From Multiple Locations to Multiple Locations - Simply set Include List on both sides and add all the locations that the data is supposed to come from and where it is supposed to go.

Schedule Details

Here we specify how often this Job is supposed to run.

You can schedule the Job to run every day, hour, minute or second as per your needs.

In the above example, I have scheduled the Job to run every 15 minutes, every day.

Do note that you need to have NAS Services configured for the jobs to run automatically.

Data Replication



Here we have to define the “Subjobs”, which are in essence, tables which are to be replicated.

Conclusion

Thus, we saw how to create a Scheduled Job Header, there are a lot more things that can be done with this like, using different codeunits for Data Replication, Object Replication Or simply running Codeunits for automating tasks.

You can find the second part here.

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