Altair® Panopticon

 

Creating Data Extracts

 

Users with a Designer role can create data extracts.

On the Extracts tab, the following properties are displayed.

 

Data Extract Property

Description

Name

Data extract name.

Connector

Data connector used in the extract.

#Rows

Number of rows of the data extract.

#Columns

Number of columns of the data extract.

#Cells

Number of cells of the data extract.

Status

Status of the data extract. Values include IDLE or RUNNING.

When saving a new data extract, it is first run and the status changes to RUNNING. When the data extract is complete, the status changes to IDLE.

Last Modified

The Date/Time when the data extract is last completed or modified.

Last Refreshed

The Date/Time when the data extract is last refreshed.

 

 

A sample data extract using the MS Excel (legacy) connector before refreshing the data:

 

 

NOTE

 

A * symbol appears beside a data extract that is not yet refreshed.

 

After refreshing the data:

 

This section discusses the steps and guidelines on how to create data extracts.

Steps:

1.      On the Extracts tab, click on a folder then .

The Extracts tab displays with the following sections:

 

 

Section/Panel

Description

1

Connector drop-down list

Includes the non-streaming connectors to extract data from.

2

Extract Name

Name of the data extract. Click the  button to go back to the Data Extracts listing page.

3

Save

Save the changes made on the Extracts tab.

4

Refresh Data

Refresh the data after modifying and saving changes on the Data Extract page.

You can also opt to click Cancel Refresh Data .

5

Details

Display the details of the data extract including the number of rows, columns, cells, status, and the last time it was updated.

6

Connectors

Select the connector that will be used for the data extract.

7

Refresh Data Preview

Refresh the data preview.

`8

Expand Data Preview

Expand the Data Preview panel.

 

 

2.     Enter the Name of the data extract. This should be unique and should only contain letters (a to Z), numbers (0 to 9), and underscores.

3.     Click  or press Enter to apply the name.

4.     Select any of the following non-streaming connectors:

 

·        Azure

·        Cassandra

·        DolphinDB

·        Elasticsearch 6.x

·        Elasticsearch 7.x

·        Google Analytics

·        Google Cloud

·        InfluxDB

·        JDBC

·        JDBC Beta

·        JSON

·        Kx kdb+

·        KsqlDB

·        LivySpark

·        MongoDB

·        MS Excel (legacy)

·        MS Excel (xlsx)

·        OneTick

·        OneTick Cloud

·        Python

·        Rserve

·        S3

·        Shakti Beta

·        Splunk

·        Text

·        Web Data

·        XML

 

The tab page changes depending on the selected connector.