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);
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) .