data integration

  • Bridging Databases with Different Dependencies

    Bridge data between databases with data synchronization by using channels to re-order data when the dependencies in each database are different. Each application can model its data differently, so a parent row in one database might map to a child row in another one. Instead of using data transformation to lookup and add dependent data, the order of captured data can be changed to match the constraints of the target database.

  • Creating Custom Metl Components

    Metl includes a prepackaged component library for everyday use but some users may require unique functionality. This can easily be achieved with custom components. In this article I will walk through the steps required to create your own custom Metl component

  • Data Normalization using Transformations

    When integrating data from one database to another, sometimes the schemas are not the same. JumpMind has come across a number of projects where there was a need to transform a very denormalized database into more of a canonical or normal form.

  • Designing Your Synchronization Scenario

    Over the last several years, we've designed, implemented, tested and supported hundreds of synchronization scenarios. We've recently updated our design document templates that we use to get projects started the right way.

  • Publishing Messages from Data Synchronization

    More and more JumpMind is enhancing SymmetricDS with new data integration features that leverage SymmetricDS’s Change Data Capture capabilities for replication, synchronization, and transformation of data from one system to another. In this article, we will cover how to use the data replication server to map data into a JMS message destination, which could be part of an enterprise strategy for SOA Data Integration and Messaging.

  • Quick Start Guide to Using Metl

    Are you looking for a simple, web-based integration platform that allows for several different styles of data integration including messaging, file based Extract/Transform/Load (ETL), and remote procedure invocation via Web Services that is easy to use and quick to setup?

    In this blog I'm going to walk through the steps to install and run your first flow in Metl in a Windows environment.

  • When Should You Use Real-Time Data Integration?

    Real-time data integration is being increasingly used by companies to improve their business and better serve their customers. Traditional batch systems are being converted to real-time systems that process transactions as they occur. The advantages include improved knowledge of how business is performing and offering services that outperform competitors. An architecture with real-time information and on-demand processing can have a huge payback for certain business scenarios.