Data Integration

Allow the use of Temporary Cubes on Smart Import objects
The idea is simple: Allow the use of Temporary Cubes on Smart Import objects as we do for Data Readers. It should be possible to type the Temporary Cube name and load data into it. The Temporary Cube should be configured in the Trigger Procedure launched after a Data entry action. Today, for the Smart Import object, we…
Board Tree Public API
In addition to the existing APIs, it would be useful to have a public schema for retrieving a specific hierarchy via API, similar to the one available for entities. Currently, if we want to extract a tree from the Board, we must create a custom API query that includes all the necessary fields from the layout section, which…
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…
Rest API call manual script
With the new 'Rest API call' action, it is possible to connect and download data from a public or authorized API into a CSV/JSON file through a list of mapped parameters. Even though, you have the possibility to see how the query has been structured in the 12.6 release, you cannot edit it. It could be useful to interact…
New Datasource: SAP Data Lake
Customers in DACH-Region are mainly driven by SAP. SAP Cloud is increasingly being used by customers. SAP data and non-SAP data is stored there. It is necessary to read and write data from SAP Data Lake. Connect to Data Lake Relational Engine Using the .NET Driver
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: In the simplest case, data is read from SAP tables, i.e. 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…
Rest API: Additional output/storage formats for REST API call (e.g. temporary cube)
The only output format (right now) for an REST API call is to save it to an CSV file. This CSV file can be used to load an temporary cube. A direct load (without saving the file to disk) into a cube / temporary cube would be a great enhancement.
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?
Probably The Best Alternative to CSV Storage: Parquet Data
1. What is your idea? Board support a lot of datasources. Probably the most used are csv files. However, with ever increasing amounts of data, working with csv files becomes a pain. Parquet files can be an alternative. Head-to-head comparison CSV Parquet Row-based storage format. A hybrid of Row-based and column-based…
Delta Lake for read/write parquet files
What is Delta Lake? Delta Lake is an open-source storage layer that brings ACID (atomicity, consistency, isolation, and durability) transactions for big data workloads. Key features of Delta Lake Feature Description ACID Transactions Data lakes are typically populated through multiple processes and pipelines, some of which…
Dynamic Filter Parameter in Sap Connector
the idea is to make more parametrical the theobald sap connector. right know is not possible to link a selection made at screen level (example with a selector) to the data reader allowing to reduce the dataset to be loaded. so for example if we are loading large dataset the loading process will take a lot. the parameter…
Temporary DataReader in Procedures
Hello together, to reduce the number of DataReaders, it would be helpful if DataReaders can be created temporarily in a procedure. This would also significantly increase flexibility in combination with temporary cubes. Best regards Christoph S.
REST API - Execute Procedure with Selection
Selections are an elementary concept for controlling procedures in Board. When starting a procedure from a screen, a start selection is usually passed with it. We need this possibility also, if we start a procedure over the rest Api. The selection could be passed in the body as JSON. Currently only the database name and…
Connection alias on Cloud Administration portal
When you create the connection alias on the admin portal, you must have an existing connection configured on the Datapipeline portal. So when you map the alias to the existing connection, one should not need to type the connection name, it would be better to have a drop-down list only showing the available connections so…
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…
Pagination for API-Queries
API-Queries are a great way to expose Data to other Board-Systems or third-party-applications. Big Data-Sets could end in Time-Out. It would be helpfull to cut big datasets in smaller pieces with pagination. Please have a look on Pagination on REST API call Procedure step.
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…
Rest API Integration into a cube in Board directly.
Hi, We have set up a Rest API call that bypasses the pipeline and pulls data from a different model in our Board instance. Is it possible to take the payload(source data) that we get from the Rest API and push it directly to a cube in our datamodel? We do not want the payload to be exported into an output file that is…
Extract Cubes in Parquet-File
1. What is your idea? Board has multiple steps to extract data from cubes: Extract Cube Export Data View to file Export Dataset Extract all cubes All these steps save data as text or csv-files. We could save disk-space and increase performance by using parquet-files. Head-to-head comparison CSV Parquet Row-based storage…
Data reader failing with error "ReadGo4EseguiCUBESdo failed for ddv" in diagnostic log
I have a client where SQL data readers started failing to fully load data yesterday with the error below in the Diagnostic log. A trace in SQL shows the queries executed properly and the other Board logs show the correct number of records. No other functionality in Board appears to be impacted. The client is using 12.4.0.…
How to manage cloud tasks from on premise server - Orchestrator
Hello community i'm going to move to cloud and I know it's now possible execute a board procedure through an API call. Since I have various tasks to copy files to/from the cloud, to be synchronyzed with Board procedures, I would evaluate possible solutions to manage processes that combines batches to transfer files (with…

Data Integration

Discussion List