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

Trade and Industry

Businesses have at least information on: customers, products, suppliers and internal processes (ERP). This results in multiple databases in several systems, which are usually hardly or badly integrated. This may result in operational problem which have to be remedied manually. With the Data Source Integrator it is possible to integrate and aggregate the data sources of different databases in order to improve business processes internally and externally.

Mergers and Acquisitions

Two organizations which merge will typically create an entity with duplicate master data (since each likely had at least one master database of its own prior to the merger). Ideally, database administrators resolve this problem through de-duplication of the master data as part of the merger. In practice, however, reconciling several master data systems can present difficulties because of the dependencies that existing applications have on the master databases. As a result, more often than not the two systems do not fully merge, but remain separate, with a special reconciliation process defined that ensures consistency between the data stored in the two systems. Over time, however, as further mergers and acquisitions occur, the problem multiplies, more and more master databases appear, and data-reconciliation processes become extremely complex, and consequently unmanageable and unreliable. The Data Source Integrator is equipped to match various systems, either by synchronization or conversion.

Healthcare

Historically IT in healthcare was focused on administrative processes. Next patient oriented systems were developed. Nowadays there is more and more emphasis on accountability for healthcare professionals. This calls for integration of data sources in the systems surrounding healthcare.

E-business

Selling a product via a web shop requires access to multiple systems to recognize a customer, order handling and invoicing. Recognizing a customer, order registration and invoicing is handled by an ERP system, whereas order confirmation and shipping of the product is mostly done in a storehouse (with a Microsoft SQL Server). One request has to run through both systems, and afterwards both need to be updated. Custom made software for an application like this is very costly and the Data Source Integrator is a good solution.