-
Integrating Board with Google BigQuery
1. Abstract This document describes the recommended approach for integrating Google BigQuery with Board using the Progress DataDirect JDBC connector within the Data Pipeline. It outlines the integration architecture, configuration steps, and data import methods, positioning BigQuery as the source of truth and Board as the…
-
How to display images stored in the Google Cloud Storage
1. Abstract Displaying images stored in Google Cloud Storage (GCS) inside Board is straightforward - as long as the URL is constructed dynamically through Board algorithms and secured with a valid signed URL. As Solution Architects, our objective is to provide a clean, modern pattern where Board remains lightweight while…
-
How to display images stored in the Azure Storage
CONTENT 1.1 Display an image stored in the Azure Storage Displaying images stored in Azure Storage directly in Board is possible by dynamically constructing the URL according to the File Storage public access schema. The integration leverages the algorithm blocks to concatenate the relevant URL components Each image is…
-
How to use advanced SQL statements to Bulk Insert in SQL table
*NEW—Includes video demonstration. Build Along with Board Follow along as we provide a demonstration to further illustrate the basic principles shared in the step-by-step guide outlined below. https://player.vimeo.com/video/1124042460?badge=0&autopause=0&player_id=0&app_id=58479 Quick view 9:48: Use Case 1—Using Filters…
-
How to set up a Rest API connection
1. Abstract This article explains how external systems can retrieve data from Board using Board API queries. The article also showcases a simple case on how Board can obtain data from external systems by calling their REST APIs, thus enabling smooth integration between the two solutions. 2. Context APIs stand for…
-
How to set up SAP Connector Architecture
1. Abstract This article recaps all the options available when we set up the architecture for Board cloud - SAP integrations that require the Board Connector for SAP by Theobald. In the early implementation stage of projects where Board needs to import SAP data, Board architects – or the implementation partner - and the…
-
How to replace REST Connector with REST API Call
1. Abstract This document illustrates how to adjust and optimize your REST API connection to leverage the more recent and advanced features and remove the technical limitations of previous solutions. Board 12 introduced new ground-breaking integration capabilities. As a Board solution is periodically upgraded to newer…
-
How to trigger SQL server actions
1. Abstract This article discusses the possibilities of using ROLAP cubes to write flags into an SQL server, thus triggering actions on the database side, and how to process this flag. 2. Context Usually, data pre-calculations are loaded into Board from a SQL server, but there are times when we need to initiate actions on…
-
How to set parametric WHERE clause for SAP
1. Abstract With the Theobald Board Connector, a SAP-certified middleware is available to load data from SAP systems (ERP/BW) to Board if the database of the system cannot or may not be addressed directly (e.g. HANA via ODBC). More information can be found here: https://help.theobald-software.com/en/board-connector/ In the…
-
How to: Integration with Dynamics 365 OData APIs
1. Abstract This document illustrates two different methods of connecting Board to Dynamics 365 OData APIs and all aspects related to these configurations, such as authentication, testing and pagination. 2. Context Integrating Board with Microsoft SaaS products is becoming an increasingly frequent ask. One of the most…
-
How to send notifications: Integration with MS Teams
1. Abstract A typical request during project implementations is to support the process workflow by adding notifications to users when certain actions have been executed and the next workflow steps can start. In this article, we want to show how to handle the notification to Microsoft Teams through the engagement of an…
