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.
- Omnichannel ExperienceCreate seamless customer experiences
- Device IndependencePOS agnostic to form factor or operating system
- Self-CheckoutDo more with fewer associates
- Mobile StoreLeverage POS from anywhere
- POS on the GoEnable associates to sell outside of the store
- Unified PromotionsStreamline and simplify promotion workflows
- CX ConnectAllow customers to engage with POS during checkout
- Composable CommerceCreate the store experience you want
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
-
Data Replication
- Multi-tier DistributionReplicate thousands of remote locations
- Cloud Database ReplicationCapture live changes from on-premise to the cloud
- High Availability and Load BalancingEnsure 24/7 access to data and scale efficiently with demand
- Analytics and ReportingCapture the whole picture with real-time reporting
- Multi-masterMaintain consistency of data in a peer to peer setup
- Data WarehouseReplicate live and historical data to a warehouse
- MigrationsConduct live data migration with no downtime
-
-
Data Integration
- Master Data ManagementChanges propagate across the entire system, allowing you to maintain a centralized view of all parts of your core business entities.
- Application IntegrationReduce dependencies, complexity, and risk to build a high-performance, data-driven application.
- Web ServicesIntegrate multiple systems using web services or build a business application using a service-oriented architecture.
- Data WarehouseIntegrate disparate data from multiple systems so you can transform data for better business intelligence and reporting.
- Data MigrationConduct live data migration during critical server replacements, storage upgrades, and data center relocations—with no downtime.
- ImplementationIntegration consultants help design, develop, and deploy an implementation of our products.
- DevelopmentThe product developers can add features, enhance existing functionality or build support for new platforms.
- TrainingEngage our experienced training resources to gain in-house knowledge and expertise on Jumpmind products.
- SupportLeverage product engineers to resolve issues, fix defects and provide updates or patches.
- Proof of ConceptDetermine the feasibility of implementing our products and get answers to your questions quickly.
Recent Posts
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 …
View all Blog Posts
Recent Posts
There is no excerpt because this is a protected post.
Mobile replication with Android edge devices in near real time to an on-premise or cloud …
DB2 for IBM i journal replication captures only the changes as they occur on the …
View all Blog Posts
Recent Posts
The trusted specialty retailer of nutritional products will implement Jumpmind’s solutions across nearly 700 stores …
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 …
View all Blog Posts
Retail Products
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
Retail Use Cases
Retail Services
Data Products
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
Data Use Cases
-
Data Replication
-
-
Data Integration
Data Services
About
Blog Topics
-
Retail Retail trends, technology, and enhancing the customer experience
-
Data Thoughts on data matters, dialects, performance, and security
-
Case Studies How Jumpmind impacts the businesses of our clients
-
Videos & Webinars Watch on demand demos, reviews, and tours of our products
-
Company News Get the scoop on Jumpmind's growth and impact
View all Blog Posts
Replicate DB2 for IBM i with Journal-Based Change Capture
DB2 for IBM i journal replication captures only the changes as they occur on the database and sends them to all targets using the SymmetricDS tool. Journal-based change capture creates less impact on the source database while still achieving a reliable replication use case.
Popular Use Cases
- Cross Platform – Move data to a relational database such as Postgres, SQL Server, Oracle, MySQL and more.
- Data Warehouse – Setup a new data warehouse or data lake in the cloud.
- Analytics – Move data to one of the many cloud based platforms dedicated to analytics and reporting.
DB2 for IBM i Journal Setup
If you do not already have journaling setup for your application tables this will need to be done prior to replication. See the SymmetricDS documentation for details.
DB2 for IBM i SymmetricDS Documentation
DB2 for IBM i Journal Permissions
Grant USE authority to the journal and to all requested journal receivers.
Setup journal table images with the IMAGES(*BOTH) so that updates will contain old and new data. Without this changes to primary keys will not be replicated because the old ID is not provided in the journal and no update will be performed.
SymmetricDS Setup to Replicate DB2 for IBM i
In order to capture changes in DB2 for IBM i, setup a SymmetricDS node as a source with the following values. Changes will need to be made to provide your proper credentials such as hostname, database name, user, and password.
After connecting to the DB2 for IBM i database, provide the journal name that contains the changes as well as the library this journal is located.
Connect a target database after completing the connection setup for the DB2 for IBM i source database. Next, select tables for replication using the add table wizard. Finally, perform an initial load to send the existing data from the DB2 for IBM i to the target systems.
For more details on setting up the target node and tables to replicate watch this introductory video: Setting up your first sync scenario
Related Posts
Batch Screen Improvements in SymmetricDS 3.9
Routing CSV Files to Tables
Setting Up Time Based Replication With SymmetricDS