-
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 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