In the evolving landscape of global data management, the demand for near-real-time data processing is pushing the boundaries between traditional Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems. In the first part of this series, we established a foundational architecture using Kafka to meet specific customer requirements for data immediacy. Now, we advance…
Read MoreAnalytics Blogs
Customer Use Case: Near real-time processing
Nowadays, more and more companies require real-time data processing. There are many software vendors on the market offering real-time platforms and streaming solutions. But what can be done when classic OLAP (Online Analytical Processing) need to be processed in real time? For example, consider the following SQL query: select dept.name as dept_name, emp.name as emp_name…
Read MoreHandling Hard Deletes from the Source System
Dealing with data can feel like walking a tightrope—maintaining accuracy and consistency while avoiding unnecessary losses is a challenge every organization faces. When working with real-time data systems, the way you handle deleted data often determines the integrity and usability of your datasets. This post dives deep into hard and soft deletes, the challenges of…
Read MoreSQL Security Audit Logs in Azure Log Analytics Workspace
In today’s digital landscape, safeguarding data and maintaining regulatory compliance are paramount. Azure SQL Database stands out as a robust solution, with its comprehensive logging capabilities playing a crucial role. At the forefront are its Audit Logs—indispensable tools that not only ensure adherence to regulatory standards but also act as vigilant sentinels against potential security…
Read MoreConnecting to Oracle Database (Cloud) and Oracle EBS in Power BI Desktop
Integrating your Oracle Cloud Database and Oracle E-Business Suite with Microsoft Power BI can be a daunting task, especially when dealing with complex data structures and security protocols. However, this connection is crucial for Database Administrators and IT Professionals looking to leverage the powerful analytics and visualization capabilities of Power BI. In this comprehensive how-to…
Read MoreHow to handle blank visuals in Microsoft Power BI
Microsoft Power BI is a powerful data visualization tool, used to make coherent and structured visuals out of your company’s data. Apps Associates Data & Analytics practice specializes in using this tool to make our customers’ data work for them. We work collaboratively with our customers to create the best solution for their data visualization…
Read MoreImplementing As-of-Date and Combining Two Data Slicers in Power BI
In a recently concluded project involving migration of Oracle Business Intelligence Enterprise Edition (OBIEE) reports to Power BI, the Apps Associates team faced the challenge of dynamically selecting dates through a slicer. OBIEE has functionality which can dynamically display or show dates, whereas Power BI does not have this feature readily available. This blog will…
Read MoreHow to connect Amazon Redshift to Oracle
Part 3 of 3 in the series How to Develop Analytics Leveraging Data in Multiple Cloud Platforms This is part three of a three-part blog series describing how to develop analytics leveraging data in multiple cloud platforms. In part one, we covered the basis of multi-cloud analytics structure and how to use Oracle Analytics Cloud…
Read MoreConnectivity & Security Setup in a Multi-Cloud Environment
Part 2 of 3 in the series How to Develop Analytics Leveraging Data in Multiple Cloud Platforms In part 1 of this series about how to develop analytics leveraging data in multiple Cloud platforms I showed how to use Oracle Analytics Cloud (OAC) to connect to Amazon Redshift and Oracle Autonomous Data Warehouse (ADW) to…
Read MoreHow to Develop Analytics Leveraging Data in Multiple Cloud Platforms
Part – 1: Data Model with Sample Analysis Multi-cloud is a strategy where an organization leverages two or more cloud computing platforms to perform various tasks. A multi-cloud strategy allows stakeholders to pick and choose the specific solutions that work best for their organization. Organizations that do not want to depend on a single cloud…
Read More