Datastore use

This section introduces key aspects related to the use of Datastore:

Inject data

Datastore includes the following function:

Function Description
Inject Collections

Injects collections into Datastore. Possible formats to be injected are:

  • Accounting fixed flat file format
  • Variable flat file format

For more information, see Inject data.

Extract data

Datastore includes the following function:

Function Description
Extract data

Extracts data from Datastore to a file. The extracted data is the result of a query execution.

For more information, see Extract data.

Partition lifecycle management

For read-only partitioned spaces, Datastore includes the following functions:

Function Description
Update online and retention periods

Set the online and retention periods for information contained in Datastore's spaces or partitions.

Unmount a partition Unmounts a partition, in order to prepare the archiving. The corresponding data is not available anymore for queries, but it is still present in the database.
Carve a partition Removes a partition. The corresponding data is saved by an external backup process.
Mount a partition Mounts a partition so that the corresponding data becomes available for queries.
Purge a partition Purges a partition when it is archived. The information is no longer available in the system.
Note   Partition refers to an object managed by the application, it does not refer to the database's native partitioning facility.

For more information, see Maintenance management. See also Partition management.

View data

Datastore includes the following functions:

Function Description
Request for Data

Executes a query in order to display data.

Aggregating The Quick Aggregation enables you to define aggregation criteria and aggregated values.
Filtering and sorting Filters and sorts data to optimize the display.
Results Tabs management Allows the customization of tabs (add tabs, filters, aggregation, column order, panel execution, and so on) to display the results of a query.
Navigation through system relationships Allows browsing the Audit data, using the system relationships (Transforms, Aggregates, Transfers, Modifies).
History usage Uses the query execution history to reuse the results of a query execution.

Export data

Datastore includes the following function:

Function Description
Export Data

Exports data from the result of a query to a CSV file. The export provides the content of the tab currently displayed along with its filters and aggregation applications.

Generate reports

Datastore includes the following function:

Function Description
Generate Report

Generates reports on a selected query result. You can create custom templates using the open source BIRT report designer. These reports can then be imported into the Repository.

Manage preferences

You only have to set your preferences once. Then, your preferences are saved when you log out and are restored at the next session.

You can set preferences on:

  • The language used in the interface (the default is the browser language)
  • The organization of query results:
    • Dispatched on different tabs
    • Tab names
    • Visibility, names, colours, and width of columns

After logging in, you can select the language you want to use each time you connect.

Related Links