Data Integration, just plug in and charge.


I am sure you have been in this situation because most of us have. The vacation is planned to a country far away. Months you are looking forward to his moment it and finally the moment is there. You step into the plane and travel to new countries. All these hours in the plane depend on heavily use of your electronic devices. You listen to music, play games, watch movies and after all these hours you are finally on your destination. All your devices are low on battery and it is time to find the electric outlet to charge them. Preferably in the hotel you are staying. When you walk up to the electric outlet point with your plug then you see it… It is not the same.

Europe, US, UK and some other countries have different electric outlets. When we create the parallel between these electric outlets and data we see a lot of agreements. There is only one way to overcome your “power debacle”. Buy or make a solution to integrate different plugs and outlets. For electric outlets there is already a so called universal plug. My advice (based on experience) is to buy one and keep it in your suitcase!

Data integration is often seen as a plug. Just plug in the data from one system to another and it works. This would be amazing but it is not the way it works in real life. If you just have to go from one source to another, what is not really common these days, then data integration is just connecting the dots. Data integration on multi-level and from different sources (even outside of the company) asks a whole new perspective and technique. Logical combinations are often made by human hands but mapping and centralize this data is a technical item. Software to help you with this exercise is therefore the logical choice. Different solutions give you the opportunity to collect the data from multiple software applications or sources in different areas of expertise. However do qualify your needs for data usability. What would you like to accomplish?

The technical explanation of Data integration by Techopedia

Data integration is a process in which heterogeneous data is retrieved and combined as an incorporated form and structure. Data integration allows different data types (such as data sets, documents and tables) to be merged by users, organizations and applications, for use as personal or business processes and/or functions

Organizations like SAS and TWDI concluded via research that there are 3 three different species within the  environment:

Analytic data integration

If one or more data integration techniques is applied in the context of business intelligence or data warehousing.

Operational data integration

Involves the access and integration of data among operational applications and databases, whether within one organization or across multiple ones.

Hybrid data integration

This falls in the middle ground between the first one and the second one. Hybrid data integration includes master data management and similar practices like customer data integration and product information management.

As you can see buying your company a “universal plug” isn’t going to do it. You need to transform your data organization and let everybody cooperate to one “golden record” or “single version of the truth”. Lose the data silo mindset within your company and create collaborative data integration. Get smarter!