Returns are one of the most common problems faced by retailers. Returns management software can …
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.
Returns are one of the most common problems faced by retailers. Returns management software can …
All sales start with a search. A retailer can do everything right – offering attractive …
In this blazing-fast DevOps world, pushing Point of Sale software updates out to devices in …
With NoSQL databases popping up all over the place, there seems to be a database …
The timestamp data type can cause compatibility issues for cross-platform data replication because database …
When looking into the different types of data storage options in today’s market, one type …
Jumpmind Partners with American Eagle Outfitters to Launch POS of the Future Columbus, Ohio – …
Jumpmind, a leading retail commerce provider, announces the availability of Jumpmind Commerce 4.0 with in-store …
We are thrilled to announce the addition of Clifford Perlman to our leadership team as …
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.
The new release of SymmetricDS 2.4 will help you:
A table on the source database can be mapped to a table on the target database even if they have different names and they are located in different schemas. Using the web console, the user can specify each column from the source table that replicates to a column on the target table. Since only the specified columns are replicated, this also makes vertical data filtering easy.
A new set of powerful transformation features make it easier to transform, merge, and supplement tables during replication. Transformation can be performed with access to the source database during the extraction phase, or during the loading phase with access to the target database. The web console makes mapping tables and specifying transformations as easy as point and click. Add new columns with constant values or variables, or provide a SQL query to lookup values from another table. Multiple source tables can be merged to synchronize a consolidated target table. Or transform a single row from the source database into multiple rows on the target database. Specify different mappings based on whether the change is insert, update, or delete. If the built-in transformations don’t meet your needs, then paste in a Beanshell script that can transform the data however you need.
While large object replication of binary (BLOB) and character (CLOB) data has been possible in the past, this release includes stream oriented handling of data. Normally, the change data capture system records the LOB to the sym_data table. Each database system has a limit on the amount of data that can be captured for each row. Now the user can enabled the “Use Streaming LOB” option to skip the data capture and stream the LOB from the database instead. This makes it possible to replicate much larger objects than were previously supported.