Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

SYSTEMPROVIDERS: Data Dictionary Providers

Contents Previous Home Next More

All registered and licensed providers available in Invantive SQL.

Catalog: DataDictionary

Schema: Invantive

Alias: pvr

Label: Providers

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

View Columns

The columns of the view SYSTEMPROVIDERS are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ABBREVIATION

string(3)

Abbreviation

☑

Abbreviation.

COMMERCIAL_NAME

string(240)

 

☑

Commercial name.

COMMUNITY_EDITION

boolean

Is Community Edition

☑

Is application software offered for free?

DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

☐

Data container alias.

DATA_CONTAINER_ID

string(4000)

Data Container ID

☐

Data container ID.

DEFAULT_CONNECTION_ID

guid

Default Connection ID

☑

Default GUID for first discovered connection of this connector.

DEFAULT_NUMBER_PARALLEL_REQUESTS

int32

Default Number of Parallel Requests

 

Default number of parallel requests.

DEFAULT_SLOTBASED_RATE_LIMIT_LENGTH_MS

int32

Default Slot-based Rate Limit Length (ms)

☑

Default length in ms of a slot-based rate limit.

DEFAULT_SLOTBASED_RATE_LIMIT_SLOTS

int32

Default Slot-based Rate Limit Slots

☐

Default number of slots of a slot-based rate limit.

DESCRIPTION

string(16000)

Description

☑

Description.

DISPLAY_NAME

string(240)

Display Name

☑

Display name.

DOCUMENTATION_URL

string(4000)

Documentation (URL)

☐

Documentation URL.

DOCUMENTATION

string(32767)

Documentation

☐

Documentation.

DOWNLOAD_IMPLEMENTATION_URL

string(4000)

Download Implementation URL

☐

Download URL for implementation.

ICON_RESOURCE_NAME_16

string(240)

Icon Resource Name (16x16)

☐

Name of file with 16x16 icon.

INFLUENCES_MAXIMUM_NUMBER_JOINS

boolean

Influences Maximum Number of Joins

☑

Influences maximum number of joins?

IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME

boolean

Is Catalog Used in Full Qualified Name

☑

Whether the catalog name is used in constructing the full qualified name.

IS_DEFAULT_FLAG

boolean

Is Default?

☑

Is the default connector?

IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME

boolean

Is Schema Used in Full Qualified Name

☑

Whether the schema name is used in constructing the full qualified name.

IS_SERVICE_PROVIDER_FLAG

boolean

Is Service Provider?

☑

Is the connector a service connector?

MAIN_CATEGORY

string(240)

 

☑

Main category.

MAXIMUM_NUMBER_USABLE_PARTITIONS

int32

Maximum Number of Usable Partitions

 

Maximum number of usable partitions.

NAME

string(240)

Name

☑

Name of the connector.

PARTITION_CODE_COLUMN_NAME

string(240)

Partition Code Column Name

☐

Name of the partition code column.

PARTITION_INFO_ALL_PARTITIONS_SELECTED

boolean

 

☑

Whether the connector has selected all partitions.

PARTITION_INFO_LABEL_SINGULAR

string(240)

 

☐

Partition label in singular form.

PARTITION_INFO_PREFERRED_UI_LABEL_PLURAL

string(240)

 

☐

Partition preferred UI label in plural form.

PARTITION_INFO_PREFERRED_UI_LABEL_SELECTED_ELEMENTS

string(240)

 

☐

Partition preferred UI label for selected elements.

PARTITION_INFO_PREFERRED_UI_LABEL_SELECTOR

string(240)

 

☐

Partition preferred UI label for selector.

PARTITION_INFO_PREFERRED_UI_LABEL_SINGULAR

string(240)

 

☐

Partition preferred UI label in singular form.

PARTITION_INFO_SUPPORTS_MULTIPLE_SELECTED_PARTITIONS

boolean

Supports Multiple Selected Partitions

☑

Whether the connector supports multiple selected partitions.

PARTITION_INFO_SUPPORTS_NO_SELECTED_PARTITIONS

boolean

 

☑

Whether the connector supports no selected partitions.

PARTITION_INFO_SUPPORTS_PARTITIONS

boolean

Supports Partitions

☑

Whether the connector supports partitions.

PARTITION_LABEL_SINGULAR

string(240)

Partition Label Singular

☐

Partition label in singular form.

PARTITIONS_INFO_LABEL_PLURAL

string(240)

 

☐

Partition label in plural form.

PARTITIONS_INFO_MASTER_ROLLUP_LABEL

string(240)

 

☐

Partition master rollup label in singular form.

PARTITIONS_INFO_ROLLUP_LABEL

string(240)

 

☐

Partition rollup label in singular form.

PRODUCTION_USE_ALLOWED

boolean

Production Use Allowed

☑

Is production use allowed?

PUBLIC_DATA

boolean

Is Public Data?

☑

Is the data offered publicly?

SHORT_NAME_RESOURCE

string(240)

Short Name for Resources

☑

Short name for use in translation resources.

SHORT_NAME

string(240)

Short Name

☑

Short name.

SLOTBASED_RATE_LIMIT_LENGTH_MS

int32

Slot-based Rate Limit Length (ms)

☑

Length in ms of a slot-based rate limit.

SLOTBASED_RATE_LIMIT_SLOTS

int32

Slot-based Rate Limit Slots

☐

Number of slots of a slot-based rate limit, null means no limit.

SQL_PREFIX_PARAMETER

string(30)

SQL Prefix Parameter

☐

SQL parameter prefix.

STRING_COMPARISON_IS_CASE_SENSITIVE

boolean

String Comparison is Case-Sensitive

☑

Whether the connector matches string case-sensitive.

SUPPORTS_COLUMN_FILTERING

boolean

Supports Column Filtering

☑

Whether column filtering is supported; if true, the connector can filter the resulting columns itself based on a select statement.

SUPPORTS_NATIVE_SCALAR_REQUESTS

boolean

Supports Native Scalar Requests

☑

Whether the platform supports native scalar requests.

SUPPORTS_NATIVE_SQL

boolean

Supports Native SQL

☑

Whether the platform supports native SQL.

SUPPORTS_ORDERING

boolean

Supports Ordering

☑

Whether the connector supports ordering.

SUPPORTS_SIMPLE_FILTER_DELETE

boolean

Supports Simple Filter Delete

☑

Whether the connector supports delete using simple filters.

SUPPORTS_SIMPLE_FILTER_UPDATE

boolean

Supports Simple Filter Update

☑

Whether the connector supports update using simple filters.

TECHNICAL_DOCUMENTATION_URL

string(4000)

Technical Documentation (URL)

☐

Technical documentation URL.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191