Metadata Extract

image_pdfimage_print

This extract retrieves metadata information from different types of connections.

Main settings
Connection OLAP, file, directory, and other relational connections are supported.
Characteristic Defines the requested type of information. The available characteristics depend on the connection type (see table below).
Filter Additional filtering may be done with available filter parameters depending on the characteristic setting.

This table lists the available metadata characteristics by connection type:

Connection Type Characteristic Filter parameters Comment
Jedox,
JedoxGlobal
database Mask Databases of an OLAP connection
cube Database, mask Cubes of an OLAP database
dimension database, cube, mask Dimensions of an OLAP database or cube
Relational databases
(as in 3.1, 3.2)
catalog Catalogs of a relational connection
schema Schema of a relational connection
table catalogPattern, schemaPattern, tablePattern, tableTypes Tables of a relational connection in a catalog and/or schema
column catalogPattern, schemaPattern, tablePattern, Columns of a relational table
File columns Column names of the file
Directory columns Column names of the files in the directory
files Files in a directory (filename, last changed date, is hidden,…)
directories Direct subdirectories in a directory
filesAndDirectories Files and direct subdirectories in a directory
Tableau site Sites on a Tableau Server
project Projects for the site on a Tableau Server

Note: the parameter “mask” defines a bit-mask filter on the selected OLAP object types:

Object

Mask

Bit1

Bit2

Bit3

Bit4

Bit5

Database

111

Normal

System

UserInfo

   

Dimension

1111

Normal

Attribute

System

UserInfo

 

Cube

11111

Normal

Attribute

UserInfo

System

GPU

Examples:

Characteristic Database, Mask “111”: all databases are retrieved.
Characteristic Dimensions, Mask “1100”: dimensions of type “Normal” and “Attribute” are retrieved.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...