The tool supports the interface of Foresight. Analytics Platform 9 or earlier.

Data Import Without Preparation

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:

Import is available from the following data sources:

NOTE. The current realization enables the user to import data, presented only in JSON format, from a REST source.

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.

Getting Started

To start data import:

The import wizard is started.

If the Open with > Data Import Wizard item is selected in the desktop application 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.

Working with Data Import Wizard

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:

  1. Select source:

  2. Fix data.

  3. Fix dimensions.

  4. Select data consumer.

  5. Bind dimensions with existing dictionaries. / Map data source fields with existing data consumer fields.

  6. Set up dictionaries.

Different objects are created after import depending on the selected type of data consumer (standard cube or time series database).

Import to cube

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. Examples of import from table and crosstab are given in the Import Examples section.

See also:

Database | Cubes