This extract retrieves metadata information from different types of connections.
Settings
| Connection: | OLAP, file, directory, Qlik, 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 Parameters: |
Additional filtering may be done with available filter parameters depending on the characteristic setting. |
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 | |
| Qlik | application | Name of the Qlik application | |
| table |
Name of one table of the data structure that Qlik Application uses.
|
||
| Relational databases |
catalog | no parameter required | Catalogs of a relational connection |
| schema | no parameter required | 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.
Updated April 8, 2025