Last year, holiday sales topped $1 trillion for the first time, up 4.1%, according to …
![]()
Cloud-native POS platform for seamless omnichannel customer experience.
![]()
A single hub for all promotions campaigns.
A comprehensive solution designed to simplify and give you ownership of the inventory lifecycle.
A native post-transaction reconciliation module built into Jumpmind Commerce.
![]()
The most advanced synchronization solution for databases and file systems.
![]()
Data configuration and batch automation across different disparate systems and vendors.
Last year, holiday sales topped $1 trillion for the first time, up 4.1%, according to …
The store is becoming a relationship, not just a transaction The store is being talked …
I spent this week at eTail Boston, and if you looked at the agenda, you’d …
SymmetricDS’s most common deployment pattern: one central database syncing with thousands of edges, using composite keys and routers to prevent collisions and control data flow.
Learn how to replicate each tenant database in a central SQL Server to its own edge database with SymmetricDS. One routing rule and a matching external ID keep tenants isolated.
Quick answer: Agentic AI systems need data that is current, consistent across systems, available even …
Short answer: Alpha Ori Technologies is a maritime ERP provider that became part of …
Introduction In retail, POS updates have traditionally been quarterly events at best. From October through …
Jumpmind Powers Point of Sale and Promotions Execution for Landmark Retail, One of the Largest …
We built 3.18 because the question we kept hearing from customers changed. It used to …
The offering gives security teams a practical path to risk management and accountable AI COLUMBUS …
The insights have implications for retail technology in the store: it must help mind information …
![]()
Cloud-native POS platform for seamless omnichannel customer experience.
![]()
A single hub for all promotions campaigns.
A comprehensive solution designed to simplify and give you ownership of the inventory lifecycle.
A native post-transaction reconciliation module built into Jumpmind Commerce.
![]()
The most advanced synchronization solution for databases and file systems.
![]()
Data configuration and batch automation across different disparate systems and vendors.
A retailer chooses SymmetricDS to synchronize Oracle POS MySQL store database with central office DB2 database.

Urban Outfitters chose to refresh their Oracle POS (ORPOS) based store infrastructure, moving from a mostly IBM based store stack to an open source based store stack. SymmetricDS was chosen to replace an MQ Series solution as the data delivery mechanism to anchor the new store infrastructure.
The challenge was to deliver to the retailer a proven data movement solution that could deliver the massive number of master item and pricing data to multiple brands in a timely manner, and also trickle sales back to the central office throughout the day. The solution also needed to decrypt and re-encrypt sensitive data as it hit the safe harbor of the central office as well as map several simple data elements to new values for back-end systems.
Another requirement also existed to deliver a subset of the central office sale and item data to another centralized MySQL database which was a data source for a custom web application used by the POS.
Having implemented synchronization for ORPOS in the past, JumpMind quickly setup a standard synchronization profile between the MySQL store server and the DB2 central office database. SymmetricDS was used to capture and trickle back sales and electronic journal data. It was also used to move item, price, tax and hierarchy data to the store database. The master item table was routed using the lookup table routing feature of SymmetricDS. The routing leveraged a table that mapped store to brand. Re-encryption of sensitive data was accomplished using a bean shell script column data filter at the central office SymmetricDS instance. Simple data mappings were also accomplished using the same mechanism.
Not only was SymmetricDS used move data between the store and the central office, but it was also used to move data to the second centralized datasource. In order to do this, a third node group was created. As data trickled into the central office, the required data for the secondary data source was captured and routed to the additional node group.
SymmetricDS allowed the retailer to have a resilient and consistent mechanism for moving business critical data both to and from their stores. SymmetricDS provided an affordable alternative to better known, but more expensive messaging alternatives which required more software to execute at the store itself.