Handling integration errors

As we mentioned at the very beginning of our blog series, all integration problems essentially fall into two large categories: the problems that have to do with the technical mechanics of integration and the problems that concern the correct application of business rules. There are, however, certain types of problems that originate in both. In this article, which is closing …

Data Integration Best Practices - Data transformation

So far, we have addressed only the problems that concern the pure technical mechanics of integration. Now it’s time to review the challenges that are related to the correct application of business rules. These are, as we stated in the first article of our blog series, typically of higher level in nature and answer the question of “What?”. And the …

Data duplication and ID linking

Let us first make it clear what ID linking is about and what it has to do with data duplication. To do that, let’s take CRM systems as an example. It is likely there are more than one person in a system who share the same first and last names. And it is inevitable that sometimes, some pieces of information …

Three mechanisms to detect data changes

In the previous article of our series Data Integration Best Practices, we defined that all problems related to data integration can be essentially broken down into two large categories: The ones that have something to do with technical mechanics and the ones that are connected to business rules. In the second article of this series, we will review one of …

Data integration best practices

The topic of data and application integration has such a wide coverage that there seemingly should be no questions left. And yet every now and then, we come across certain questions both from the IT people and the business users. So, we decided to answer the most frequently asked questions in our new blog series on data integration best practices. …