Datastore 2.3.0 User Guide Datastore use This section introduces key aspects related to the use of Datastore: Inject data Extract data Partition lifecycle management View data Export data Generate reports Manage preferences 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 tabsTab namesVisibility, names, colours, and width of columns After logging in, you can select the language you want to use each time you connect. Related Links
Datastore use This section introduces key aspects related to the use of Datastore: Inject data Extract data Partition lifecycle management View data Export data Generate reports Manage preferences 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 tabsTab namesVisibility, names, colours, and width of columns After logging in, you can select the language you want to use each time you connect.