-
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 - SQL Connection
Hi All! We are currently implementing a new Data Warehouse with a direct connection to Board. Now, my problem is that the DataReader does not always show the available tables and views from the Data Warehouse. Within the Cloud Portal, I have set up the access correctly, and the test was successful. Sometimes, it works—I…
-
Preview SQL statement should also work with final data reader process
We are using B12 cloud version and are connected to several SQL databases (our data warehouse). I know, best idea and work is that the SQL database has tables and views organised, that fit the need of board - without the need to implement ETL etc. However, life is not alway such easy and to get this, I always need support…
-
How to use advanced SQL statements to Bulk Insert in SQL table
1. Abstract The purpose of this article is to demonstrate how advanced SQL statements can be used in the Bulk Insert process to enhance the integration from Board to SQL databases. This article is not intended to be a comprehensive guide to all the functionalities, but rather to showcase three use cases that were tested…
-
How can I flag all periods between 2 dates?
Hi, I need to load some discount values from a table in SQL but the table does not have a month column. Instead, we have 2 separate columns; for Start Date and End Date. In normal circumstances, I would just take the last value from each of these dates and subtract the two lists, leaving me with the period between being…
-
Bulk Insert to SQL Table failed!
Hello, I tried running a basic procedure, with an initial selection and a bulk insert step. However, the procedure fails and gives this error: ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. Moreover, it does not recognize the fields in the SQL query. In the log file, all the fields are…
-
Matrix relationship SQL not working 🤔
Hello dear community, I want to do a matrix relationship via SQL datareader (same as explained in the resources below) : Here is a screen of the ETL : The result is an empty cube with no discard and "1" as a validated record Thank you in advance for your help
-
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…