Triple R IT Power, Precision and Control in Data Integration and Aggregation

Data Integration

Data integration can be described as the process of combining data of multiple systems at the same level. For example, data integration between an ERP and a CRM system could focus on synchonization of all customer information in both your CRM and ERP system.

Another example would be to integrate the data of two CRM systems, either within one organization or across organizational boundaries. This process is depicted below:

Data integration is needed in order to make systems communicate, keep data consistent and to be able to take informed business decisions.

The DataSource Integrator strives to simplify creation and maintenance of data integration projects, thereby reducing the administrative burden put on your organization's resources.

Data Aggregation

Most of the time, integrated data in isolation does not provide us with a significant meaning. By putting the data in a context, for instance via our own interpretation, we can transform meaningless data into meaningful information.

Often there is an abundance of data which cannot be interpreted in a straightforward manner. By aggregating this data, we abstract from the data level by describing properties of groups of data. This process is called data aggregation.

As an example, consider a the sales system of a B2C multinational. Each of the sales individually does not tell us the sales number per geographic region, however by splitting up the total number of sales per region and summing it up, we can get those numbers.

In the picture below, the feedback-loop that is generated by data integration and aggregation is depicted. By integrating information, knowledge about the current state of the enterprise can be gained. This knowledge can in turn be used to make business decisions (either manual or automated) which result in actions. These actions generate data that can again be integrated.

Universal data communication platform

The Data Source Integrator enables all data sources and object models from all systems within an organization and across it's borders to communicate.

We provide a fast, stable and independent platform which enables you to integrate virtually anything; data from all applications, data sources and Software as a Service (SaaS) platforms. This is done in a cost effective way not requiring any coding. It provides easy modification as business processes change. You get optimal disclosure of data from all sources within your enterprise for various purposes. Imagine all components in your IT-architecture working together in perfect harmony.

For instance connecting your email with your CRM and ERP systems! This is only possible because the Data Source Integrator integrates the data at the level of data sources of applications instead of replacing all applications with one new application (ERP systems).

The proliferation of different systems (particularly databases) based on different design standards has provided customers with many choices. This situation has provided many benefits, especially in terms of cost reduction through competition, but it also created problems.

The Data Source Integrator is an enterprise-wide solution that anticipates and meets all data integration and aggregation requirements across an organization and its boundaries.

Pre-configured objects per system

Every software application uses a specific data model. In order to simplify the management and implementation of the DataSource Integrator it provides you with default objects. These objects can be customers, invoices, etc. This prevents you from having to re-invent the wheel.

We provide the DataSource Integrator with a standard package of pre-configured objects. The objects can be extended to meet your needs.

Perform operations like add, extract or convert on data sources

After a merger and acqisition a complex IT-landscape emerges containing at lot of different IT systems. At this point two or more data sources need to be merged together. All master data and transactional data needs to be added to the leading system.

If a part of an enterprise is sold or has to be carved out a system split has to be conducted in a short time. An extraction needs te be make from the current system, after the split both systems need to coexist and operate independently.

When an entire IT system needs to be replaced by another it is necessary to convert all data inside the existing system. Whereby all of the data in the old data model and format needs to be translated into to new datamodel and format.

Triple R IT provides you with the tool to perform all these operations.

Easy implementation

Traditional implementations of new IT architecture components require large scale projects. For the implmentation of the DataSource Integrator no big changes to the IT architecture are necessary. It utilizes existing applications and systems as they are. The employees continue to carry out their daily routines as they are used to, but in a more effective and efficient way.

During the installation of the DataSource Integrator no programming is required, only configuration steps are necessary. Moreover training will be provided for at different levels, with a certification program.

The information on data integration and aggregation processes are easily obtained and modified by means of a user friendly interface.

Provenance: keep track of the mutations of every object

Provenance monitors the movement of every data object in the DataSource Integrator and which functions were applied to the specific data object. It creates a log containing the complete history of all activities of the DSI.

It is not possible to rewrite the history, integrity is provided. In the authorization model it is possible to determine who can look into the history, this can be done on different levels, confidentiality is guaranteed.