Manta Flow Model
The Manta Flow model details the object and attribute types used in the IBM Automatic Data Lineage repository and presented to users via visualization, API, and repository export. It can be used as a reference when importing metadata via Open Manta extensions.
- Element Types
- Oracle
- Oracle Scripts
- Teradata
- Teradata Scripts
- TPT
- MS SQL
- MS SQL Scripts
- Netezza
- Netezza Scripts
- Db2
- Db2 Scripts
- PostgreSQL
- PostgreSQL Scripts
- Snowflake
- Snowflake Scripts
- Hive
- Hive Scripts
- BigQuery
- BigQuery Scripts
- BigQuery Job Scripts
- SAP HANA
- SAP HANA Scripts
- Filesystem
- Informatica PowerCenter
- SSIS
- Talend
- ODI
- SSAS
- SSRS
- Excel
- Cognos
- OBIEE
- Power BI
- Tableau
- StreamSets
- Default
- SAP BO
- Cobol Scripts
- JCL Scripts
- Custom Script Scanner
- SAS
- SAS Code
- Kafka
- Fivetran
- Matillion
- MicroStrategy
- Custom Reports
- Custom ETL
- Attribute Types
Element Types
Here is a list of element types for each resource type produced by Manta Flow connectors.
Oracle
An Oracle resource includes objects in database catalogs from all analyzed Oracle databases (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Database | Global database |
| Schema | Database schema/user |
| Table | Database table |
| View | Database view |
| PLSQL Synonym | Database synonym to a table or view |
| Column | Database column of a view, table, or synonym |
| PLSQL Package | PL/SQL package that can contain procedures and functions |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| Trigger | Database trigger |
| PLSQL Sequence | PL/SQL sequence |
| PLSQL Object | PL/SQL object type that can contain fields, procedures, and functions |
| PLSQL Cursor | PL/SQL cursor |
| PLSQL Variable | PL/SQL variable or PL/SQL object field |
| PLSQL ArrayItem | Item of an array |
| PLSQL RecordField | Field of a record |
| Pseudocolumn | Not a real database column that behaves like a column (e.g., length of array) |
Oracle Scripts
There are two Oracle-script-type resources.
-
Oracle DDL — includes DDL scripts from the Oracle databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the Oracle resource)
-
Oracle PL/SQL — includes PL/SQL scripts that are executed against the Oracle databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a database containing all Oracle scripts |
| Directory | Directory containing Oracle scripts and directories |
| PLSQL Script | Oracle script containing PL/SQL code |
| PLSQL Block | Block of PL/SQL statements |
| PLSQL ExceptionBlock | Exception block of PL/SQL statements |
| PLSQL Loop | For, while, etc. loop cycles |
| PLSQL Expression | Expression containing transformation logic |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| PLSQL Insert | Insert statement |
| PLSQL MultiTableInsert | Insert statement with multiple targets |
| PLSQL Update | Update statement |
| PLSQL Delete | Delete statement |
| PLSQL Merge | Merge statement |
| PLSQL MergeInsert | Insert branch of a merge statement |
| PLSQL MergeUpdate | Update branch of a merge statement |
| PLSQL MergeDelete | Delete branch of a merge statement |
| PLSQL SelectInto | Select into statement |
| PLSQL CreateView | Create view statement |
| PLSQL CreateTable | Create table statement |
| PLSQL DropTableOrView | Drop table statement or drop view statement |
| PLSQL TruncateTable | Truncate table statement |
| PLSQL Query | Standalone select statement |
| PLSQL Subquery | Part of standalone select statement |
| PLSQL VarAssignment | Variable assignment statement |
| PLSQL ColumnFlow | Column of a statement |
| PLSQL ResultSetColumn | Column of a result set |
| PLSQL ArrayItem | Item of an array |
| PLSQL RecordField | Field of a record |
| Pseudocolumn | Not a real database column that behaves like a column (e.g., length of array) |
| PLSQL Return | Return statement |
| PLSQL DeclareCursor | Declaration of a cursor |
| PLSQL OpenCursor | Opening of a cursor |
| PLSQL Fetch | Fetching of a cursor |
| PLSQL CursowRow | Row of a cursor |
| PLSQL Returning | Returning clause of insert, update, or delete statement |
| PLSQL PipeRow | Pipe row statement |
| PLSQL ExecuteImmediate | Execute immediate statement |
| PLSQL ExecInto | Into clause of an execute immediate statement |
| PLSQL ExecUsing | Using clause of an execute immediate statement |
| DynamicSql | Interpreted dynamic SQL code |
| PLSQL TriggerFlow | Data flow from/to variables representing old and new row in trigger |
Teradata
A Teradata resource includes objects in database catalogs from all analyzed Teradata databases (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | Teradata server |
| Database | Teradata user or database |
| Table | Database table (including temporary or volatile table) |
| View | Database view |
| Column | Database column of a view or table |
| Procedure | Database stored procedure |
| Macro | Database macro |
| Parameter | Formal parameter of a stored procedure |
Teradata Scripts
There are two Teradata-script-type resources.
-
Teradata DDL — includes DDL scripts from the Teradata databases analyzed (all definitions are contained directly under this resource)
-
Teradata BTEQ — includes BTEQ scripts that are executed against the Teradata databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a database containing all SQL and BTEQ scripts |
| Directory | Directory containing SQL and BTEQ scripts and directories |
| BTEQ Script | SQL or BTEQ script containing SQL or BTEQ code |
| BTEQ Statement | SQL or BTEQ statement in a script |
| BTEQ Insert | Insert statement |
| BTEQ Update | Update statement |
| BTEQ Delete | Delete statement |
| BTEQ Merge | Merge statement |
| BTEQ SelectInto | Select into statement |
| BTEQ CreateView | Create view statement |
| BTEQ CreateTable | Create table statement |
| BTEQ DropTableOrView | Drop table or drop view statement |
| BTEQ Rename | Rename statement |
| BTEQ ColumnFlow | Column of a statement |
| BTEQ DeclareCursor | Declaration of a cursor |
| BTEQ Fetch | Fetching of a cursor |
| BTEQ CreateProcedure | Create procedure statement |
| Block | Procedure body (the list of statements constituting the main tasks of the stored procedure) |
| BTEQ CreateMacro | Create macro statement |
| BTEQ CreateFunction | Create function statement |
| BTEQ Condition | Condition |
| BTEQ MasterSelect | Standalone select statement |
| BTEQ ProcedureCall | Call of a procedure |
| BTEQ FunctionCall | Call of a function |
| CallParameter | Parameter of a procedure or function call |
TPT
A Teradata PT resource includes TPT scripts that are executed against the Teradata databases analyzed and provided externally.
| Type | Description |
|---|---|
| Connection | Connection to a database containing all TPT scripts |
| Directory | Directory containing TPT scripts and directories |
| TPT Script | TPT script containing TPT code |
| TPT Apply | Apply statement |
| TPT ApplyColumn | Column flow in an apply statement |
| TPT Condition | Condition |
| BTEQ Script | SQL code containing TPT script |
| BTEQ Statement | SQL or BTEQ statement in a script |
| BTEQ Insert | Insert statement |
| BTEQ Update | Update statement |
| BTEQ Delete | Delete statement |
| BTEQ Merge | Merge statement |
| BTEQ SelectInto | Select into statement |
| BTEQ CreateView | Create view statement |
| BTEQ CreateTable | Create table statement |
| BTEQ DropTableOrView | Drop table or drop view statement |
| BTEQ Rename | Rename statement |
| BTEQ ColumnFlow | Column of a statement |
| BTEQ DeclareCursor | Declaration of a cursor |
| BTEQ Fetch | Fetching of a cursor |
| BTEQ CreateProcedure | Create procedure statement |
| Block | Procedure body (the list of statements constituting the main tasks of the stored procedure) |
| BTEQ CreateMacro | Create macro statement |
| BTEQ CreateFunction | Create function statement |
| BTEQ Condition | Condition |
| BTEQ MasterSelect | Standalone select statement |
| BTEQ ProcedureCall | Call of a procedure |
| BTEQ FunctionCall | Call of a function |
| CallParameter | Parameter of a procedure or function call |
MS SQL
There are two MS SQL type resources.
-
MS SQL — includes objects in database catalogs from all the Microsoft SQL Server, PDW, Azure SQL, Azure SQL Data Warehouse, and Amazon RDS for SQL Server databases analyzed (including those deduced from ETL and reporting tools)
-
Sybase — includes objects in database catalogs from all the SAP ASE databases analyzed (including those deduced using ETL and reporting tools)
| Type | Description |
|---|---|
| Server | SQL Server and instance |
| Database | Database in server |
| Schema | Database schema |
| Table | Database table |
| View | Database view |
| Synonym | Database synonym to a table or view |
| Column | Database column of a view, table, or synonym |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| Trigger | Database trigger |
| Sequence | Sequence |
MS SQL Scripts
There are four MS SQL script-type resources.
-
MS SQL DDL — includes DDL scripts from the Microsoft SQL Server, PDW, Azure SQL, Azure SQL Data Warehouse, and Amazon RDS for SQL Server databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the MS SQL resource)
-
MS SQL Transact-SQL — includes Transact-SQL scripts that are executed against the Microsoft SQL Server, PDW, Azure SQL, Azure SQL Data Warehouse, and Amazon RDS for SQL Server databases analyzed and provided externally
-
Sybase DDL — includes DDL scripts from the SAP ASE databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the Sybase resource)
-
Sybase Transact-SQL — includes Transact-SQL scripts that are executed against the SAP ASE databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all SQL Server or SAP ASE scripts |
| Directory | Directory containing SQL Server or SAP ASE scripts and directories |
| MS SQL Script | SQL Server or SAP ASE script containing Transact-SQL code |
| Block | Block of Transact-SQL statements |
| Loop | For, while, etc. loop cycles |
| Expression | Expression containing transformation logic |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Merge | Merge statement |
| MergeInsert | Insert branch of a merge statement |
| MergeUpdate | Update branch of a merge statement |
| MergeDelete | Delete branch of a merge statement |
| Rename | Rename statement |
| ExchangePartition | Exchange partition statement |
| SelectInto | Select into statement |
| DmlOutput | Output of a DML statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| TruncateTable | Truncate table statement |
| Query | Standalone select statement |
| Subquery | Part of standalone select statement |
| ColumnFlow | Column of a statement |
| ResultSetColumn | Column of a result set |
| Return | Return statement |
| DeclareCursor | Declaration of a cursor |
| FetchCursor | Fetching of a cursor |
| Cursor | Cursor |
| CursowRow | Row of a cursor |
| ExecuteDynamicSql | Execute immediate statement |
| If | If statement |
| Case | Case statement |
| BreakLoop | Break loop statement |
| ContinueLoop | Continue loop statement |
| ConsoleOutput | Output to console |
Netezza
A Netezza resource includes objects in database catalogs from all analyzed Netezza databases (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | Netezza server |
| Database | Database in server |
| Schema | Database schema |
| Table | Database table |
| View | Database view |
| Synonym | Database synonym to a table or view |
| Column | Database column of a view, table, or synonym |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| Trigger | Database trigger |
| Sequence | Sequence |
Netezza Scripts
There are two Netezza-script-type resources.
-
Netezza DDL — includes DDL scripts from the Netezza databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the Netezza resource)
-
Netezza NZPLSQL — includes NZPLSQL scripts that are executed against the Netezza databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all Netezza scripts |
| Directory | Directory containing Netezza scripts and directories |
| Netezza Script | Netezza script containing NZPLSQL code |
| Block | Block of NZPLSQL statements |
| Loop | For, while, etc. loop cycles |
| Expression | Expression containing transformation logic |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Merge | Merge statement |
| MergeInsert | Insert branch of a merge statement |
| MergeUpdate | Update branch of a merge statement |
| MergeDelete | Delete branch of a merge statement |
| SelectInto | Select into statement |
| DmlOutput | Output of a DML statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| TruncateTable | Truncate table statement |
| Query | Standalone select statement |
| Subquery | Part of standalone select statement |
| ColumnFlow | Column of a statement |
| Return | Return statement |
| DeclareCursor | Declaration of a cursor |
| FetchCursor | Fetching of a cursor |
| Cursor | Cursor |
| CursowRow | Row of a cursor |
| ExecuteDynamicSql | Execute immediate statement |
| If | If statement |
| Case | Case statement |
| BreakLoop | Break loop statement |
| ContinueLoop | Continue loop statement |
| ConsoleOutput | Output to console |
Db2
A Db2 resource includes objects in database catalogs from all the Db2 databases analyzed (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | Db2 server |
| Database | Database in server |
| Schema | Database schema |
| Table | Database table |
| View | Database view |
| Synonym | Database synonym to a table or view |
| Column | Database column of a view, table, or synonym |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| Trigger | Database trigger |
| Sequence | Sequence |
Db2 Scripts
There are two Db2-script-type resources.
-
Db2 DDL — includes DDL scripts from the Db2 databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the Db2 resource)
-
Db2 PL/SQL — includes PL/SQL scripts that are executed against the Db2 databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all Db2 scripts |
| Directory | Directory containing Db2 scripts and directories |
| Db2 Script | Db2 script containing PL/SQL code |
| Block | Block of PL/SQL statements |
| Loop | For, while, etc. loop cycles |
| Expression | Expression containing transformation logic |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Merge | Merge statement |
| MergeInsert | Insert branch of a merge statement |
| MergeUpdate | Update branch of a merge statement |
| MergeDelete | Delete branch of a merge statement |
| SelectInto | Select into statement |
| DmlOutput | Output of a DML statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| TruncateTable | Truncate table statement |
| Query | Standalone select statement |
| Subquery | Part of standalone select statement |
| ColumnFlow | Column of a statement |
| Return | Return statement |
| DeclareCursor | Declaration of a cursor |
| FetchCursor | Fetching of a cursor |
| Cursor | Cursor |
| CursowRow | Row of a cursor |
| ExecuteDynamicSql | Execute immediate statement |
| If | If statement |
| Case | Case statement |
| BreakLoop | Break loop statement |
| ContinueLoop | Continue loop statement |
| ConsoleOutput | Output to console |
PostgreSQL
A PostgreSQL resource includes objects in database catalogs from all the PostgreSQL databases analyzed (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | PostgreSQL server |
| Database | Database in server |
| Schema | Database schema |
| Table | Database table |
| View | Database view |
| Column | Database column of a view, table, or synonym |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| Trigger | Database trigger |
| Sequence | Sequence |
PostgreSQL Scripts
There are two PostgreSQL-script-type resources.
-
PostgreSQL DDL — includes DDL scripts from the PostgreSQL databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the PostgreSQL resource)
-
PostgreSQL PLpgSQL — includes PL/SQL scripts that are executed against the PostgreSQL databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all PostgreSQL scripts |
| Directory | Directory containing PostgreSQL scripts and directories |
| PostgreSQL Script | PostgreSQL script containing PLpgSQL code |
| Block | Block of PLpgSQL statements |
| Loop | For, while, etc. loop cycles |
| Expression | Expression containing transformation logic |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Rename | Rename statement |
| SelectInto | Select into statement |
| DmlOutput | Output of a DML statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| TruncateTable | Truncate table statement |
| Query | Standalone select statement |
| Subquery | Part of a standalone select statement |
| ColumnFlow | Column of a statement |
| Return | Return statement |
| DeclareCursor | Declaration of a cursor |
| FetchCursor | Fetching of a cursor |
| Cursor | Cursor |
| CursowRow | Row of a cursor |
| ExecuteDynamicSql | Execute immediate statement |
| If | If statement |
| Case | Case statement |
| BreakLoop | Break loop statement |
| ContinueLoop | Continue loop statement |
| ConsoleOutput | Output to console |
Snowflake
A Snowflake resource includes objects in database catalogs from all the Snowflake databases analyzed (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | Snowflake server |
| Database | Database in server |
| Schema | Database schema |
| Table | Database table |
| View | Database view |
| Column | Database column of a view or table |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | A formal parameter of a database function or stored procedure |
| ReturnValue | A formal return value of a database function |
| Sequence | Database sequence |
| Snowflake stage | Database internal stage |
| Snowflake directory | Internal named stage directory |
| Snowflake file | A file stored in the internal named stage directory |
| Snowflake pipe | Snowflake object that contains a COPY statement used by Snowpipe |
Snowflake Scripts
There are two Snowflake-script-type resources.
-
Snowflake DDL — includes DDL scripts from the Snowflake databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the Snowflake resource)
-
Snowflake SQL — includes SQL scripts that are executed against the Snowflake databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all Snowflake scripts |
| Directory | A directory containing Snowflake scripts and directories |
| Snowflake Script | Snowflake script containing SQL code |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| MultiTableInsert | Insert statement with multiple targets |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Merge | Merge statement |
| MergeInsert | Insert branch of a merge statement |
| MergeUpdate | Update branch of a merge statement |
| MergeDelete | Delete branch of a merge statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| Query | Standalone select statement |
| Subquery | Part of a standalone select statement |
| ColumnFlow | Column of a statement |
| ResultSetColumn | Column of a result set |
| TruncateTable | Truncate table statement |
| DropTableOrView | Drop table statement or drop view statement |
Hive
A Hive resource includes objects in database catalogs from all the Hive databases analyzed (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | Hive server |
| Database | Database in server |
| Table | Database table |
| View | Database view |
| Column | Database column of a view, table, or synonym |
| Function | Database function |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| StructureItem | Item of a record |
| ArrayItem | Item of an array |
Hive Scripts
There are two Hive-script-type resources.
-
Hive DDL — includes DDL scripts from the Hive databases analyzed (view definitions are contained directly under this resource, other definitions are contained under the respective elements in the Hive resource)
-
Hive HiveQL — includes HiveQL scripts that are executed against the Hive databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all Hive scripts |
| Directory | Directory containing Hive scripts and directories |
| Hive Script | Hive script containing HiveQL code |
| Expression | Expression containing transformation logic |
| RoutineCall | Call of a function |
| CallParameter | Parameter of a function call |
| CallResult | Result of a function call |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| TruncateTable | Truncate table statement |
| Query | Standalone select statement |
| ColumnFlow | Column of a statement |
BigQuery
A BigQuery resource includes objects in database catalogs from all the BigQuery projects analyzed (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | BigQuery server |
| Package | Package containing prefixed built-in functions |
| Database | Project in the server |
| Schema | Project dataset |
| Table | Dataset table |
| View | Dataset view |
| Column | Column of a view or table |
| Pseudocolumn | Not a real database column that behaves like a column (e.g., length of array) |
| Function | Dataset function |
| Procedure | Dataset stored procedure |
| Parameter | A formal parameter of a dataset function or stored procedure |
| ReturnValue | A formal return value of a dataset function |
| StructureItem | Item of a record |
| ArrayItem | Item of an array |
BigQuery Scripts
There are two BigQuery-script-type resources.
-
BigQuery DDL — includes DDL scripts from the BigQuery projects analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the BigQuery resource)
-
BigQuery SQL — includes SQL scripts that are executed against the BigQuery projects analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all BigQuery scripts |
| Directory | A directory containing BigQuery scripts and directories |
| BigQuery Script | BigQuery script containing SQL code |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Merge | Merge statement |
| MergeInsert | Insert branch of a merge statement |
| MergeUpdate | Update branch of a merge statement |
| MergeDelete | Delete branch of a merge statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| Query | Standalone select statement |
| ColumnFlow | Column of a statement |
| ResultSetColumn | Column of a result set |
| TruncateTable | Truncate table statement |
| DropTableOrView | Drop table statement or drop view statement |
| Return | Return statement |
| ExecuteDynamicSql | Execute immediate statement |
| ExecUsing | Using clause of an execute immediate statement |
| ExecInto | Into clause of an execute immediate statement |
| Export | Export data statement |
| VariableAssignment | Variable assignment statement |
BigQuery Job Scripts
A BigQuery job script resource includes job scripts containing job
definitions that are executed against the BigQuery projects analyzed and provided externally.
| Type | Description |
|---|---|
| Connection | Connection to a server containing all BigQuery job scripts |
| Directory | A directory containing BigQuery job scripts and directories |
| BigQuery Job Script | BigQuery job script containing job definition |
| BigQuery Job Query | BigQuery job configuration type “query“ |
| BigQuery Job Resultset | BigQuery job resultset |
| ColumnFlow | Column of a statement |
SAP HANA
An SAP HANA resource includes objects in the database catalog of the SAP HANA database analyzed (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Database | Database instance in a host |
| Schema | Database schema |
| Table | Database table |
| Virtual table | Database virtual table |
| View | Database view |
| Custom type | Database custom type |
| Column | Database column of a table, view or custom type |
| Index | Database Index |
| Function | Database function |
| Procedure | Database stored procedure |
| Parameter | Formal parameter of a database function or stored procedure |
| ReturnValue | Formal return value of a database function |
| Trigger | Database trigger |
| Sequence | Sequence |
| Library | Library |
| Remote source | Remote source |
SAP HANA Scripts
There are two SAP HANA script-type resources.
-
SAP HANA DDL — includes DDL scripts from the SAP HANA databases analyzed (view definitions are contained directly under this resource; other definitions are contained under the respective elements in the SAPHANA resource)
-
SAP HANA SQL — includes SQL scripts that are executed against the SAP HANA databases analyzed and provided externally
| Type | Description |
|---|---|
| Connection | Connection to a server containing all SAP HANA scripts |
| Directory | Directory containing SAP HANA scripts and directories |
| SAP HANA Script | SAP HANA script containing SQL code |
| Insert | Insert statement |
| Update | Update statement |
| Delete | Delete statement |
| Upsert | Upsert statement |
| SelectInto | Select into statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| TruncateTable | Truncate table statement |
| Query | Standalone select statement |
| Subquery | Part of a standalone select statement |
| ColumnFlow | Column of a statement |
Filesystem
A filesystem resource includes objects in the filesystem deduced using database, ETL, and reporting tools.
| Type | Description |
|---|---|
| Directory | Directory containing files and directories |
| File | File in the filesystem |
| Column | Column in a file |
Informatica PowerCenter
An IFPC resource includes objects from the Informatica PowerCenter repository.
| Type | Description |
|---|---|
| IFPC Repository | Informatica PowerCenter repository |
| IFPC Folder | Folder in the Informatica PowerCenter repository |
| IFPC Workflow | Informatica PowerCenter workflow |
| IFPC Session | Informatica PowerCenter session instance |
| IFPC Sorter | Sorter transformation |
| IFPC Rank | Rank transformation |
| IFPC Expression | Expression transformation |
| IFPC Source Qualifier | Source qualifier transformation |
| IFPC Application Source Qualifier | Application source qualifier transformation |
| IFPC App Multi-Group Source Qualifier | App multi-group source qualifier transformation |
| IFPC XML Source Qualifier | XML source qualifier transformation |
| IFPC Stored Procedure | Stored procedure transformation |
| IFPC Router | Router transformation |
| IFPC Joiner | Joiner transformation |
| IFPC Custom Transformation | Custom transformation (e.g., union) |
| IFPC Aggregator | Aggregator transformation |
| IFPC Lookup Procedure | Lookup procedure transformation |
| IFPC Filter | Filter transformation |
| IFPC Normalizer | Normalizer transformation |
| IFPC Sequence | Sequence transformation |
| IFPC Command Task | Command task |
| IFPC Transaction Control | Transaction control transformation |
| IFPC Target Definition | Target definition |
| IFPC Source Definition | Source definition |
| IFPC Update Strategy | Update strategy transformation |
| IFPC Port | Port of a transformation |
SSIS
An SSIS resource includes objects from the Microsoft SQL Server Integration Services repository.
| Type | Description |
|---|---|
| Server | SQL Server with SSIS repository |
| SSIS Folder | Folder in the SSIS repository |
| SSIS Project | SSIS project containing packages |
| SSIS Package | SSIS package |
| SSIS Handler | Handler for tasks |
| SSIS Sequence | Sequence |
| SSIS Loop | Loop of tasks |
| SSIS SqlTask | SQL task |
| SSIS BulkInsertTask | Bulk insert task |
| SSIS FileSystemTask | Filesystem task |
| SSIS DataFlowTask | Dataflow task |
| SSIS ExpressionTask | Expression task |
| SSIS FlatFileSource | Reading from flat file source |
| SSIS RawFileSource | Reading from raw file source |
| SSIS DatabaseSource | Reading from database source |
| SSIS FlatFileDestination | Writing to flat file destination |
| SSIS RawFileDestination | Writing to raw file destination |
| SSIS DatabaseDestination | Writing to database destination |
| SSIS UpsertDestination | PragmaticWorks TaskFactory Upsert Destination |
| SSIS DataConversion | Data conversion component |
| SSIS DerivedColumn | Derived column component |
| SSIS Sort | Sort component |
| SSIS ConditionalSplit | Conditional split component |
| SSIS Merge | Merge component |
| SSIS MergeJoin | Merge join component |
| SSIS Aggregate | Aggregate component |
| SSIS UnionAll | Union all component |
| SSIS Sampling | Sampling component |
| SSIS BalancedDataDistributor | Balanced data distributor component |
| SSIS RowCount | Row count component |
| SSIS CopyColumn | Copy column component |
| SSIS CharacterMap | Character map component |
| SSIS TermExtraction | Term extraction component |
| SSIS Audit | Audit component |
| SSIS Lookup | Lookup component |
| SSIS FuzzyGrouping | Fuzzy grouping component |
| SSIS Output | Output schema of component |
| SSIS Input | Input schema of component |
| SSIS ScriptComponent | Custom script component |
| Insert | Insert statement |
| FilesystemOperation | Filesystem operation |
| ColumnFlow | Column in component |
Talend
A Talend resource includes Talend objects that are provided externally.
| Type | Description |
|---|---|
| Connection | Talend script system |
| Directory | Directory containing Talend scripts and directories |
| Talend Archive File | Archive file (zip) |
| Talend Project | Talend project |
| Talend Job | Talend job |
| Talend Joblet | Talend joblet |
| Talend Joblet component | Talend joblet used inside job |
| Talend Component | Generic Talend component |
| Talend AggregateRow | Aggregate row component |
| Talend ConvertType | Convert type component |
| Talend FilterColumns | Filter columns component |
| Talend FilterRow | Filter row component |
| Talend Replace | Replace component |
| Talend Replicate | Replicate component |
| Talend SampleRow | Sample row component |
| Talend SortRow | Sort row component |
| Talend UniqRow | Unique row component |
| Talend SplitRow | Split row component |
| Talend FileInput | File input component |
| Talend FileOutput | File output component |
| Talend DbConnection | Database connection component |
| Talend DbInput | Database input component |
| Talend DbOutput | Database output component |
| Talend DbBulkExec | Database bulkExec component |
| Talend Unite | Unite component |
| Talend Join | Join component |
| Talend DenormalizeSortedRow | Denormalize sorted row component |
| Talend RowGenerator | Row generator component |
| Talend LogRow | Log row component |
| Talend FixedFlowInput | Fixed flow input component |
| Talend Filelist | Filelist component |
| Talend HMap | HMap component |
| Talend Map | Map component |
| Talend tExtractJSONFields | Extracts fields from JSON |
| Talend UniqRow | Filters unique and duplicates |
| Talend HMap | Maps complex structures |
| Talend BufferInput | Buffer input component |
| Talend BufferOutput | Buffer output component |
| Talend DBRow | Database row component |
| Talend FileInputExcel | Excel input component |
| Talend FileOutputExcel | Excel output component |
| Talend ELTOutput | ELT output component |
| Talend ExtractJSONFields | ExtractJsonFields component |
| Talend RestClient | Sends REST requests and receives responses |
| Talend Put | Put component |
| Talend Folder | Artificial folder representing zip structure |
| Talend Context | Contains instance of a job with the given context |
| Talend Schema | Schema of component |
| ColumnFlow | Column in a component |
ODI
An ODI resource includes projects from the ODI repository.
| Type | Description |
|---|---|
| ODI Repository | ODI repository |
| ODI Project | ODI project |
| ODI Folder | ODI folder |
| ODI Scenario | ODI scenario |
| ODI Package | Package |
| ODI Mapping | Mapping |
| ODI Map Component | Map component |
| ODI Lookup | Lookup component |
| ODI Pivot | Pivot component |
| ODI Unpivot | Unpivot component |
| ODI Subquery Filter | Subquery filter component |
| ODI Split | Split component |
| ODI Connector Point | Connector point attribute |
| ODI Set | Set component |
| ODI Table Function | Table function component |
| ODI Join | Join component |
| ODI Aggregate | Aggregate component |
| ODI Datastore | Datastore component |
| ODI Dimension | ODI dimension |
| ODI Cube | ODI cube |
| ODI Expression | Expression component |
| ODI Distinct | Distinct component |
| ODI Filter | Filter component |
| ODI Sort | Sort component |
| ODI Jagged | Jagged component |
| ODI Flatten | Flatten component |
| ODI Reusable Mapping Component | Reusable mapping component |
| ODI Attribute | ODI attribute |
| ODI Variable | ODI variable |
SSAS
An SSAS resource includes objects from the Microsoft SQL Server Analysis Services database provided as an exported file. Note that in Tabular Mode version 1200 and newer there are significant changes in the SSAS structure. (OLAP cubes are missing and other OLAP objects are replaced by tabular objects.)
| Type | Description |
|---|---|
| Server | SQL server with SSAS databases |
| Database | SSAS database |
| Data Source View | Single data set with data tables |
| Data Table | Data table of a data source view derived from a database table |
| Data Column | Data column of a data table derived from a database column |
| Cube | Multidimensional OLAP data cube |
| Dimension | OLAP dimension |
| Attribute | OLAP attribute |
| Measure | Measure |
| Calculated Member | Member of a dimension created by expression |
| Hierarchy | Hierarchy |
| Level | Level of a hierarchy |
| Set | Named set created by an expression |
| KPI | Key Performance Indicator that contains attributes for its value, goal, status, and trend expressions |
| Tabular Model | Tabular model (in Tabular Mode version 1200 and newer, it replaces database) |
| Table | Table in the tabular model (in Tabular Mode version 1200 and newer, it replaces dimension) |
| Column | Column of a table in the tabular model (in Tabular Mode version 1200 and newer, it replaces attribute) |
| Calculation Group | SSAS Calculation Group (only in Tabular Mode version 1500 and newer, supported) |
| Calculation Group Item | Column-analogue in a Calculation Group (only in Tabular Mode version 1500 and newer, supported) |
SSRS
An SSRS resource includes objects from the Microsoft SQL Server Reporting Services server.
| Type | Description |
|---|---|
| Server | SSRS server |
| SSRS Directory | Folder on the SSRS server |
| Report | Report |
| Chart | Chart data visualization |
| Data Series | Data series in a chart |
| Data Point | Data value in a data series |
| Gauge Panel | Gauge panel data visualization |
| Gauge | Gauge of a gauge panel |
| Gauge Scale | Gauge scale of a gauge |
| Gauge Pointer | Gauge pointer of a gauge scale |
| Value | Single value used by some data visualization elements |
| Tooltip | Tooltip of some data visualization elements |
| State Indicator | State indicator of a gauge panel |
| Gauge Label | Label of a gauge panel |
| Map | Map data visualization |
| Map Layer | Map layer of a map |
| Map Field | Map field of a map layer |
| Subreport | Subreport visualization element contains another report |
| Tablix | Tablix data visualization |
| Textbox | Textbox data visualization |
| Data Set | Represents data input created by a database query |
| Field | Field of a data set represents a query column |
| SSRS Collection | Built-in collection of some parameters |
| SSRS Object | Parameter of a SSRS collection |
| Parameter | Report parameter |
| Label | General label element |
| Shared Data Set | Data set defined outside any report that can be shared by multiple reports |
Excel
An Excel resource includes Excel workbooks that are provided externally.
| Type | Description |
|---|---|
| Connection | Excel application |
| Directory | Directory containing Excel workbooks and directories |
| Workbook | File containing an Excel workbook |
| Sheet | Sheet of a workbook |
| Chart | Chart of any of various types |
| Defined Name | Defined name |
| Query Table | SQL or PowerQuery table |
| Cell Table | Automatically detected table |
| Pivot Cache | Cache for pivot tables |
| Pivot Table | Pivot table |
| Slicer | Slicer |
| Data Series | Data series in a chart |
| Pivot Table Field | Field of a pivot table |
| Table Field | Field of a query or cell table |
| Data Point | Data point in a chart |
Cognos
A Cognos resource includes objects from the Cognos Content Store.
| Type | Description |
|---|---|
| Server | Cognos server |
| Content Store Folder | Folder in the content store or user hierarchy |
| Report | Report |
| Layout | Report layout |
| Page | Page inside a report’s layout |
| Report Item | Any visualization, chart, or data control element |
| Data Series | Data series used in a report item |
| Value | Single value used in a data series |
| Report Query | Data query in a report or a data set |
| Data Item | Data item in a query |
| Data Set | Dataset created as a snapshot of data from a data module or FM model |
| Framework Manager Model | Model built in the Framework Manager modeling tool |
| Tabular Namespace | Namespace inside an FM model that is not dimensionally modeled |
| Query Subject | Query subject in a tabular namespace or a data module |
| Query Item | Query item in a query subject, a dimension level, or inside a measure dimension within a cube |
| Data Module | Data module providing data for reports |
| Dimensional Namespace | Namespace inside an FM model that contains dimensions |
| Dimension | OLAP dimension in a dimensional namespace |
| Calculation List | Artificial container that holds all calculations in any namespace |
| Calculation | Calculation based on certain query items |
| Cube Designer Project | Project created in Cognos Dynamic Cube Designer |
| Cube | Cube inside a Cube Designer project |
| Relational Dimension | Dimension consisting of query items, defined in a cube |
| Measure Dimension | Dimension consisting of measures, defined in a cube |
| Measure | Measure within a measure dimension |
OBIEE
An OBIEE resource includes objects from the Oracle BI Presentation Catalog.
|
Type |
Description |
|---|---|
|
Server |
OBIEE server |
|
Catalog Folder |
A folder in the presentation catalog |
|
Subject Area |
Subject area |
|
Subject Area Table |
A table in a subject area |
|
Subject Area Column |
A column in a subject area table |
|
Dashboard |
Dashboard |
|
Dashboard Page |
Dashboard page |
|
Dashboard Column |
A column inside a dashboard page |
|
Dashboard Section |
A section inside a dashboard column |
|
Analysis |
Analysis |
|
Criteria |
Analysis criteria with source columns |
|
Compound View |
Compound view inside analysis |
|
Analysis Views (Funnel View, Gauge View, Chart View, Heat Matrix View, Performance Tile View, Pivot Table View, Table View, Treemap View, Trellis View) |
Different analysis views inside a compound view |
|
View Parameters (View Prompts, View Sections, View Measures, View Columns, View Rows, View Categories, View Series) |
Different parameters of an analysis view |
|
Data Field |
|
|
Data Model |
Data model providing data for reports |
|
Data Set |
Dataset inside a data model |
|
Data Set Group |
Subitem of a dataset containing other groups or elements |
|
Data Set Element |
Subitem of a dataset representing a single column from a data source |
|
Data Structure |
A special structure inside a data model containing information about data used in reports |
|
Data Structure Group |
Subitem of a data structure containing other groups or elements |
|
Data Structure Element |
Subitem of a data structure representing a single column from a data source |
|
Value Set |
A single value set from the list of values in a data model |
|
Parameter |
A parameter inside a data model |
|
Label |
|
|
Value |
|
|
Report |
Report |
|
BI Publisher Layout |
A layout of a report created in BI Publisher Editor |
|
Page |
A single page of a report |
|
Page Part |
Page part (page header, report header, body, report footer, page footer) |
|
Data Table |
Data table component of a report |
|
Data Column |
A single column inside a data table |
|
Chart |
Chart component of a report |
|
Gauge |
Gauge component of a report |
|
Graph |
Special graph inside gauges and charts |
|
Data Series |
Data series inside a chart or a gauge inside a report |
|
Layout Grid |
Layout grid component of a report |
|
Layout Grid Row |
A single row of a layout grid |
|
Layout Grid Cell |
A single cell of a layout grid |
|
Report Item Container |
Special container for report items such as data list and data field |
|
Data List |
List component of a report |
|
Pivot Table |
Pivot table component of a report |
|
Pivot Column |
A single column of a pivot table |
|
Pivot Row |
A single row of a pivot table |
|
Measure |
A measure of a pivot table |
|
Repeating Section |
Repeating section component of a report |
Power BI
A Power BI resource includes objects from the Power BI Catalog.
| Type | Description |
|---|---|
| Server | Power BI server |
| Workspace | Folder containing reports |
| Report | Report |
| DataModel | Abstract data model of the report |
| Data Table | Data table inside the DataModel |
| Data Column | Column of a data table |
| Hierarchy | Hierarchy inside a data table |
| Aggregation | Aggregation of data columns inside a data table |
| Measure | Measure inside a data table |
| Page | Page in a report |
| Report Item | Any visualization, chart, or data control element |
| Select | Represents a select from DataModel to report item |
Tableau
Tableau resources include objects from Tableau server.
| Type | Description |
|---|---|
| Tableau Site | A site on a Tableau server |
| Tableau Project | Project inside a site (or inside another project) |
| Tableau Workbook | Tableau workbook |
| Tableau Data Source | Tableau data source |
| Page | Worksheet |
| Dashboard | Dashboard (set of worksheets) inside a workbook |
| Story | Story (series of worksheets and/or dashboards) inside a workbook |
| Tableau Relation | Set of columns (result of an operation on the data) |
| Field | Column in a data source or a workbook |
| Report Item | One chart in a worksheet; if the chart is split into multiple parts, a report item represents only one part of the chart |
| Property | Property of a chart—for example, mark color, mark size, or horizontal/vertical axis |
| Value | Value used to set a property; it can be the result of an aggregation of a column (e.g., sum or average) or a raw value in the column |
StreamSets
StreamSets resources include objects from the StreamSets Data Collector server.
| Type | Description |
|---|---|
| Server | StreamSets Data Collector server |
| StreamSets Job | Job |
| StreamSets Pipeline | Pipeline |
| StreamSets Default Stage | The default stage represents unsupported data lineage in the StreamSets scanner |
| StreamSets JDBC Query Consumer Stage | JDBC Query Consumer stage |
| StreamSets Directory Stage | Directory stage |
| StreamSets Salesforce Stage | Salesforce stage |
| StreamSets Hadoop FS Standalone Stage | Hadoop FS Standalone stage |
| StreamSets Kafka Multitopic Consumer Stage | Kafka Multitopic Consumer stage |
| StreamSets Oracle CDC Client Stage | Oracle CDC Client stage |
| StreamSets PostgreSQL CDC Client | PostgreSQL CDC Client |
| StreamSets Expression Evaluator Stage | Expression Evaluator stage |
| StreamSets Field Splitter Stage | Field Splitter stage |
| StreamSets Field Replacer Stage | Field Replacer stage |
| StreamSets Field Renamer Stage | Field Renamer stage |
| StreamSets Schema Generator Stage | Schema Generator stage |
| StreamSets Field Remover Stage | Field Remover stage |
| StreamSets Stream Selector Stage | Stream Selector stage |
| StreamSets Field Masker Stage | Field Masker stage |
| StreamSets Hive Metadata Stage | Hive metadata stage |
| StreamSets Field Order Stage | Field order stage |
| StreamSets Field Hasher Stage | Field hasher stage |
| StreamSets Field Type Converter Stage | Field Type Converter stage |
| StreamSets Field Pivoter Stage | Field Pivoter stage |
| StreamSets Data Parser Stage | Data Parser stage |
| StreamSets Trash Stage | Trash stage |
| StreamSets Local FS Stage | Local FS stage |
| StreamSets Kafka Producer Stage | Kafka Producer stage |
| StreamSets HTTP Client Stage | HTTP Client stage |
| StreamSets Hive Metastore Stage | Hive Metastore stage |
| StreamSets Hadoop FS Stage | Hadoop FS stage |
| StreamSets JDBC Producer Stage | JDBC Producer stage |
| StreamSets Shell Stage | Shell stage |
| StreamSets BigQuery Source Stage | BigQuery source stage |
| StreamSets BigQuery Destination Stage | BigQuery destination stage |
| StreamSets Group Field | Node that connects a group of fields |
| Field | Elementary object in StreamSets |
Default
All resources that do not belong to any of the above types have this
default type. Here are some common resources that have this type.
-
ODBC — includes objects deduced using ETL and reporting tools where an ODBC connection without any mapping is used
-
JDBC — includes objects deduced using ETL and reporting tools where a JDBC connection without any mapping is used
-
HBase — includes objects deduced using ETL and reporting tools where a connection to an HBase database is used
-
Accumulo — includes objects deduced using ETL and reporting tools where a connection to an Accumulo database is used
-
Informix — includes objects deduced using ETL and reporting tools where a connection to an Informix database is used
-
Vertica — includes objects deduced using ETL and reporting tools where a connection to a Vertica database is used
-
Web Services Consumer, HTTP Transformation, Power Exchange, Message Queue, MSMQ, SAP R3, SAP RFC/BAPI Interface, Salesforce, etc.—includes objects deduced using ETL and reporting tools where a connection to these applications is used
| Type | Description |
|---|---|
| Server | Database server |
| Database | Database |
| Schema | Database schema |
| Table | Database table |
| View | Database view |
| Macro | Database macro |
| Column | Database column of a view, table, or synonym |
| Procedure | Database stored procedure |
| Function | Database function |
| Parameter | Formal parameter of a database function or stored procedure |
| Application | Application |
| Service | Application service |
SAP BO
An SAP BO resource includes objects from SAP BO server.
| Type | Description |
|---|---|
| Server | SAP BO server |
| Folder | Folder in the SAP BO server |
| Document | Report |
| Report | Page inside a document |
| Report Element | Any visualization, cell, table, or section in a report |
| Report Element Cell | A simple cell; can stand alone or be in a table |
| Report Element HTable | Horizontal table |
| Report Element VTable | Vertical table |
| Report Element XTable | Cross table |
| Report Element Form | Special kind of tabular element |
| Report Element Section | Contains another report element, copies it for each cut in a dimension of a data cube |
| Section Expression | Defines a cut in a data cube |
| Report Element Visualization | Visualization; many different forms of a graph |
| Visualization Plot Area | Plot area |
| Plot Area Tile Series | Tile series in a plot area |
| Axis | Axis in different types of elements |
| Ranking | Used in tables and visualization; determines element ranking |
| Hide | Says whether the report element is visible or not |
| Value | Single value used in report elements |
| Label | Single label used in report elements |
| Data Provider | Data provider of a given document |
| Data Provider Expression | Single expression in a data provider |
| Document Variable | Variable defined in a document; can be used in its reports |
| Universe | Model containing business objects |
| Business Object | Dimension, measure, attribute, or filter |
| Data Foundation | Data source for a universe; contains one or more connections to databases |
Cobol Scripts
A Cobol resource includes Cobol scripts that are provided externally.
| Type | Description |
|---|---|
| Connection | Cobol/JCL script system |
| Cobol Program | A Cobol program |
| Cobol Program Parameter | A parameter of a Cobol program |
| Cobol Procedure Section | Name of a procedure section in Cobol |
| Cobol Paragraph | Name of a paragraph in Cobol |
| Cobol ADD Statement | Add statement in Cobol |
| Cobol COMPUTE Statement | Compute statement in Cobol |
| Cobol SUBTRACT Statement | Subtract statement in Cobol |
| Cobol MULTIPLY Statement | Multiply statement in Cobol |
| Cobol DIVIDE Statement | Divide statement in Cobol |
| Cobol MOVE Statement | Move statement in Cobol |
| Cobol INSPECT Statement | Inspect statement in Cobol |
| Cobol INITIALIZE Statement | Initialize statement in Cobol |
| Cobol ACCEPT Statement | Accept statement in Cobol |
| Cobol READ Statement | Read statement in Cobol |
| Cobol DELETE Statement | Delete statement in Cobol |
| Cobol WRITE Statement | Write statement in Cobol |
| Cobol REWRITE Statement | Rewrite statement in Cobol |
| Cobol STRING Statement | String statement in Cobol |
| Cobol UNSTRING Statement | Unstring statement in Cobol |
| Cobol SORT Statement | Sort statement in Cobol |
| Cobol MERGE Statement | Merge statement in Cobol |
| Cobol SEARCH Statement | Search statement in Cobol |
| Cobol CALL Statement | Call statement in Cobol |
| Cobol Statement Condition | Additional condition in any statement |
| Cobol Group Item | Cobol group data item |
| Cobol Elementary Item | Cobol elementary data item |
| Cobol Level 77 Data Item | Cobol (elementary) level-77 data item |
| Cobol File Item | Cobol file item |
| Cobol Index Variable | Cobol index variable for indexing tables (arrays) |
| Cobol Array Data Item | Cobol data item representing a table (array) |
| ColumnFlow | (Virtual) data item modified in a statement |
JCL Scripts
A JCL resource includes JCL scripts that are provided externally.
| Type | Description |
|---|---|
| JCL Job | Job in a JCL script |
| JCL Procedure | Procedure in a JCL script |
| JCL Execution | JCL execution of a JCL job or procedure |
| JCL Defined Dataset | JCL defined dataset |
| Column | JCL defined dataset column |
| Parameter | JCL execution parameter |
Custom Script Scanner
A custom script scanner resource includes objects created by annotations from the processed script files.
| Type | Description |
|---|---|
| Custom Script | Input script file |
| Custom Query | Defined query (generated from @MANTASQL annotation) |
| Custom Transformation | Defined transformations (generated from @MANTALineage annotation) |
SAS
An SAS resource includes SAS objects in libraries from all analyzed SAS scripts (including those deduced using ETL and reporting tools).
| Type | Description |
|---|---|
| Server | SAS server |
| SAS Directory | Library directory |
| Table | Library table |
| View | Library view |
| Column | Library column of a view, table, or synonym |
| Synonym | Library synonym to a table or view |
| ReturnValue | Formal return value of a function |
| SAS Dataset | Dataset containing packages |
| Package | Package containing functions and subroutines |
| Function | Function |
| Procedure | Subroutine |
| Parameter | Parameter of a function or subroutine |
SAS Code
An SAS code resource includes SAS scripts that are provided externally.
| Type | Description |
|---|---|
| Connection | Connection to a server containing all SAS scripts |
| SAS Library | Library reference |
| SAS Program | SAS program containing SAS code |
| RoutineCall | Call of a procedure or function |
| CallParameter | Parameter of a procedure or function call |
| CallResult | Result of a function call |
| Merge | Merge statement |
| Insert | Insert or set statement |
| Update | Update statement |
| Delete | Delete statement |
| Rename | Rename statement |
| CreateView | Create view statement |
| CreateTable | Create table statement |
| DropTableOrView | Drop table statement or drop view statement |
| Query | Standalone select statement |
| Subquery | Part of a standalone select statement |
| ColumnFlow | Column of a statement |
| ResultSetColumn | Column of a result set |
| If | If statement |
| Case | Case statement |
Kafka
Kafka resources include objects from the Kafka Schema Registry or a manual definition file.
| Type | Description |
|---|---|
| Kafka Cluster | Kafka cluster |
| Kafka Topic | Topic |
| Kafka Schema | Topic schema |
| Column | Schema column |
Fivetran
A Fivetran resource includes Fivetran objects that are provided externally.
| Type | Description |
|---|---|
| Server | Fivetran Server |
| Fivetran Destination | Destination resource |
| Fivetran Source Connector | Connector before application of naming conversions |
| Fivetran Destination Connector | Connector after application of naming conversions |
| Fivetran Source Schema | Schema from the connector before application of naming conversions |
| Fivetran Destination Schema | Schema from the connector after application of naming conversions |
| Fivetran Source Table | Table from the schema before application of naming conversions |
| Fivetran Destination Table | Table from the schema after application of naming conversions |
| Fivetran Source Column | Column from the table before application of naming conversions |
| Fivetran Destination Column | Column from the table after application of naming conversions |
| Fivetran Transformation Project | SQL transformation project |
| Fivetran SQL Query | SQL query from the project |
Matillion
Matillion resources include objects from the Matillion server.
| Type | Description |
|---|---|
| Server | Matillion server |
| Project Group | A logical grouping of projects |
| Project | Project |
| Project Version | Project version |
| Project Environment | Describes which sets of target cloud database platform credentials to use for a connection |
| Job Folder | A logical separation of jobs within a project |
| Orchestration Job | Orchestration job |
| Transformation Job | Transformation job |
| Database Query Component | Database query orchestration component |
| Create Table Component | Create table orchestration component |
| Delete Tables Component | Delete tables orchestration component |
| SQL Script Component | SQL script orchestration component |
| Truncate Table Component | Truncate table orchestration component |
| Start Component | Start orchestration component |
| And Component | And orchestration component |
| Or Component | Or orchestration component |
| If Component | If orchestration component |
| End Success Component | End success orchestration component |
| End Failure Component | End failure orchestration component |
| Retry Component | Retry orchestration component |
| Run Orchestration Component | Run orchestration orchestration component |
| Run Transformation Component | Run transformation orchestration component |
| Append to Grid Component | Append to grid orchestration component |
| Remove From Grid Component | Remove from grid orchestration component |
| Query Result to Scalar Component | Query result to scalar orchestration component |
| Begin Component | Begin orchestration component |
| Commit Component | Commit orchestration component |
| Rollback Component | Rollback orchestration component |
| Shared Job Component | Shared job orchestration component |
| Unknown Orchestration Component | Represents an unsupported or unknown orchestration component |
| Table Input Component | Table input transformation component |
| Multi Table Input Component | Multi table input transformation component |
| Fixed Flow Component | Fixed flow transformation component |
| Join Component | Join transformation component |
| Unite Component | Unite transformation component |
| Aggregate Component | Aggregate transformation component |
| Calculator Component | Calculator transformation component |
| Detect Changes Component | Detect changes transformation component |
| SQL Component | SQL transformation component |
| Filter Component | Filter transformation component |
| First/Last Component | First/last transformation component |
| Rename Component | Rename transformation component |
| Replicate Component | Replicate transformation component |
| Distinct Component | Distinct transformation component |
| Rank Component | Rank transformation component |
| Convert Type Component | Convert type transformation component |
| Transpose Columns Component | Transpose columns transformation component |
| Window Calculation Component | Window calculation transformation component |
| Table Output Component | Table output transformation component |
| Rewrite Table Component | Rewrite table transformation component |
| Table Update Component | Table update transformation component |
| Create View Component | Create view transformation component |
| Unknown Transformation Component | Represents an unsupported or unknown transformation component |
| Column | Column of a component |
MicroStrategy
MicroStrategy resources include objects from the MicroStrategy server.
| Type | Description |
|---|---|
| Server | MicroStrategy server |
| MicroStrategy Project | Project |
| MicroStrategy Dossier | Dossier |
| MicroStrategy Report | Report |
| MicroStrategy Cube | Cube |
| MicroStrategy Folder | Folder |
| MicroStrategy Artificial Folder | Wrapper around facts and metrics |
| MicroStrategy Chapter | Dossier chapter |
| MicroStrategy Page | Dossier page |
| MicroStrategy Visualization | Visualization |
| MicroStrategy Attribute | Attribute |
| MicroStrategy Logical Table | Logical table |
| MicroStrategy Attribute Usage | Attribute usage |
| MicroStrategy Metric Usage | Metric usage |
| MicroStrategy Attribute Form | Attribute form |
| MicroStrategy Metric | Metric |
| MicroStrategy Fact | Fact |
| MicroStrategy Column | Logical table column |
Custom Reports
A custom report resource includes common reporting tool objects.
| Type | Description |
|---|---|
| Server | Reporting server, used to separate different instances of the reporting tool |
| Report | Report, or any other form of a document, usually containing multiple pages/sheets |
| Report Item | Chart, map, graph, or any other form of single data visualization element |
| Data Series | Can represent a chart’s axis, a map’s color, a calculation of multiple columns, a context for values used, or any other set of non-atomic operations or groupings |
| Value | Usually a single value, label, set of values, or anything on the column lineage level |
Custom ETL
A custom ETL resource includes common ETL tool objects.
| Type | Description |
|---|---|
| Connection | Connection to an ETL tool |
| Folder | Supports the creation of a structured hierarchy for custom ETL |
| Project | Supports the creation of a structured hierarchy for custom ETL |
| Job | The main unit that defines the data flow of custom ETL |
| Transformation | Transformation |
| Component | Component |
| Operation | Operation |
| Column | Element (leaf) of custom ETL |
Attribute Types
Here is a list of attribute types produced by Manta Flow connectors.
|
Type |
Description |
|---|---|
|
error |
Contains a message describing an error that occurred during script analysis |
|
warning |
Contains a message describing a warning during script analysis |
|
OBJECT_SOURCE_TYPE |
Whether an object was found in a database or a script or if it was deduced
|
|
DESCRIPTION |
Human readable description of an object |
|
COMMENT_STRING |
Human readable comment on an object |
|
TRANSFORMATION_DESC |
Transformation logic applied to a column |
|
TABLE_TYPE |
Type of table or view |
|
VIEW_TYPE |
Type of view |
|
COLUMN_CHARSET |
Column charset |
|
COLUMN_LENGTH |
Column length |
|
COLUMN_TYPE |
Data type of the table column as read from database |
|
COLUMN_NULLABILITY |
Whether a column can be null or not |
|
COLUMN_DEFAULT_VALUE |
Default value of a column |
|
DATA_TYPE |
Data type of the table column standardized to data type names from https://docs.oracle.com/en/java/javase/24/docs/api/java.sql/java/sql/Types.html |
|
ORDER |
Order of a column/parameter in an object |
|
tpt column description |
Description of a column read or written in TPT script |
|
ifpc column description |
Description of a column read or written during an Informatica PowerCenter session |
|
PARAMETER_TYPE |
Parameter type |
|
IFPC_MAPPING |
Informatica PowerCenter mapping assigned to a session |
|
FILTER_CONDITION |
Filter condition |
|
JOIN_CONDITION |
Join condition |
|
GROUPBY_PORTS |
The result is grouped by ports listed here |
|
ORDERBY_PORTS |
The result is ordered by ports listed here |
|
EXPRESSION |
Logical expression |
|
GROUP_EXPRESSION |
Group expression |