Foresight Analytics Platform enables the user to organize data warehouse of any complexity and architecture or set to the existing warehouse.
All data warehouse object are included in one repository. All operations with objects in repository are performed using object navigator.
The Data Import tool is used to load data from the custom file 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.
Connection to external databases is used to get access to data that is stored in external sources. The connection to external databases provides a possibility to store actual database settings, to get access to objects form another repository and also to get access to multidimensional databases built on Microsoft Analysis Services, SAP NetWeaver BW and other platforms.
Structuring data sets allows for creating data structures, creating basic elements for multidimensional data sources and managing master data. Tables, dictionaries, cubes and time series databases are considered as structured data sets.
Before starting data structuring, connect to external databases.
The ETL Task tool is used to extract data from external sources, transform and load to data consumers. To get started with an ETL task, there should be structured data sets and connection to external databases.
See also: