-
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…
-
Datareader - Option to Log row where validation condition isn't satisfy
The idea Add an option to have the discarded line from the data source saved in a log file when the validation condition isn't satisfy Use case : Sometime, you now the row is in error and discard it as to not mess up the entity but it would be preferable to have a simple way to show the error to the end-user to ensure the…
-
Board REST API's to create Entity,Datareader and Cubes
Migrating from a legacy Enterprise Performance Management (EPM) system to a new platform like Board can be a complex process, especially when it involves significant changes in data structures and formats. If the REST API documentation for Board does not provide methods for creating new entities, cubes, or data readers. I…
-
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…
-
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…
-
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
-
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.
-
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.…