In this article:
Repository
The Repository connector is an object that is used to load data to repository objects.
After adding the connector to the ETL task workspace set basic properties, data source in repository, export options.
Depending on repository object used as consumer, consumer context menu will contain additional items:
Existing cube or time series database:
Open with. The specified repository object will be opened in one of the Foresight Analytics Platform tools: Dashboards, Reports, Analytical Queries.
Table:
Open Data Consumer. The table specified as a data consumer opens.
Edit Data Consumer. The editor wizard of the table specified as a data consumer opens.
Document:
Browse Data. The browse data dialog box of the document opens.
Repository Object
The Repository Object page is displayed only on creating a new consumer:
Select a consumer type, to which export is executed. If a new object is created, on moving to the Data Consumer page it is prompted to save a new object to repository.
Data Consumer
Select an object in the current repository to be used as a data consumer.
The following repository objects can be used as consumers:
Data sets (table, external table, view, query, ODBC data provider, table MDM dictionary).
Document.
Standard cube.
Time series database.
If the Clear Consumer Before Loading Data checkbox is selected, all data contained in the consumer object is deleted before loading.
The Edit Object button opens the editing wizard of the selected object if the wizard was prepared.
NOTE. On selecting a standard cube as a consumer, time series database, table MDM dictionary or composite table MDM dictionary, the Clear Consumer Before Loading Data checkbox and the Edit Object button are not available.
If a new consumer is created, and the option of creating a new object is selected on the Repository Object page, on moving to the current page it is prompted to save a new object to repository. The created object is automatically selected in the drop-down list. The list will also contain the filter that enables the user to select other object of one type that was specified on the Repository Object page.
Export Options
To set up parameters used to determine exported range of data, use the Export Options page.
NOTE. To display this page in the Repository data consumer wizard, specify on the Data Consumer page a file of the Document type as a data consumer.
Settings depend on the document type and are the same as export settings for data consumer of the same format.
For example, using the document with the *.xlsx extension as a data consumer, the Export Options page looks as follows:
Setting Up Dimensions
To change name of dimensions and its contents, use the Dimensions Setup page.
To move to the page
According to the type of selected data provider, on clicking the Next button the user moves to the next page.
Dimensions Comparison
To link imported dimensions with existing repository dictionaries, use the Dimensions Comparison page.
To link dimension with existing dictionary, select dictionary in the drop-down list next to required dimension. The following items are available for selection:
Calendar dictionaries.
Table MDM dictionaries.
Composite table MDM dictionaries.
To add new elements to the dimension from attribute of selected dictionary on import, select the Add New Records checkbox. The checkbox is selected by default. If the checkbox is deselected, elements are not be added. Data is imported only for the elements in the provider and in the selected dictionary. Only elements existing in the dictionary are used for data linking.
NOTE. Take into account existing features on importing to the hierarchical or multilingual dictionaries.
If dimension is not linked with existing dictionary, a new table MDM dictionary is created for it.
Updating Records
To select fields for update in data provider and consumer, use the Update Records page.
In the Identifier column, select checkboxes of the fields, which will be used to compare records in provider and consumer.
To select all fields for update, click the Select All button.
To deselect all fields, click the Deselect All button.
To deselect simultaneously selected fields and select the deselected ones, click the Invert button.
NOTE. Record update is relevant if the consumer is not cleared before data loading.