Data import is used to load data from the custom source to a standard cube or time series database.The import wizard enables the user to load data to repository using minimal settings and create all the objects required to access this data (cubes or time series databases, dictionaries, and tables).
Import wizard works correctly if the repository database used by default.
Key features:
Data transformation and filtering before their loading.
Support of a number of data sources: OLE DB; Microsoft Access databases; REST data sources; CSV, TXT, XLS, XLSX, XML, JSON files; platform repository objects.
Automatic creation of all objects required for import.
Data loading to existing objects.
Import is available from the following data sources:
Comma Separated Values file (*.csv).
Microsoft Access database (*.mdb, *.accdb).
Text file (*.txt).
Microsoft Excel file (*.xls, *.xlsx).
XML file (*.xml).
Repository objects:
Dictionaries.
Data sets (tables, queries, views, and so on).
JSON files (*.json).
REST data sources.
NOTE. The current realization enables the user to import data, presented only in JSON format, from a REST source.
OLE DB sources, which drivers are installed in the operating system.
NOTE. Import from OLE DB sources and repository objects is available only in the desktop application.
Before starting data import, get acquainted with requirements and common recommendations for data sources.
To start import, do the following:
In the Service > Data Import main menu.
Select Report > Data Import in the express report or regular report main menu.
Select Document > Data Import in the dashboard main menu.
Click the Data Import button on the side panel of the Source express report or regular report tab.
Click the Data Import button in the Source button drop-down menu on the workbook sheet.
Click the Data Import button on the side panel in the dashboard designer on the Data Source tab.
Click the From File button in the Get Data group on the Data regular report ribbon tab.
Select the Data Import task in the welcome screen on any tab.
The import wizard is started.
If the Open with > Data Import Wizard item is selected in the object navigator in table/query/view context menu, the import wizard opens on the source selection page. An object, for which the command is executed, is placed as a source.
After the import is started, the first wizard page opens:
Select type of the source, from which import is executed, and click the Next button.
The further setup includes the following stages:
Binding dimensions with existing dictionaries / Mapping source fields with existing consumer fields.
Different objects are created after import depending on the selected type of data consumer (standard cube or time series database).
Import to time series database
After executing import data is available for analysis. If any errors occurred during the import, the Data Import Conflicts dialog box opens on finishing the import. Example of import from table and crosstab are given in the Import Examples section.
See also:
