A bit of a departure from our normal tech suggestions, but for any Jira Service Management admins. I was trying to work out a way of reporting ticket churn – tickets open at the start of a period, new tickets opened during period, tickets closed during period, tickets remaining open at

If you're familiar with developing reports using the Oracle Analytics Publisher product, you are likely to have used the Analytics Publisher Desktop for Microsoft Office. It is a plug-in that appears as an option in the ribbon of the client-based MS Word and Excel. The plug-in provides a

Python's NetworkX library offers a simple yet powerful entry point into the world of network graph construction and analysis. Let us build a directional graph with three types of nodes, similar to entities in a relational database: * Author, * Book, * Reader. import networkx as nx G = nx.DiGraph() authors

When you have a front end built on APIs, but aren’t familiar with the API commands, you can use Wireshark to find the endpoint and body of commands being executed on the front end. For example, if you want to find out how to start a process in Oracle

A key step in the Retrieval Augmented Generation (RAG) pipeline is chunking your unstructured source data, the process of dividing a large body of information into small and manageable pieces. These chunks are the elements which will be searched through for relevance to the user query and used as the

Enhance the reach of your Oracle APEX Progressive Web App (PWA) by publishing it on the Google Play Store. Ensure your app meets PWA requirements, set up a Google Developer Account, and use PWABuilder to package your app for Android. PWABuilder simplifies converting PWAs into platform-specific apps, making them available

If you have a CSV file and quickly need to do a bit of analysis on it, you do not always have to reach for the big guns like loading it into a relational database table or using Apache Spark. The Pandas Python library allows for quick analysis without the

When connecting to a publicly available Oracle Autonomous Database (ADB) it requires a mutual transport layer (mTLS) to establish a mutual authentication between the cloud database instance and your client application, ensuring an encrypted and secure connection. This is achieved by using a shared wallet, that contains the certificate needed

When you are reverse engineering tables in Oracle ODI, especially from large systems like EBS, you can hit an issue where the reverse engineering operation is successful but the table you import has no columns. This is caused by the access you have to the source system.  If you are