Altair® Panopticon

 

[4] The Data Library Page

 

 

The Data Library page allows creation and management of reusable data tables outside workbooks. Data tables from the data library can be used by multiple workbooks server wide.

Some important concepts to remember:

q  Bringing data inside workbooks is done through data tables.

q  A data table contains metadata for data source connection settings, data query, schema definition, calculated columns, transforms, etc.

q  One data table can use only one data connector to connect to a data source.

q  Two or more data tables can be joined to create a new joined data table.

q  Data table permissioning and sharing between users or groups is done similarly like workbooks (i.e., using folder tree).

q  There are four types of data tables. The first three resides at the Data Library.

Data Table Type

Description

Data Store

Users can opt to store data closer to Panopticon server in an embedded database.

Live

Direct connection to source data.

Joined

Two or more different types of data tables joined together creating a new data table.

Uploaded

Uploaded files through any of the file connectors, that consequently becomes a Data Store, after importing to data store.

 

The Data Library page is composed of the following sections.

 

Data Library Page Sections and Descriptions

Section

Description

1

Folders

List of folders where data tables can be saved, exported, or imported.

2

Folder Context Menu

Allows you to:

·        Create a data table and joined data table

·        Assign folder permissions on your workspace

·        Import or export data table bundles

·        Create, rename, or remove folders

3

Search Data Table

Entering text will filter data tables which can include:

·        Those that are available in data store

·        Live data tables

·        Joined data tables

·        Extracts

4

Toolbar

Allows you to:

·        Display the data tables list either on List View or Grid View

·        Copy or move data tables to other folders

·        Import data table to data store

·        Clear and import data table to data store

·        Delete data tables

5

New Legacy Extract

Allows accessing data by retrieving only the required results into memory, by querying on demand, pushing aggregation, and filtering tasks to underlying big data repositories, or queryable data extracts.

6

New Joined Data Table

Allows you to join data tables created in the data library.

7

New Data Table

Allows you to create a data table.

8

List of Data Tables and Data Extracts

Data tables and data extracts created in the data library.

9

Data Table Context Menu

Allows you to:

·        Export data table bundles

·        Copy or move data tables to other folders

·        Rename or remove data tables

·        View details of the data table

·        Set the data policy for data tables in the Data Library