Josh Hicks

Josh has worked in the IT industry for over 15 years as a developer, tech lead, and architect. 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.

Often when setting up data replication it is necessary to redirect or transform the source tables and columns into a different set of target tables and columns.   SymmetricDS offers this transformation feature as part of the real time data replication workflow.   Below we will review the places within the workflow this transformation can take place and how to configure it.

Read more SymmetricDS Transformation Pipeline

There are several different ways replication can be paused in SymmetricDS to fulfill different use cases.  This blog will identify the differences between the various approaches so that you can make the best decision for your use case

Read more Pausing Replication In SymmetricDS

Setting up SymmetricDS for clustering can be done a few different ways and can help solve a few different use cases.   This blog will address a few of the common setups we see while utilizing clustering.

Read more Clustering SymmetricDS

Data has become an ever increasing crutch in our daily lives and drives more and more business decisions than ever. With the steady increase in data storage technologies consumers are faced with greater challenges to keep the data synchronized for accurate reporting, analysis, and overall processing. Traditional databases such as SQL Server, Oracle, Postgres, and MySQL still play a major role in many companies. However with the rise of the cloud platforms and NoSQL technologies commonly used for warehousing and analytics the need to support a variety of technologies within each business is important.

Read more MSQL Server Replication vs SymmetricDS

Subsetting data during replication can improve the overall performance of your sync scenario and reduce the size of target databases.   This article will explain some of the ways SymmetricDS will allow you to subset your data and how to consider the performance implications with each case.

Read more Subsetting Data During Replication

SymmetricDS was originally designed to support a use case with numerous client nodes spread out geographically in order to replicate to a centralized server.  The out of the box properties and configuration are optimized to support many other use cases and may not be sufficient when you need more than a couple dozen client nodes.   Check out some of the helpful hints below to assist in a successful synchronization rollout to numerous clients.

Read more Scaling SymmetricDS For Many Clients

SymmetricDS now supports loading data and changes into Snowflake.   Capture changes in your relational database and sync them in near real-time into a Snowflake cloud data warehouse.

Read more Data replication into Snowflake