Data Hub - Business Intelligence architecture in real-time mode with the DBPLUS Data Replicator software

Data Hub – Business Intelligence architecture in real-time mode with the DBPLUS Data Replicator software

Initial situation
Automotive spare parts market leader in CEE region operating in 17 European countries, decided to implement a central reporting system project. One of the key distribution system dedicated to serving the entire organizationand a network of business partners.

Business needs and expectations

Providing up-to-date information on current sales, stock levels and other business data (customer data,delivery addresses, etc.).
Data available centrally, updated in real time.

Problem to solve

Delay in reporting key business factors, such as sales value or stock levels (data update every 24 hours).
Lack of consistency of reports from individual markets.
Limited ability to introduce changes in reports – operations required arrangements with all local IT departments.

Solution architecture

Data processed at night, in each of 16 local databases.
Transferring the data extract to the central location.
Each of the markets is supported by the locally hosted ERP system.

Solution

Central Data Hub powered by real-time business data replication system DBPLUS Data Replicator from local databases.

Benefits

Key business data from each market (sales, inventory, CRM contacts) are available in real time.
The ability to perform reports at any time.
Access to online stock levels has enabled the customer to offer new services and improved the optimisation of the supply chain (products can also be delivered from warehouses in other countries).
No need for daily, overnight data processing, which significantly relieved the work of IT departments.

Architecture

DBPLUS Data Replicator replicates data from each local, national ERP system to a central Data Hub with a maximum delay of 1.5 sec.
The ERP system used by the customer is Microsoft Navision based on Microsoft® SQL Server
Data Hub uses the Oracle® database engine.

Artur Boguszewski

Software Architect

Slash Your Cloud Database Bills: Proven Cost Optimization Tactics

Every silver lining has a cloud database, and in this case, it’s the bills that thunder down post-deployment. Indeed, 61% of enterprises chant the mantra of cost optimization, though the costs of cloud computing often spiral higher than expected.

What exactly is cloud database cost optimization? It’s our sherpa guiding us through the financial fog, ensuring we’re not pouring funds into the cloud abyss unnecessarily. It’s about fine-tuning our resources, so we pay only for the computing muscle we flex, ensuring our cloud ventures are both lean and mighty.

What’s New in DBPLUS Performance Monitor 2024.3

In the latest update of DBPLUS PERFORMANCE MONITOR, version 2024.3, we’re rolling out exciting enhancements and brand-new features. All are designed to elevate your database monitoring and management capabilities to the next level.

From real-time online monitoring improvements to smarter notification systems, we’re excited to walk you through what’s new, what’s better, and how these changes can make a big difference in managing your databases.

ORA-00600 Exposed: Understanding and Resolving Oracle’s Internal Error Code

The ORA-00600 error presents itself as a catch-all for a variety of unforeseen conditions that the Oracle database software cannot process normally. While not quite the apocalyptic “kiss of death,” it is certainly viewed with a mix of dread and resignation. It is Oracle’s not-so-subtle way of throwing up its digital hands and admitting that something has gone awry. And that something, wasn’t a thing that Oracle had every anticipated.

It could be said that encountering an ORA-00600 is a bit like hearing ominous rumbles from your car’s engine right after you’ve bragged about its reliability.

03/09/2021