Purge ODI Logs through Database

May 29, 2020

Business Inteligence Data Integration

Read in 3 minutes

If you generate a lot of logs in ODI, purging through ODI built-in mechanism can be very slow. A lot faster to do it through Database, but you have to respect foreign keys. Here is a sample plsql script to do so.

Here is a simple script with one parameter which is the number of days of log you want to keep, it will there retrieve session number and delete in the logs table following the dependencies.


Related articles

September 28, 2022

Read in minutes

Power BI and QlikView Comparison

When we talk about Business Intelligence and Data Visualization, there are 3 leaders on the market today; Power BI, Qlik (Qlikview & Qliksense) and Tableau....

September 15, 2022

Read in minutes

PowerBI CICD with Azure DevOps (Setting up the tenant) (2/3)

Previous post Introduction & Implementation Now, we need to enable the service to use PowerBI API Grant access to workspace Now, we need to add the service ...

September 14, 2022

Read in minutes

PowerBI CICD with Azure DevOps (Introduction & Implementation) (1/3)

Introduction The purpose of this document is to explain how to implement PowerBI CICD in Azure DevOps. This document is for those who are tired of publishing re...