-
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…
-
Connection Board to Azure fabric - cloud SQL DB
Hi We have Board on Azure cloud supported by Board. We are moving from our old ERP solution to MS Dynamics 365. The data will be moved from Dynamics to the MS data model and to Azure Fabric – cloud. Are there any others that have made the connection from Board to Azure Fabric? We are struggling to get the connection to…
-
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…
-
Limitations when pushing data from MDB to RDB via Dataflow
All, Are we aware of any limitations when pushing data from an MDB cube to an RDBMS using a dataflow? Scenario Overview: We have an MDB cube composed of four entities - 3 General Entities + 1 Time Entity Entities Max Item Item Count Entity 1 100000 30141 Entity 2 1000 41 Entity 3 100 8 Month Infinity 204 The goal is to…
-
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…
-
Data Export Functionalities
1. Abstract Describe all the alternatives available when you export a dataset from Board to integrate it with an external third-party environment or another Board data model. What are the pros and cons of the different solutions from file export to APIs? 2. Context Follow these best practices every time you have to…
-
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…
-
V12 - Smart import & max items
Hello everyone, As a neophyte, I am currently experiencing a few problems. Indeed, most of my models are still on a pre-V12 version and I'd like to understand the advantages of the V12 on certain points. Optimization with Smart Import in Board V12: What are the best strategies for taking full advantage of the "smart…
-
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 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 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…
-
Error during installation of OPC
Hi, during the OPC installation, this error appears in the step where the DATA PIPELINE credentials are entered, does anyone know why?
-
Board Academy Launches Data Integration Webinar Series for Developers
Board Academy is excited to announce its newest training curriculum, Data Integration, led by Board Solution Architect, Andrea Duò. This three-part curriculum will prepare developers to expand their knowledge of network architecture and connectivity in the Board platform. By taking this course, developers will learn to…
-
Triggering procedures with REST API Calls from within Board
1. Abstract This article discusses the possibilities of triggering Board procedures via Rest API Calls from within Board itself and the how’s and why’s of this approach. 2. Context The Board Public APIs empower external systems to seamlessly interact with a Board application. By utilizing REST API calls, you can, for…