DataMonitoring

What is the project?

A project made to check if some databases in Oracle are being updated corretly. This project was developed using the following technology:

• Oracle SQL Developer (Ver: 23.1.1.345);
• SQL;
• Power BI (Ver: 2.135.7627.0 64-bit);

Sumary

The Data Monitoring project was developed to check if the data base is being updade corretly, it also provides the data volume of each update and check the date/hour when the update happened.
All Data Modeling was made using SQL Language, including the table creation and it's structure, and also the procedure routine. The Power BI is only used to create a report about the Data base update status.

Note

It's only possible to implement this tool if there is a Data Base Scheduler working togheter. In this was used the Oracle Data Integrator (ODI) .

Data Monitoring Flow

It's the flow of information into de process of Data Monitoring. It covers also the whole process of creation of data and what information is uploaded at report in Power BI.