Application and Data Integration


From our perspective; software, networks and computers are simply conduits for information and communication. If your business systems are not capturing, filtering, collating and delivering relevant information to the right people in a timely manner there is work to be done. Data integration is the combination of technical and business processes used to aggregate data from different sources into meaningful and valuable information.

In an ideal world, organisations would have a single source of truth data or information store that was managed by people who knew the data best, and accesses by those that need it most. The reality is that very few businesses ever reach that point. It is however true that those that do will have a strategic advantage over those that do not. Knowledge is power as they say.

In the 1990’s there was an adage circulating around that if an application has a database, it could integrate with another. Easier said than done and to date very few organisations with multiple databases have true integration.

There are several different types of integration (in computing). We won’t go into detail here as there is quite a lot to consider. The following URL will take you to an excellent site where it is explained for you.

What might not be obvious, is the importance of making the effort to best integrate your different systems. There is no magic involved, it is not high science either. It is a process that business should go through to ensure they are extracting the best value from their ICT spend. We are experts in these types of projects and a no obligation discussion is available when ever you are ready.

On Premise Applications and Databases

Should you have all of your business applications installed on servers in your own data centre or server room and simply want to get some data or information from one application or database into another, that is, where practical, a fairly easy process. There may be cases where applications are not able to out-of-the-box share data, and we will advise you if this is the case and make a recommendation for a work around.

Cloud Applications and Databases

A common challenge many organisations have found themselves in today is this: They selected Best of Breed cloud based application(s) on a lower capital expenditure and lower overheads model and did not engage with a suitable qualified Solution Architect and now have disparate data sources and the problems that come with it.

Our strength in the relevant technical and business process fields makes us an ideal partner for you (and your IT team or solution partner) to get the most practical and appropriate level of integration between your cloud systems operational. We have our own proprietary integration stack (SaaS/IaaS) in situations where this is the most practical option.

Hybrid Integration scenarios

Another common scenario with many organisations is an uncomfortable mixture of in-house and Cloud applications and data. This poses additional challenges in the respect that the two systems are residing in different environments, sometime geographically remote, usually managed by a third party, challenges enough to cause issues such as:

• privacy issues (geo / jurisdiction) • network lag • time zone challenges • security • failover • data integrity

As mentioned in the previous service statement we have a proprietary integration stack that can be utilised where practical. We can arrange and manage any additional connectivity that might be required. Data quality testing and security monitoring is available with any service agreements. This way you can get the most out of your cloud strategy by further outsourcing the risk and technical challenges to people who live and breathe it.