Clienteling isn’t a new theory. It can be traced back hundreds of years when shopkeepers …
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
Clienteling isn’t a new theory. It can be traced back hundreds of years when shopkeepers …
BOPIS, BORIS, and Curbside Pickup offer consumers and retailers the best of both worlds. …
Automated Personalization is revolutionizing retail—Discover how a small investment can bring a big impact. Online …
Creating a replication of hundreds or even thousands of similar databases and also being able …
One of the many advantages of using SymmetricDS is that you’re able to leverage the …
Overview The cloud is here to stay and getting data there to utilize all it …
Mark Michalek, a highly accomplished professional in the retail technology space, has been promoted to …
After nearly a century in business, the legendary Canadian fashion retailer is retooling to streamline …
Columbus, OH, June 6, 2023 – The Paper Store, a leading specialty retailer offering a wide …
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
Data replication not only involves replicating changes moving forward but also the ability to load existing data between systems prior to replication being put in place. Data loading was enhanced in SymmetricDS 3.8 to bring together all the features around this process into a new data load wizard.
Why I would need to load existing data
Overview
The new data load wizard will walk users through 4 screens to properly construct a load request.
The load data wizard is located on the manage nodes screen through the “Load Data” button at the top of the table.
Selecting the source and target nodes
In this screen you can select multiple sources or multiple targets to load data between. The nodes must be part of the same node group though in order to multi-select. This achieves the same functionality that would have been performed using the “send initial load to” and “request initial load from” prior to 3.8.
Full or Partial Load and Before Actions
Next you can choose to load all tables currently configured for replication (full initial load) or you can choose to select only a subset of tables (available on next screen). At this point you also have the ability to choose an action to take before the load sends the data.
Before Actions
Partial Load Table Selection
If you selected a partial load you will see a screen to select tables next. If you selected a full load you will be taken next to the summary screen and will bypass the table selection screen. On the table selection screen you can check the tables you would like to load and you also can provide a where clause on how the source data should be gathered. This allows you to load a specific table based on last 5 days for example if you have a time stamp column to provide in the where clause. You do not need to provide the “where” keyword in this clause. You also can provide a set of variables that will be resolved.
Variables available in where clause
Summary
Finally you will see a summary screen of the load to review before it is created and queued up to process.
Josh has worked in the IT industry for over 20 years as a developer, tech lead, and sales engineer. He has worked across a variety of businesses including retail, telecommunications, education, and healthcare. When he is not developing he enjoys whatever sporting event might be taking place.