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

JSON files are prevalent in the IT industry, commonly used in web service API data exchange. Python offers a streamlined alternative to manual analysis or database importation, often proving as efficient and concise as SQL queries. Let us have a look at an example of a JSON file that consists

Creating a stack in OCI will also create a range of underlying resources needed to support the stack. If you no longer require the stack it's important that you clean up all of the associated resources as well as deleting the stack. Deleting unused resources can save you

Data type hints in Python, introduced in PEP 484 and enhanced in subsequent PEPs, provide a way to specify the expected types of variables, function parameters, and return values. While Python remains dynamically typed, type hints allow developers to add optional static typing to their code for documentation, readability, and

To create a user group, dynamic group, and policies required to use the data science service you can take advantage of a pre-built Oracle template. To use the template, from within the OCI console navigate to Developer Services → Resource Manager. Next, select the compartment you wish your data science work

In 2023, we started sharing weekly tips to develop your skills across areas including analytics, data and technology. Make sure you follow our LinkedIn page so you never miss a Tip Tuesday. Tip 1 | How to prepare data for analysis? Preparing the data is one of the most important stages

Navigate to ATP or ADW in OCI console → Database Actions -> Database Users. (You need to be an admin user to create or change users). You will be prompted to log into Oracle Database Actions, from there navigate to Database Users. From here you will be able to create