Analyze change data capture using low-code applications

Low-code design for data-driven decision making

In a data-driven world, Business Intelligence plays a primary role for companies wishing to deeply understand their customers and make smarter strategic decisions. However, accessing and analyzing data can be complex, requiring specific technical skills and often hindering teams with limited computer knowledge. Low-code platforms offer an innovative solution to this challenge, allowing anyone, regardless of their technical skills, to extract value from their data.

Let's see some ways in which this technology can help businesses:

Enabling self-service analysis

Low-code platforms offer intuitive drag-and-drop interfaces that allow business users to independently create interactive dashboards and reports.

Accelerating time-to-insight

Predefined models and automation features simplify the creation of advanced analysis, reducing the time needed to obtain useful insights from data.

Involve the entire company

The user-friendliness of low-code allows actively involving teams in marketing, sales, customer care, and other departments in data analysis, promoting a data-driven culture.

Integration with other systems

Interacting with maps and API services, for example, is an important feature that can enrich applications with geolocated data and external information.

Reliable, High-performing and Intuitive Data Platform

A Data Platform that perfectly aligns with the customer's needs, extremely user-friendly, and at the same time well-structured from a security perspective, is achievable through Oracle technologies: Real-time data management, execution of ETL (Extract, Transform, Load) flows, and the creation of an intuitive low-code front-end is the key in order to meet all customer requirements.

We have implemented this platform to satisfy various aspects:

  • Accessibility of various platform functionalities based on specific user privileges

  • Data publication based on their properties, traceability, and quality

  • Consultation of geolocalizable datasets, interacting directly with the map of the entire globe

  • Consulting various types of data in a classic mode, through reports (including multiple and interrelated reports), with the ability to export them, always considering user privileges and the context they are working on

  • Data update notifications in the app, with the option to choose to forward them to external systems.

Picture

How are we implementing this platform?


In this case, we show a platform that reads data from source systems such as Oracle and Microsoft. Through Oracle Golden Gate, we intercept transactions on the source systems and we transfer the data to a dedicated Oracle database. Here, the data is processed by Oracle Data Integrator (ODI) flows, which process, transform and aggregate it. This integration phase not only involves processing but also includes quality controls to ensure data reliability, consistency, and cleanliness. Once successfully satisfied, the data is written to the Oracle business database, where it can be accessed by end-users for analysis, study, and consultation.

Business users can access data through an APEX interface in two main ways:

  • Direct queries: data is displayed in a tabular form

  • Interactive maps: data is displayed graphically on a map using GIS (Geographic Information System) services, making it easier to understand

Picture

Several key Oracle tools have been used to create the Data Platform:

Oracle Golden Gate (OGG) is a tool that enables change data capture between heterogeneous databases, capturing changes and allowing users to maintain consistent and up-to-date data across different environments.

Oracle Data Integrator (ODI), a data integration and ETL tool, facilitates the extraction, transformation, and loading of data through a comprehensive set of features, simplifying the data querying process.

Geographic Information System (GIS) services are a system that integrates, stores, analyzes, manages, and visualizes geospatial data, including information related to geographical locations on Earth.

In the context of the user interface, Oracle Application Express, commonly known as Apex, provides developers the ability to quickly and easily create web applications through a "low-code" approach based on the database. This tool enables efficient use of SQL, PL/SQL, JavaScript, and HTML/CSS, simplifying the development process and allowing the creation of complex applications with minimal manual coding effort.

Advantages

  1. Empower Anyone: Build reports & dashboards without coding, ideal for non-technical users

  2. Faster Insights: Pre-built tools & automation speed up complex data analysis

  3. Data-Driven Culture: Involve all teams (marketing, sales, etc.) in data analysis

  4. Seamless Integration: APEX integrates smoothly with other systems, enriching applications with external information

  5. Simplified Data Flow: Consolidate data capture, transformation, and loading with Oracle's integration tools for a streamlined flow from source to platform.