What is Data Integration?

If you search for Data Integration on the net, you will find several definitions which don't always agree, a plethora of applications that are used to try and provide Data Integration functionality (along with the company's marketing department's own definitions to make their software offerings look more complete) and maybe a few companies offering a Data Integration service (maybe that is how you found this site). One thing they all have in common is (all but this site) they are looking at the Data Integration issues of big business. Data Integration is only required when a business can afford to spend hundreds of thousands of pounds on a solution apparently. That is not true. 

So what is Data Integration? Data Integration is a combination of processes used to derive meaningful data from disparate sources and deliver it to a variety of locations. That is it. A mobile telephone company may use Data Integration techniques to process every single call made on their network and make the data usable and meaningful to several of their systems. This will be used to charge customers, to lease cell towers, to analyse outages, to calculate employee bonuses,....the list of uses is vast. Likewise, a car mechanic could use it to compile invoice data, maintain customer records, maintain car records, etc......but they are generally not seen as big enough to need it.  Rilhia Solutions Limited believe that in this newly emerging age of context, everybody (including individuals) can get more from their data. 

Anyone involved with data in big businesses will instantly be able to give numerous examples of how Data Integration is currently used and where it could be used in their specific domain. However, most small to medium sized businesses have never considered Data Integration. The following is a simple example of how Data Integration can benefit a small carpentry business.

Jenny's new Carpentry Business

Jenny has recently set up a new business and discovers some issues involved with the administration side ........

Buying software will solve all issues

We live in a age of "apps" and there is seldom any problem that there isn't an app for. Jenny tries that approach....

Time to "phone a friend"

Maybe a friend that has already been there can help Jenny solve her problem....

The Extraction Phase

Jenny listened to Tariq and decided to call in a specialist. He explained what was required, starting with extracting the data...

The Transformation Phase

On many occassions Data Integration requires that the data isn't just moved, but altered or re-shaped .....

The Loading Phase

Once data has been extracted and transformed it needs to go somewhere....

Data Integration gives you time to work

If data is handled well, it leaves time to get on with the business.....

For a more formal explanation of Data Integration take a look here.

If you have any questions about Data Integration and how it could benefit your company, please feel free to contact us.