Welcome to OSQuay’s Knowledge Center.
A place to find articles, tutorials, how-tos, and more.
AI + OutSystems ODC: A New Operational Model for Modern Digital Delivery
Discover how organizations are transforming operations by integrating AI as a foundational element with OutSystems Developer Cloud. The article examines the evolution of AI Agents, their role in streamlining workflows, ensuring governance, and striking the right balance between automation and human oversight for sustainable business success.
Building Efficient External Reporting in OutSystems ODC with Power BI and JSON
This article outlines the implementation of external reporting in OutSystems Developer Cloud (ODC) using Power BI, JSON, and OneDrive. It outlines how the team addressed technical constraints without compromising application performance, utilizing automated incremental data exports to maintain accurate, lightweight, and up-to-date reports.
5 Proven Strategies to Keep Your OutSystems Apps Always-On and Future-Ready
Discover how to prevent downtime, extend app lifespan, and maintain peak performance across your OutSystems portfolio. From proactive monitoring to smart scalability planning, this article offers actionable strategies to keep your applications resilient and responsive.
Timeless Classics: Why Maintaining OutSystems Apps Beats Starting Over
Maintaining your OutSystems apps can deliver better performance, lower costs, and less disruption than a full rebuild. In this article, we explore why maintenance is often the smarter choice, when rebuilding might be necessary, and how to strike the right balance with a hybrid approach. Learn how to future-proof your applications while maximizing long-term value.
Defining Your Digital Ambition: The Key to a Successful Transformation
Defining your digital ambition is the foundation of a successful transformation. Whether optimizing existing systems, modernizing legacy infrastructure, or fully reimagining operations, a clear strategy ensures alignment between business goals, technology, and execution. Learn how to navigate digital transformation with AI, cloud, and modernization strategies while avoiding common pitfalls.
Maximizing IT Investments: Smart Strategies for a Changing Tech Landscape
Struggling with rising IT costs? Discover proven strategies to optimize investments, reduce expenses, and future-proof your business with AI-powered development, multi-platform integration, and innovative IT spending.
Are You Ready to Migrate?
Wondering if it’s time to migrate from OutSystems Traditional Web to Reactive Web? As OutSystems phases out Traditional Web, moving to Reactive is essential for scalability, performance, and future readiness. This article covers why migrating now is critical, along with the crucial steps—like adopting a domain-driven, ODC-ready architecture and leveraging automation—to ensure a smooth, successful transition for your digital factory.
Transforming Legacy Systems: The Imperative
Legacy systems can quickly hinder innovation and efficiency. Many organizations face outdated systems that drain IT budgets and hamper competitiveness. This article discusses how modernizing your legacy systems can improve data flow, reduce maintenance expenses, and enhance scalability and security.
Handling Null Values in OutSystems REST APIs: Practical Solutions and Best Practices
In this article, OutSystems developers will learn valuable strategies for managing null values in REST APIs. It offers practical solutions using the JSON Null Utils forge component to differentiate fields with values from those without. It also covers techniques for receiving and sending data, setting default values, and using auxiliary boolean fields to handle nulls. With detailed examples and configurations, you will learn to seamlessly integrate OutSystems applications with external systems.
Streamline your data: How to Integrate Google Sheets with OutSystems Applications
This article provides a step-by-step guide on integrating Google Sheets with OutSystems applications for streamlined data management. Learn how to set up your environment, retrieve data from Google Sheets, and display it on your app screens. The guide covers setting up the Google Sheets Rest API, obtaining tokens via the Google API Token helper, and configuring the Google API Service Account.
Mastering BPT in OutSystems: A Guide to Efficient Design and Scalability
This article delves into Business Process Technology (BPT) within OutSystems, focusing on designing and scaling efficient BPT flows. We explore essential strategies and tips to enhance your business processes, addressing critical aspects of BPT architecture and implementation. This piece is crafted for developers, offering practical insights and methodologies to integrate seamlessly into any OutSystems application.
Unveiling the Importance of Security Testing in OutSystems Applications
Dive into our insightful article that emphasizes the crucial role of security testing in applications, especially those developed using OutSystems. We explore the essentiality of prioritizing these tests in an environment rife with ever-present and continually evolving digital threats, providing a clear understanding of their significance in today's cyber landscape.
Crafting Custom Logging & Change Tracking in OutSystems — Part 2: The UI Layer and Use Cases
Continuing our exploration into custom logging and change tracking in OutSystems, this article delves into the UI Layer and use case patterns. It thoroughly examines interface enhancement techniques and the practical implementation of use case patterns. Aimed at developers, the content is focused on the practical application of these patterns designed to integrate seamlessly into any OutSystems application.
Crafting Custom Logging & Change Tracking in OutSystems — Part 1: The Core
Discover the art of custom logging and change tracking in OutSystems with our latest article. This first part of a two-part series dives deep into the core concepts of developing bespoke logging and tracking solutions. Learn how to lay the groundwork for an effective, reusable, and adaptable system tailored to fit the unique demands of your OutSystems applications.
An In-Depth Look at the Anatomy of End-User Permissions in OutSystems
As an OutSystems developer, you're likely familiar with managing permissions through the Users' application and server actions in code. However, have you ever wondered about the underlying database structure and the entities holding user permission data? This article provides a concise overview of these system entities.
Streamlining OutSystems Code Review: Tools, Tips, and Best Practices
Has someone just assigned you your first code review? Or maybe you’re already familiar with this practice and are just looking for some tips on how to do it in the OutSystems Platform? Either way, we’ve got you covered.
Reviewing code is a best practice for a reason: it can dramatically improve the quality of the delivery, increase the team’s technical proficiency, and save some troubles further down the road.
Unlock Real-Time Data Updates in OutSystems: A Quick How-To Using WebSocket Connections
This concise guide walks you through connecting to a Streaming Service that uses WebSockets to push live data. So, let's dive in and learn how to harness the power of real-time data updates in OutSystems effortlessly!
Stay Ahead of the Game: Handling Unplanned Work in OutSystems Projects
Unplanned (or reactive) work refers to tasks or projects that are not part of your original plan but are a response to a new request or unexpected issue. This article explores reactive work, why it matters, and how to handle it. We'll also discuss how proactive or planned work can help prevent reactive work from becoming overwhelming. And we'll look at the OutSystems agile approach to tackle it.
Getting Started with Multi-Tenancy on OutSystems
Multi-tenancy is a vital feature on the OutSystems platform that enables the isolation of data, configurations, and users between tenants. This feature allows the delivery of the same software for multiple customers while ensuring they cannot access each other's data at any moment.
This article will delve into the details of multi-tenancy and how to set it up.
How To Handle Dynamic Excel Spreadsheets On The Outsystems Platform
A data structure must be defined beforehand when importing or exporting an excel file through the built-in OutSystems feature. Although this works for most situations, a different approach is needed when the number of columns is not specified or is data-dependent. So, how can we work around not using a known data structure?