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