-
Smart Import Enhancement
The last releases contained a lot of news about the Smart Import Object. The functions that the object now brings with it are great. Still, I would like to see two more features: moving columns (without having to rename and remap columns every time a new column is added in between.if rows are rejected, it would be great if…
-
How to hide/ignore columns of an Excel data source when using the Smart Import Object
Is it possible to hide/ignore columns of an Excel data source if they are not relevant for the import when using the file upload of the Smart Import Object (e.g. descriptions or comments)? In the following table, columns A,B (entities) and D,E (values) have to be imported, columns C,F have to be ignored.
-
Data Load Guidelines
1. AbstractWhile developers are focused on data model creation and data integration, they need to remember that in addition to the data model structure, they have to fill this structure with data. Entities and Cubes have to be filled with meaningful data to be seen by the users. This document provides a standardized method…
-
Data Transformation
1. AbstractThe data transformation process can be done in three different ways: 1. with SQL transformations directly in the data source or in the Data Reader Object 2. with the out-of-the-box Board ETL function 3. after the data has been imported into Board by using the dataflow engine. The type and number of data sources…
-
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 comparisonCSV Parquet Row-based storage format. A hybrid of Row-based and column-based…
-
Extract Cubes in Parquet-File
1. What is your idea?Board has multiple steps to extract data from cubes: Extract CubeExport Data View to fileExport DatasetExtract all cubesAll these steps save data as text or csv-files. We could save disk-space and increase performance by using parquet-files. Head-to-head comparisonCSV Parquet Row-based storage format.…